Share
ReportHi,
I'm wondering if it is possible to write a query against GlTRAN and ARDOC and find out what document is causing dis-balance between GL and AR?
Thanks!
*This post is locked for comments
You’re offline. This is a read only version of the page.
1,471
Hi,
I'm wondering if it is possible to write a query against GlTRAN and ARDOC and find out what document is causing dis-balance between GL and AR?
Thanks!
*This post is locked for comments
Hi Rick/Santhosh,
I figure out the problem. A while ago one of the invoices for some reason had a currency conversion rate(have no idea why is it happened) . Following our partner's advice we corrected document amount in ARDOC, ARTRAN. Did not corect GLTRAN. So the document is"sitting" with wrong doc amount in GLTRAN. Thanks!
Hi Andrew
As John said, the cause of this issue due to unposted baches or any Future period transaction or any Direct GL entries with AR accounts.
Instead on writing an query, Please follow the below steps
1) Export the Customer Period Trail balance report to excel for the specified period
2) Export the Detail GL Report towards AR and AR- Prepayment Acct to Excel
3) Compare both the excel sheets using Vlookup based on the RefNbr/BatNbr combination and easily identify the missing / problematic records causing AR vs GL issue.
Hope this helps
I am assuming when you say A/R and G/L you mean the A/R aging and the G/L receivable account(s). If that is the case, one of the most common causes of this results from you creating a document (invoice, debit memo, credit memo) when you utilize a receivable account in the grid section of the screen or, as John_Joyce pointed out you override the receivable account using a non-receivable account.
The aging report is a document level report, not a transaction level report while the GL is strictly transaction driven. Therefore, if a single document both debits and credits a receivable account then the GL side will reflect both transactions and the A/R aging will only reflect on side since it is reporting on a document. As a simple example, let's say you create a debit memo when you use a receivable account in the grid section of the screen. By default, the other side of the A/R transaction is also hitting the customer's default receivable account. From the G/L point of view, this is a wash while on the A/R aging this is a single debit document (not both a debit and a credit document like the transaction side).
You can create some queries to look for such a situation. You can look for ARTran records that have a trantype of IN or DM and credit a receivable account. You can look for ARTran records that have a trantype of CM and debit a receivable account.
Have you searched for Unposted AR batches for the current period?
Have you searched for batches posted to a future period?
If you're doing a query, you may want to focus on ARTran rather than ARDoc. Maybe look for Invoices/Credit Memos where the AR Account was over-ridden during data entry?
All responses (
Answers (
