Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Suggested answer

a/r invoice

Posted on by Microsoft Employee

I entered an ar invoice and posted payment into the wrong month with this month's transaction date, how can I fix it?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: a/r invoice

    How to fix this depends on whether you are using bank reconciliation or cash manager.  If you are using either of these modules then the following suggestion is complete only if the transaction date on the payment was correct in the first place.

    1) Use application inquiry/reversal to un-apply the payment to that invoice

    2) Create a credit memo for the same amount of the invoice using the same revenue accounts and post it to the same wrong period.  This is to basically offset the invoice

    3) Create a debit memo for the same amount as the payment but make the grid account your cash account and post to the same wrong period.  This will take the money back out of the bank account.  Note: this is the step that will cause problems if you are using bank reconciliation or cash manager because that module will not recognize a debit memo hitting cash.

    4) Apply the credit memo from step 2 to the incorrect invoice

    5) Apply the payment to the debit memo created in step 3

    6) Create the correct invoice and payment over again

    the other option requires knowledge of how to run SQL queries.  Under this option you would be correcting the posting period in the ardoc, artran and aradjust tables.  This option is only viable if the GL side of the invoice and payment batch has not been posted (those AR batches are released but not posted).  If those batches have not been posted and those batches only contain the incorrect invoice and payment (e.g., those batches do not contain other documents that are correct) then you can turn on initialize mode, go to the journal transaction screen on the GL menu, change the module to AR and pull up both batches changing the period to post to the correct period to post and saving.  Do not forget to turn off initialize mode when you are done.

    If you are using bank reconciliation or cash manager, the first option will cause an issue with those modules and the second option is probably the better way.  So as to not make this response too confusing, I will not address the bank reconciliation / cash manager portions unless you indicate you are using one of those modules as well.

    If you do decide to go with option 2 I can supply the query statements that are needed.  They are basically the same as what I supplied in another post on this forum where a user posted a Jan 2014 payment to 01-0213 (a rather common mistake when we cross into a new year) but that post only addressed the payment side and you appear to have an issue with the invoice side as well.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,645 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans