web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / AR Aging Reconcile to ...
Finance | Project Operations, Human Resources, ...
Unanswered

AR Aging Reconcile to GL Balance

(0) ShareShare
ReportReport
Posted on by GP_TruckMate_anyone... 10

I am having trouble matching my AR Aging to my AR GL balance. 

I have run the Reconcile program for AR Aging & AR GL -- to no avail. 

Couple of issues: 

1) Paid Transaction Removal does not seem to properly move Sales Docs/Payments from Open > History. I have not seen this happen in practice.

2) Sales Documents & Payments that have already been applied to one another spontaneously unapply & both documents are moved back to OPEN & appear on the aging. 

3) AR Aging does not reflect Outstanding Balance on documents (Run a smartlist for Current TRX does not equal 0). I may have $5000 on the aging & actual outstanding amount is $2200 or even $0)

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Leng Papio Profile Picture
    Leng Papio 855 on at

    Hi,

    On the issues you reported as follows:

    1) Paid Transaction Removal does not seem to properly move Sales Docs/Payments from Open > History. I have not seen this happen in practice.

    *I've seen this on GP installs with 3rd party or customizations. The issue usually is a decimal after the 2nd digit, which renders the document not "fully" applied. You will want to look at the tables directly to confirm this.

    2) Sales Documents & Payments that have already been applied to one another spontaneously unapply & both documents are moved back to OPEN & appear on the aging.

    *The GP ageing reports depends on apply info. If the apply info is incorrect or damaged, it will give you issues in the ageing. Again, usually this results to 3rd party or customizations.

    3) AR Aging does not reflect Outstanding Balance on documents (Run a smartlist for Current TRX does not equal 0). I may have $5000 on the aging & actual outstanding amount is $2200 or even $0)

    *Same answer as above.

    I would recommend contacting your partner or someone who can take a look at the SQL db to validate the transactions.

    I can assist if you want; just send me a message.

    Good luck!

  • Gavin Profile Picture
    Gavin 2,508 on at

    Hi,

    To add to what Elena has mentioned I'd say the following:

    If you are running the Historical Aged Trial Balance this essentially disregards the documents status and uses the date you enter in the "Print/Age as of" field on the report to determine whether the documents are outstanding.

    pastedimage1613466591952v1.png

    For example I have set this as 31/01/2021 (UK format) in the screen shot above so anything prior to this date that was paid and applied by a document dated in Feb would show as outstanding on the report. This is because "as of" the end of January they were outstanding. (it uses the apply records to calculate this).

    This feeds into your 3rd point as well. Smartlist shows the documents amount remaining and status "as of" now regardless of your work date whereas the Historical Aged Trial Balance calculates the amount remaining based on the "Print/Age as of" setting as I've described above.

    Please note I also use a certain technique to assist in reconciliation issues that I've documented on my blog. The link to the post is here: http://thedynamicsexplorer.com/2019/05/02/dynamics-gp-4-steps-to-help-reconcile-general-ledger-to-receivables-or-payables/

    Hope this helps.

    Thanks

    Gavin

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 503 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 434 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 278 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans