Change of Sign for Expense Account Amounts in Transaction Saved Searches

Before 2014.1 release, saved searches treated expense accounts as credit accounts, so transaction saved searches displayed positive amounts for credit posting transactions and negative amounts for debit posting transactions (this behavior impacted saved searches only; not reports or accounting processes).

Now, saved searches treat expense accounts as debit accounts, so transaction saved searches show positive amounts for debit posting transactions and negative amounts for credit posting transactions. This ensures that expense accounts are handled consistently throughout NetSuite.

Review your transaction saved searches with Expense accounts to check how these amounts are displayed.

If there's a transaction saved search where you need to maintain the behavior that existed in the past, edit the search to flip the sign of the impacted amount fields such as Amount, Amount (Alt.Sales), or Amount (Gross).
Flip the sign of an impacted amount field by replacing that field, for example Amount (Gross), with a formula field like the following: DECODE({accounttype}, 'Expense', -1, 'Other Expense', -1, 'Cost of Goods Sold', -1, 1) *{grossamount}.

See the following table for formula examples to flip the sign of amount fields.

Result Field

Formula Field

Suggested Formula

Amount

{amount}

DECODE({accounttype}, 'Expense', -1, 'Other Expense', -1, 'Cost of Goods Sold', -1, 1) *{amount}

Amount (Alt. Sales)

{altsalesamount}

DECODE({accounttype}, 'Expense', -1, 'Other Expense', -1, 'Cost of Goods Sold', -1, 1) *{altsalesamount}

Amount (Alt. Sales Net)

{altsalesnetamount}

DECODE({accounttype}, 'Expense', -1, 'Other Expense', -1, 'Cost of Goods Sold', -1, 1) *{altsalesnetamount}

Amount (Foreign Currency)

{fxamount}

DECODE({accounttype}, 'Expense', -1, 'Other Expense', -1, 'Cost of Goods Sold', -1, 1) *{fxamount}

Amount (Gross)

{grossamount}

DECODE({accounttype}, 'Expense', -1, 'Other Expense', -1, 'Cost of Goods Sold', -1, 1) *{grossamount}

Amount (Net)

{netamount}

DECODE({accounttype}, 'Expense', -1, 'Other Expense', -1, 'Cost of Goods Sold', -1, 1) *{netamount}

Amount (Net of Tax)

{netamountnotax}

DECODE({accounttype}, 'Expense', -1, 'Other Expense', -1, 'Cost of Goods Sold', -1, 1) *{netamountnotax}

Amount (Transaction Total)

{totalamount}

DECODE({accounttype}, 'Expense', -1, 'Other Expense', -1, 'Cost of Goods Sold', -1, 1) *{totalamount}

Related Topics