Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Suggested answer

correction period

Posted on by Microsoft Employee

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.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: correction period

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: correction 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.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: correction 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.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: correction period

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: correction period

    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.  

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: correction period

    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.

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,556 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,625 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans