Aloha Peter,
I have not used the Rebuild AcctHist script before, but have rebuilt AcctHist from "Scratch" using gltran and batch.
Steps are basic.
1. Delete AcctHist and CuryAcct (all or just back to a fiscal year)
2. Update your GL Periods (example: update glsetup set lastclosepernbr = '200712', pernbr = '200712')
3. Update your posted records status (example: update batch set status = 'U' where status = 'P' and update gltran set posted = 'U' where posted = 'P') you will need to add perpost filter in here as well if you are not going all the way back
4. Close GL Period
5. Post Transactions
6. Repeat steps 4 and 5 until you reach current period
Hope this helps.
Aloha,
-Scott
------------------------------
Scott Johnson
Sr. Business Application Developer
W. M. Keck Observatory
Kamuela HI
------------------------------
Original Message:
Sent: 09-06-2017 08:35
From: Peter Hummel
Subject: Rebuilding Accthist
Client did a delete of GL to 2008. Running the rebuild accthist from GLtran script. It is not working correctly. The retained earning is not correct. One of the balance sheet accounts starts out with the correct beginning balance, in 2008 no transactions but when you look at the 2009 record the beginning balance is 0.00. The P&L accounts seem to work nicely. The YTD NI account is generated correctly but there seems to be random accounts that don't work. this script is from the MR folder dated 2009. Anyone have a solution?
thanks. Peter
------------------------------
Peter Hummel
SSL Solutions
------------------------------