Anyone aware of a way to show line-level amounts in a Saved Search on POs the same as they appear in the UI? (e.g. in the UI, a line level amount might appear as positive 100, while in a saved search it appears as -100, depending on the line level account selected).

Use a formula and absolute value it would be my first thought.

My thought as well, the problem is that lines can actually be negative.

If they can be negative, then whats the problem. You are saying if the quantity is negative, the amount should be as well?

not sure what kind of wild accounting where some of your asset accounts are liabilities

I'll take a look those, thanks battk - yeah, it's a strange edge case we ran into with a client.

There are three different Amount fields : Amount, Amount(debit), Amount(Credit) Amount has simple logic positive = increase, negative=decrease balance of account. Depending on the account type (for short example expense and income) Amount value goes to debit or credit Positive value in amount field for expense goes to debit. om the other side for income type positive value goes to credit

thats not the behavior of the amount(debit) column for purchase orders, its a debit regardless of the account type column or amount column's sign