Share
ReportHow can an AR batch posted in the wrong period be reversed? and not show up on owner statements?
*This post is locked for comments
You’re offline. This is a read only version of the page.
How can an AR batch posted in the wrong period be reversed? and not show up on owner statements?
*This post is locked for comments
The answer depends on whether you mean the batch has been posted or just released. If it has just been released and not yet posted to the GL then someone with initialize mode rights to the GL journal entry screen can turn on initialize mode which exposes the module field and you can change the posting period on that batch. Note that, doing this, only changes the GL side. It does not change the AR side so the documents and transactions will still show under the original posting period but the GL side will then reflect the correct posting period. If the batch has been released, it cannot be reversed on its own. It if has been posted to the GL then, if only the GL side is of concern, you can made a pair of JE batches to move the dollars from the incorrect posting period to the correct posting period.
Your other option is to create a reversing AR batch posted to the incorrect period and then recreate the correct AR batch posted to the correct period. The reversing batch depends on what type of AR batch the original batch was (you did not indicate if it was an invoice batch or a payment application batch). If the incorrect batch was an invoice batch you can create a credit memo batch to match the invoice batch and apply the credit memo to the incorrect invoice. If the incorrect batch was a payment application batch, you could use the application inquiry/reversal screen to execute an NSF action of the payments in the batch. If the incorrect batch is a small balance/credit batch or other less common type of batch, your choices would be different.
Note: there are some third party tools out there that allow you to change the posting period on a released batch or, if you have access to the SQL Management Studio, you can run a set of update queries to change the posting period in the affected data tables but that should only be done if you have a full understanding of what tables are affected.
All responses (
Answers (
