Dynamics Community Forum Thread Details

a/r invoice

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

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.

Quick Links

Leaderboard