You’re offline. This is a read only version of the page.
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.
*This post is locked for comments
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.
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.
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?
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (