ANS-0064 · SAVED SEARCHES & FORMULAS
How to Display Positive Amounts for Vendor Bill Line Items in NetSuite Saved Searches?
Understand how NetSuite account types influence positive and negative values in saved searches and apply a simple function to ensure consistent display of line item amounts.
Short answer
The issue of positive or negative amounts in NetSuite saved searches for vendor bill line items is often due to account type behavior. To consistently display only the absolute value of the amount, use the ABS({amount}) function within your saved search criteria or results. This ensures all amounts appear as positive.
Scenario
Users may observe that amount values for vendor bill line items in NetSuite saved searches appear as either positive or negative. This behavior is inherent to how NetSuite handles debit and credit entries across various account types. The goal is often to display only the absolute value of these amounts, regardless of their original sign.
Solution
To ensure that only the absolute amount value is displayed for vendor bill line items in a NetSuite saved search, utilize the ABS() function. This function converts any negative value to its positive equivalent while leaving positive values unchanged. Apply the following formula in your saved search results or criteria: ABS({amount}) This will effectively resolve instances where amounts might appear as negative due to account type configurations, presenting all line item amounts as positive values.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support