Amount of non Inventory item is showing negative on saved searches

Problem/Business Requirement/Unique Question:

-Amount of non Inventory item is showing negative on saved searches 

Symptoms/Details of Business Requirements/Any Additional Information:

-Customer created a transaction saved search for Purchase Order with the following criteria and results:

-- Criteria Tab:

---Type = is Purchase Order

---Main = is false

--Results tab:

---Field-------------Summary Type

---Type------------Group

---Number---------Group

---Amount---------Sum

 

-Customer previewed the search and noticed that one of the purchase orders is showing 0.00 when it should be $2.00. 

-Customer viewed the transaction detail, it is showing that the PO has two different items; one is a non-inventory item with $1.00 amount and an inventory item with $1.00.

-Customer previewed the search again and drilled down the purchase order and noticed that non-inventory item is showing -$1.00 while the inventory item is showing $1.00

-Customer verified the non-inventory item and noticed that it has a COGS account type indicated on Expense account field.

 

Solution/Workaround/Gotcha/Recommendation Details:

-Amount (Debit) should be used on the Results tab of the saved search instead of Amount, the reason being is because when Amount field is used, those non-inventory items posted under COGS account type are being shown as negative thus deducting the purchase amount of those items from the total.

-COGS account type should not be use as an Expense account for Non-inventory items since this account has not effect on this type of item since it has no costing method.