how to change amount remaining field to a negative for credits

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that the Amount Remaining field for credit memos in NetSuite is showing as a positive value in saved searches, which is causing some confusion. To change the Amount Remaining field to a negative for credits, you can use a custom formula in your saved search. Here are a couple of methods that were suggested: 1. Use a custom currency formula to subtract out the credits twice to turn them negative. The formula would look something like this:

{amountremaining} - NVL({creditamount}, 0) - NVL({creditamount},0)

2. Another method is to multiply the Amount Remaining by -1 when the original amount is positive. The formula would look like this:

{amountremaining} * CASE WHEN {amount} > 0 THEN 1 ELSE -1 END

Please note that these formulas are based on the assumption that the Amount Remaining field is positive for credit memos. If this is not the case, you may need to adjust the formulas accordingly. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******