Dynamics 365 CommunityForums Microsoft Dynamics RMS (Archived) RMS2.0 to QB 2009 Data...

RMS2.0 to QB 2009 Data Import Problem

(0) Share

Report

Posted on by Community Member

I am trying to post entries from MS Dynamics RMS 2.0 to QB 2009 and I am getting an error message that reads: An error was detected while posting journals. Refer 'CProgramFiles\MicrosoftRetailManagementSystem\StoreOperations\QBPost.log' for future details. The "QBPost log" indicates it is a "Transaction not in balance"

Anyone know how to correct this?
Not sure if this is a QB or a RMS problem?
Any help would be appreciated. Thanks

*This post is locked for comments

All responses (1)

Answers (0)

Community Member on at

Like (0)

Report

Re: RMS2.0 to QB 2009 Data Import Problem

Simply, the accounts you set up in hte GL table in RMS which generates the posting must be in balance. Every install is different, so my gl table would likely be different from yours as the nature of hte transactions would be.

The simplest way from me to learn in the process was post all the other accounts i was not sure of to suspense to get it to balance. Then i worked through the postings to proper accounts.

If you are not using the direct interface to QB i suggest you use it rather than the export/import.