Community Care and Share: Negative Quantity in Transaction Saved Search
There are times when the Quantity and Amount of a specific item in a Transaction Saved Search shows a Negative value, even if you are expecting it to show as positive
The most common reason is: the GL accounts are reversed under the Item Record’s Accounting tab.
The normal account used for Item Accounts should be as follows:
- COGS Account field = COGS Account type
- Income Account field = Income Account type
It is possible that the accounts are interchanged as follows:
- COGS Account field = Income Account type
- Income Account field = COGS Account type
For example, I have an item which the Income Account field is populated with another account type (Expense). It seems that the display is based on the expected GL impact for a sales transaction.