RMS and Quickbooks Integration

I'm posting this on behalf of Hugh, who wasn't able to post directly to the group...

Hello mate I know you said in your signature not to contact you directly but through the Microsoft Newsgroup but I cannot posty to the newsgroup so I decided to email you.

I've noticed you've been very helpful with RMS information and support.

My problem right now is I am tryin to integrate Quickbooks with RMS. I read you said to use RMS XML to see what's being carried over I still cant quite get things to work out. I continue to get an error when I attempt to post a batch thus the batch isnt committed.

Can you please give me a sample RMS XML file that you used to pass the data over to quickbooks or a list of what accounts are assigned to what account type.

PLease if you know anyone else who can assist me please refer my problem on to them. If possible and ok with you you can also post my question to the newsgroup or forum.

Also do you have an resources, guides, forums etc. on

rms- especially integration with quickbooks?

Thank you for your time and consideration.

Regards,

Hugh

A sample XML file from someone else's system isn't going to help you - it will have completely different accounts from yours and will be meaningless as a comparison.

Is the error you are getting that the batch failed to post because the transaction is out of balance? If so, this is almost always a problem with account mapping. This error can also occur if you have had certain database changes between the time the batch closed and you attempt to post it. Deleting tender types or deleting or renaming departments can cause a batch not to balance for instance.

Here's a bit more information on how the RMS XML posting format can help you find your account mapping problem:

1) change your Accounting software form Quickbooks to "RMS XML" in SO Manager/File/Configuration/Accounting Tab 2) post your batch again - you will need to enter a file name and location where you want the file to be saved. 3) The file produced will be a more or less human readable version of the values being posted. You can view this in a text editor like notepad, but an XML editor like XMLSpy

formatting link

will make it much easier to read. 4) The file will contain all of the Debits and Credits being posted. If you sum all of the debits, they should be equal to the sum of all the credits. In you case they are not - thus your batch is out of balance. Get the difference between credits and debits and start looking for a similar value on the Z Report.

The absolute best advice I can give you on setting up the QB/RMS integration is have an accountant looking over your shoulder while you're assigning accounts. Those guys live credits and debits and it just amazes me how easily they can sort out the account mapping.

Next would be to remember that some of the values posted need to be posted as BOTH Debits and Credits - for instance, COGS is (I think this is right - I'm not an accountant:) a debit to the COGS account and a credit to the Inventory account.

There are a couple of documents available in the KnowledgeBase section of Customer Source - but since you called me 'mate' I'm guessing you're from Australia and can't get access to that site. I don't know why MS has made that a US only resource, but I'm not able to redistribute those documents - sorry..

Good Luck!