|
Posted by Glenn Adams [MVP - Retail Mgmt on January 23, 2006, 5:19 pm
Please log in for more thread options
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 <unassigned> 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).
--
--
Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information
> 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?
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap