Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Suggested answer

Invoice posted to wrong period

Posted on by Microsoft Employee

I processed some invoices that belong in the 8th period into the 7th period.  Is there a way to correct this?  I have not posted it to the GL as yet.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Invoice posted to wrong period

    Kea,

    Option 2 will put your revenue in the correct period but only on the GL side as it does not alter the AR documents or transactions.  As both I and Bill pointed out, your AR reports will continue to show the activity as having been posted to period 7.

    Yes, you could leave things as they are and JE the activity from period 7 to period 8 but that would basically be no different than option 2 except that the original batch header would still match the AR document and transaction side (which is only really a cosmetic issue when they do not match).

    The cleanest approach, from an accounting point of view, is option 1 but that makes for confusing statements to the affected customers when the only reason for the "ins and outs" is your internal accounting needs.

    I do option 3 (though I created a custom SL program to do that work) all the time for my clients who release batches to the wrong posting period.  The multi-period capability of SL is both a good and not so good feature.

  • Bill Degnan Profile Picture
    Bill Degnan 650 on at
    RE: Invoice posted to wrong period

    Kea,

    Be aware with option 2 that the period sensitive aging report will not include the invoices in the batch that is changed from period 08 to period 07 in GL.

    With option 3, you should also review the ardoc.s4Future01 field.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Invoice posted to wrong period

    Hi Rick,  I can do option 2 but will that put my revenue in the correct period?  I also thought about journaling it into the correct period.  What do you think about that?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Invoice posted to wrong period

    Kea,

    You have 3 options:

    1) you can create credit memos for the invoices posting those to period 7 and apply them to the invoices and then re-create the invoices posting them to period 8.

    2) if you have initialize mode rights to the 0101000 screen and only care about the GL side, you can enable initialize module, select AR as the module, pull up the batch in question and change the posting period on that batch.\

    3) you can run a set of SQL update queries (if you have access to SQL) and change the posting period on ARDoc, and ARTran to the correct posting period as well as doing choice 2.  The update queries would be:

     update ardoc set perpost = yyyy08 where batnbr = 'xxxxxx'

     update artran set perpost = yyyy08 where batnbr = 'xxxxxx'

    yyyy is the fiscal year and xxxxxx is the batch number in question

    Choice 2 only changes the batch header and the GLTran items to the correct posting period.  It will not change the ARDoc or ARTran records so your AR reports will continue to show these documents posted to period 7.  If that is not a big issue to you then perform choice 2 and call it good.

    Choice 1 is the only choice if you do not have initialize mode rights or access to SQL Management Studio to run update queries.  It will, of course, leave the customer statements showing the incorrect invoices and offsetting credit memos as well as the correct invoices.

    If you go with choice 3, make sure you are comfortable running SQL queries and that you have a database backup in case you enter the update query incorrectly and it touches more records than intended.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,986 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans