Discrepency in the value of PO item line were there is Tax amount.

Scenario

There is a discrepancy in the Total Amount of PO item line in a Saved Search Report of type bill.

Reason

The amount and Tax amount is calculated seperatley by NetSuite. In this case the to get total value a sum of amount and tax amount must be done.

Now there problem rises when the account linked to expense or titem in item line is liablity or income there will be discrepancy as it is considered negative value.

Solution

In saved Search Result:

Provide formula currency

In formula filed provide ABS({appliedtotransaction.amount})+ABS({appliedtotransaction.taxamount})