Testing the connection between RMS and QB Pro 2006, I keep getting an error that says "Transaction Not In Balance", but it is. Is there a way to back and check and or correct this?
- posted
18 years ago
Posting Errors
Loading thread data ...
- Vote on answer
- posted
18 years ago
Make a backup of your database.
in SO Manager, File/Configuration, change the Accounting Integration type to RMS XML
try posting the batch - you will have to give it a file name.
open the resulting XML File in notepad (Or an XML Editor like XML Spy if you have one) the file will show you all of the credits and debits and the account they are posted to. Add up all Of the Credits Add up all of the Debits The two numbers do not match - that is called "Out of Balance" find the difference between Credits and Debits Look for a value that matches the difference - if you find one, you will know which value is not mapped correctly. If you don't find a match, you need to dig deeper - look at the journaled tranactions for the batch you are trying to balance, and find the line item that matches your difference. once you find and fix your problem, restore your database from the backup (you can actually repost a transaction by clicking the "Dates" button, but it's probably easier to just roll back the database)
Some things that will make you out of balance: One tender type not mapped (maybe added after you had mapped your accounts) a department's Sales/COGS not mapped (even the or 'none' department) Total Sales mapped AND Department Sales Mapped An item sold on a batch that was deleted before you attempt to post (This is a nasty one, and yet another reason to never delete items).