Cash receipt apply in payment application was wrong period release but not posted yet in Microsoft dynamics sl.
Period is 05-2017 but I apply 05-2019
Please tell me details how do that.
*This post is locked for comments
Cash receipt apply in payment application was wrong period release but not posted yet in Microsoft dynamics sl.
Period is 05-2017 but I apply 05-2019
Please tell me details how do that.
*This post is locked for comments
Hi Rick
Because I don't know the period in cash correct or not he didn't say about it, so I assume that it was correct and no need to change. If the period in cash incorrect he can reverse by a CK transaction and then do a RC transaction with correct period.
Nam Dang's suggestion will take care of most of the issue but not quite all. As I stated, changing the posting period on the journal entry screen will correct the GL side of the issue. Using application inquiry/reversal and the un-apply payment option and then creating a new payment application batch using the correct posting period will fix the period closed value on the paid documents. However, the actual cash document, and its transactions) will still have the incorrect posting period which will leave various AR reports missing this cash in the correct posting period and having it show up when AR gets to the incorrect posting period. This will also not correct cash manager or bank reconciliation (if you use either of these modules). If you were thinking you could use the NSF option of application inquiry/reversal to void the payments and enter them again in a batch with the correct posting period, the issue with that approach is that the application inquiry/reversal screen does not let you specify the posting period so the NSF document will hit your current posting period while the original payments still hit your incorrect posting period.
In my opinion, you can solve this issue with steps as below:
1. Turn on initialize mode, open that batch in GL and correct the period.
2. In AR module select Application inquiry / reversal, choose customer in customerID tetbox, payment refnbr in pmt/memo nbr text box, choose reverse selected application in process zone. choose the application batch in detail grid then press begin processing button.
3. Reapply that payment with correct period.
Give it a try, that may be help you.
You cannot edit the posting period in AR once a batch is released. You can edit it on the GL side if you have initialize rights to the journal entry screen (0101000) and the batch has not been posted. However, please be aware that editing the posting period on the GL side does change the posting period for the various AR reports (like the document register, transaction report or account distribution report). This only changes the posting period in the GLtran records and the batch header record. Also, if you are running bank recon or cash manager, changing the posting period on the GL side will negatively affect those modules so it is not the recommend course of action if you are using either of those modules.
To change the posting period on a non-posted batch coming from a module like AR or AP you turn on initialize mode and open the journal entry screen in GL. This enables the module field where you can change the module to the appropriate module (AR in your case) and then select the batch and edit the posting period.
If you need to change the posting period on both the AR and GL side 9and possibly the cash manager side) then you would have to accomplish that with a set of SQL update statements which means you would need access to SQL Management Studio and know how to run SQL statements.
There are a few third party products available for changing the posting period across all the affect modules. One of those is available from SBS Group. You may want to look into purchasing that module since it sounds like you do not have the ability to run SQL update statements.
Thank you,
Can i do edit this transaction. I have no idea about SQL statement. can you tell me details how to solve this problem? My question is only changed period correction.
Do you have access to the SQL management tool? If so, I can provide a set of update statements to correct this.
Also, did you payment application batch include new cash (e.g., you entered a non-zero batch total) or was the batch just applying existing cash and credits? It makes a different as to what needs to be change via SQL statements and, if you were only applying existing cash and credits then there is an alternate way to fix this.
André Arnaud de Cal... 291,419 Super User 2024 Season 2
Martin Dráb 230,492 Most Valuable Professional
nmaenpaa 101,156