Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Answered

A/R GL Balance and A/R Aging balances

Posted on by Microsoft Employee

What are reasons the A/R GL balance and the A/R Aging balance could be different?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: A/R GL Balance and A/R Aging balances

    The journal entry would have needed to be reversed in the period in which the invoice was posted.

    For example, the invoice was posted in 05-2015, but should have been posted in 03-2015. You posted the journal entry in period 03-2015. The journal entry needs to be reversed in period 05-2015.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: A/R GL Balance and A/R Aging balances

    An invoice was posted to an incorrect period and I did a JE to to correct the period it should post to.  This happened back in 2015.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: A/R GL Balance and A/R Aging balances

    What ended up being the issue?

    If a GL entry was coded to your AR account, it would not have updated your AR subledger and would need to be reversed.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: A/R GL Balance and A/R Aging balances

    Thank you.  Jake, how do I fix this?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: A/R GL Balance and A/R Aging balances

    Kea,

    Another possible cause is that an AR document used a receivable account in the grid portion of the invoice and memo screen.  Doing so is a common mistake when trying to move something from one receivable account to another.  the reason this is a problem is that the AR aging is based at the document level so a document can only be associated with one receivable account.  If you utilize a receivable account in the grid, the transactions associated with the document affect two receivable accounts (or wrap around on the same receivable account) and are reflected on the GL affecting both the debit and the credit transactions while the AR aging only sees one side.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: A/R GL Balance and A/R Aging balances

    It could be thrown out of balance if something was coded to your AR account outside of the AR module. For example if you were to code a GL entry to the AR account, it would most likely throw off your reconciliation.

    You might also check your suspense accounts perhaps an account/subaccount/company combination was not open.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: A/R GL Balance and A/R Aging balances

    Kea,

    1) Invoice applied to the same account in the entry

    2) erroneous period

    are the most common. Thanks

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans