Difference between Amount and Amount (Signed) Column Fields in a Purchase Order Transaction Search

Those Purchase Orders that had a negative value on the Amount line items have an Expense Account Type while those with positive value on the Amount line items have an Asset or Other Current Asset Account Type. Hence, all Expense Accounts are shown as a negative in the Amount field while Amount (Signed) behaves as an absolute value, not taking into consideration the normal balance of an account.

Amount (Signed) column field may be used should the customer need to see expenses on the Purchase Order Transaction Search in absolute value (positive).

To illustrate:

1. Make sure that there are Purchase Orders with expense/s under Items tab > Expenses subtab. GL Impact of these Purchase Orders may be:

Debit to an Asset Account Type or Other Current Asset Account Type
Debit to an Expense Account Type
Credit Purchase Orders (a Non Posting Account Type)

Or,

Debit to an Expense Account Type
Credit Purchase Orders (a Non Posting Account Type)

2. Navigate to Transactions > Purchases/Vendors > Enter Purchase Orders > Search (Administrator).

3. Click Create Saved Search button.

4. On the Saved Transaction Search screen, navigate to Criteria tab > Standard subtab.

5. Add this filter.:

Main Line = is false

Hence, filters should show the following:

Type = is Purchase Order
Main Line = is false

6. Navigate to Results tab > Columns subtab.

7. Make sure to have the following column fields:

Date
Type
Number
Account
Amount
Amount (Signed)
Account Type

8. Notice that Expense Account Type on an Expense account line level reflects the Amount in negative while positive in the Amount (Signed) column field.