Aaron McCausland
05/14/2026, 1:23 PMCeligo AI
05/14/2026, 1:23 PMAI generated answer (using internal Slack threads):The error "TRANS_UNBALNCD Transaction was not in balance. Total = 800.0" typically occurs when there is an imbalance in the transaction amounts. This could be due to several reasons: 1. Modifying the transaction after it has posted: If you are modifying the transaction after it has been posted, it could cause an imbalance in the amounts due to changes in tax or other fields. 2. Incorrect tax setup: The error could be related to an incorrect tax setup for the item or customer. This could be due to an issue with a tax service like Avalara or a misconfiguration in the item/customer tax setup. 3. Missing account related fields: The error could occur if one of the items (line item, tax item, shipping item, discount item etc) is missing one of its account related fields. 4. Custom GL plug-ins: If you are using custom GL plug-ins, the error could be due to the custom debits and/or credits not balancing. 5. Setting both Rate and Amount: If you are setting both the Rate and Amount fields, it could cause an imbalance. It is recommended to only set the Rate field. 6. Order of setting fields: The order in which you set your fields could also cause this error, especially in dynamic mode. For example, setting the rate after the amount overwrites the amount, causing an imbalance. 7. Updating unnecessary fields: If you are updating fields that you don't need to, it could cause an imbalance. For example, setting the entity and line fields in dynamic mode could cause this error. To resolve this error, you should review your transaction and ensure that all fields are correctly set and that the transaction balances correctly. If you are using a tax service or custom GL plug-ins, ensure they are correctly configured. If you are modifying the transaction after it has been posted, consider delaying the modification until after the transaction has been posted. ****** 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
05/14/2026, 1:23 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.835022092
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.831787109
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.831665099
Celigo AI
05/14/2026, 1:23 PM