Nada Ahmed
09/26/2024, 12:19 AMCeligo AI
09/26/2024, 12:19 AMAI generated answer (using internal Slack threads):In NetSuite, to show a negative amount as a positive in a saved search, you can use the "Absolute" function for the amount field in the saved search. This function will convert all negative values to positive. Here is how you can do it: 1. Go to your saved search and click on the 'Results' tab. 2. Click on 'Add New Field' and select the field you want to convert from negative to positive. 3. In the 'Summary Type' dropdown, select 'Formula (Numeric)'. 4. In the 'Formula' field, enter
ABS({fieldname})
where 'fieldname' is the name of the field you want to convert.
5. Click 'Save'.
Please note that this will only affect the display of the data in the saved search, not the actual data in the database. Also, be aware that if you have any lines that are actually negative, they will show up as positive in the search results.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
09/26/2024, 12:19 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.861429572
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.853072762
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.852014244
Celigo AI
09/26/2024, 12:19 AM