How to resolve this error that occurs when my mapreduce script is trying to make and save changes to an Opportunity? Transaction was not in balance. Total = 12345.0 Estimate and Opportunity are non-posting Transactions aren't they? Why does NetSuite care if one or the other is in balance? Also, what fields or records does NetSuite compare to decide that the Opportunity or its related Estimate is out of balance?

AI generated answer (using internal Slack threads):

The error "Transaction was not in balance" typically occurs when the total of the debits and credits in a transaction do not match. In the context of NetSuite, this could happen when you're trying to modify a transaction after it has been posted, or when there's a missing account-related field in one of the items (line item, tax item, shipping item, discount item, etc.). Even though Opportunity and Estimate are non-posting transactions, they still need to be in balance. This is because NetSuite uses these transactions to generate other transactions (like Sales Orders or Invoices) which do need to be in balance. If the Opportunity or Estimate is out of balance, it could lead to issues when generating these other transactions. NetSuite checks the balance of a transaction by comparing the total of the debits and credits in the transaction. For an Opportunity, this would typically involve comparing the total of the line items (each of which would have a debit and a credit) to the total of the transaction. If these totals do not match, then the transaction is considered out of balance. To resolve this error, you would need to ensure that the total of the debits and credits in the transaction match. This could involve checking the line items and their associated accounts to ensure that they are correct and complete. If you're modifying a transaction after it has been posted, you would need to ensure that the modification does not cause the transaction to go out of balance. In the context of a script, you might need to add additional checks or validations to ensure that the transaction remains in balance. For example, if you're changing the tax code for a line item, you might need to also adjust the amount of the line item to ensure that the total of the debits and credits still match. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******