Dynamics Community Forum Thread Details

GLTRAN And ARHIST

Hello Experts,

I am facing problem in matching Trial Balance. I used GLtran Table netting of debit and Credit to match with Customer outstanding with Solomon Trial Balance. But problem is that Customer wise when compared , deviated value from of few customers outstanding. A debit balance of customer is shown as credit balance in our report.

So, i captured opening balances of customers from ARHist Table. Even though, few Customer wise outstanding was not matching.

How solomon works exactly. My intention is to match Trial Balance and Individual Customer Accounts. How do i do that.

Thanks in Advance.

I am having a bit of a difficult time understanding what you are trying to do here but it sounds like you are trying to match up GLTran items to ARTran items or doing the equivalent of the customer aged trial balance against GLTran. While, in theory, this should work, it initially depends on whether you have AR posting to GL in summary or not. If it is posting in summary, this is not going to work because GLTran is then summarized by batch number and GL account / sub-account so multiple customers will be in a single GLTran transaction. Even if you are posting in detail, GLTran does not have the customer id field so you would have to join to ARTran on the batch number reference number and account number.

Perhaps we should go back and define the problem you are trying to address as opposed to the problem you ran into addressing it this way and explore an alternative way to address what you need to do. Also, are you trying to do this via a report or just with a SQL query? If your issue is that you are trying to tie the receivable balances on the GL side to the AR balances, the period sensitive aging report is the normal way to do that. The issue with that report is the fact that it does not always handle an open credit balance on a document (payment or credit memo) when the report is run retrospectively and that open credit balance has been applied to a document (invoice or debit memo) that is posted to a period after the period for which you are reporting the aging. However, just to clarify, the logic in the report works great for open debit balances that are subsequently paid.

Quick Links