1,515
I have a client that posted a good number of invoices in AR module to an incorrect period. The transaction has not been posted in GL. Are there queries that can be run to update the period rather than entering credits for the incorrect period and re-entering the invoices? There are just too many transactions to manually reverse.
*This post is locked for comments
Does it resolve your concern already?
include in the update script 'fiscyr' field of ArTran & GLTran tables.
1. ArTran
Update ArTran set perpost = '201303', fiscyr = '2013' where batnbr in ('BBBBBB')
2. GLTran
Update GLTran set perpost = '201303', fiscyr = '2013' where batnbr in ('BBBBBB') and module = 'AR'
Update the period to post (perpost) of the following tables (ArTran, ArDoc, Batch).
scripts:
1. ArTran
Update Artran set perpost = 'YYYYPP' where batnbr in ('BBBBBB')
2. ArDoc
Update ArDoc set perpost = 'YYYYPP' where batnbr in ('BBBBBB')
3. Batch
Update batch set perpost = 'YYYYPP' where batnbr in ('BBBBBB') and module = 'AR'
Run the script in the appropriate application database.
The script assumes that the periods where to post the transactions fall on the same year and they are not yet posted in the general ledger (status is 'U').
Make sure to backup your database before running the scripts in SQL and if possible, deploy the resolution in a test environment before deploying it in the live database.
After running the script, check the transactions in SL.
#1
André Arnaud de Cal...
292,884
Super User 2025 Season 1
#2
Martin Dráb
231,748
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
