Open Forum

​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
------------------------------

​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
------------------------------

​thanks for the thoughts.  You are in effect reposting all the batches.  Sounds OK if a month is an issue but these goes from 200801 to 201705.  That is many months of manual labour maybe.  The thing is the rebuild script has always worked for me for many many years.  I would like to understand why this one account is causing problems.  Something not set right maybe.

------------------------------
Peter Hummel
SSL Solutions
------------------------------

Original Message:
Sent: 09-06-2017 16:43
From: Scott Johnson
Subject: Rebuilding Accthist

​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
------------------------------

Hi, I have found with the rebuild accthist script that you need to ensure all Accounts are ACTIVE before running the script.  After running the script you can update the accounts back to inactive.

------------------------------
Scott Savlowitz
Queue Associates, Inc.
------------------------------

Original Message:
Sent: 09-06-2017 16:43
From: Scott Johnson
Subject: Rebuilding Accthist

​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
------------------------------

Hi All,

Does anyone have a copy of the rebuild accthist script.  I can't seem to find it anywhere.

I redid my sub acct structure and have a few accounts that went a little crazy and want to get the balances right.  I am an ex implementation specialist and know my way around SL and think this would be better than trying to do it manually.

Thanks for the assistance,

Jack

------------------------------
Jack Woods
VP of IT
Icon Eyewear, Inc.
------------------------------

Original Message:
Sent: 09-07-2017 09:43 AM
From: Scott Savlowitz
Subject: Rebuilding Accthist

Hi, I have found with the rebuild accthist script that you need to ensure all Accounts are ACTIVE before running the script.  After running the script you can update the accounts back to inactive.

------------------------------
Scott Savlowitz
Queue Associates, Inc.

Original Message:
Sent: 09-06-2017 16:43
From: Scott Johnson
Subject: Rebuilding Accthist

​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
------------------------------

Here it is.  (don't forget to backup first :)   )

------------------------------
Tom Schonthaler
Sr. Financial Systems Consultant
Raffa
Washington DC
------------------------------

Original Message:
Sent: 07-04-2018 11:05 AM
From: Jack Woods
Subject: Rebuilding Accthist

Hi All,

Does anyone have a copy of the rebuild accthist script.  I can't seem to find it anywhere.

I redid my sub acct structure and have a few accounts that went a little crazy and want to get the balances right.  I am an ex implementation specialist and know my way around SL and think this would be better than trying to do it manually.

Thanks for the assistance,

Jack

------------------------------
Jack Woods
VP of IT
Icon Eyewear, Inc.

Original Message:
Sent: 09-07-2017 09:43 AM
From: Scott Savlowitz
Subject: Rebuilding Accthist

Hi, I have found with the rebuild accthist script that you need to ensure all Accounts are ACTIVE before running the script.  After running the script you can update the accounts back to inactive.

------------------------------
Scott Savlowitz
Queue Associates, Inc.

Original Message:
Sent: 09-06-2017 16:43
From: Scott Johnson
Subject: Rebuilding Accthist

​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
------------------------------

​Appears the link is gone...can you email it to me please?  karla.johnson@schneider-electric.com

Thanks!

------------------------------
Karla Johnson
System Architect
Schneider Electric
Carrollton TX
------------------------------

Original Message:
Sent: 07-05-2018 07:58 AM
From: Tom Schonthaler
Subject: Rebuilding Accthist

Here it is.  (don't forget to backup first :)   )

------------------------------
Tom Schonthaler
Sr. Financial Systems Consultant
Raffa
Washington DC

Original Message:
Sent: 07-04-2018 11:05 AM
From: Jack Woods
Subject: Rebuilding Accthist

Hi All,

Does anyone have a copy of the rebuild accthist script.  I can't seem to find it anywhere.

I redid my sub acct structure and have a few accounts that went a little crazy and want to get the balances right.  I am an ex implementation specialist and know my way around SL and think this would be better than trying to do it manually.

Thanks for the assistance,

Jack

------------------------------
Jack Woods
VP of IT
Icon Eyewear, Inc.

Original Message:
Sent: 09-07-2017 09:43 AM
From: Scott Savlowitz
Subject: Rebuilding Accthist

Hi, I have found with the rebuild accthist script that you need to ensure all Accounts are ACTIVE before running the script.  After running the script you can update the accounts back to inactive.

------------------------------
Scott Savlowitz
Queue Associates, Inc.

Original Message:
Sent: 09-06-2017 16:43
From: Scott Johnson
Subject: Rebuilding Accthist

​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
------------------------------

Hi All - I'm a little late to the party on this one, but did anyone have a copy of that accthist rebuild script they are willing to share? I'm asking... for a friend...

Many thanks,
Justin

------------------------------
Justin Fishwick
Manager of Business Analysis
The Brattle Group
------------------------------

Original Message:
Sent: Jul 05, 2018 07:58 AM
From: Tom Schonthaler
Subject: Rebuilding Accthist

Here it is.  (don't forget to backup first :)   )

------------------------------
Tom Schonthaler
Sr. Financial Systems Consultant
Raffa
Washington DC

Original Message:
Sent: 07-04-2018 11:05 AM
From: Jack Woods
Subject: Rebuilding Accthist

Hi All,

Does anyone have a copy of the rebuild accthist script.  I can't seem to find it anywhere.

I redid my sub acct structure and have a few accounts that went a little crazy and want to get the balances right.  I am an ex implementation specialist and know my way around SL and think this would be better than trying to do it manually.

Thanks for the assistance,

Jack

------------------------------
Jack Woods
VP of IT
Icon Eyewear, Inc.

Original Message:
Sent: 09-07-2017 09:43 AM
From: Scott Savlowitz
Subject: Rebuilding Accthist

Hi, I have found with the rebuild accthist script that you need to ensure all Accounts are ACTIVE before running the script.  After running the script you can update the accounts back to inactive.

------------------------------
Scott Savlowitz
Queue Associates, Inc.

Original Message:
Sent: 09-06-2017 16:43
From: Scott Johnson
Subject: Rebuilding Accthist

​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
------------------------------

Hi Justin,

Hope this works for you friend  :)

Let me know of any issues...

Thanks,
Michael

------------------------------
Michael O'Neill
Director of Finance
Eastex Telephone Cooperative
Henderson TX
------------------------------

Original Message:
Sent: Nov 19, 2019 09:01 AM
From: Justin Fishwick
Subject: Rebuilding Accthist

Hi All - I'm a little late to the party on this one, but did anyone have a copy of that accthist rebuild script they are willing to share? I'm asking... for a friend...

Many thanks,
Justin

------------------------------
Justin Fishwick
Manager of Business Analysis
The Brattle Group

Original Message:
Sent: Jul 05, 2018 07:58 AM
From: Tom Schonthaler
Subject: Rebuilding Accthist

Here it is.  (don't forget to backup first :)   )

------------------------------
Tom Schonthaler
Sr. Financial Systems Consultant
Raffa
Washington DC

Original Message:
Sent: 07-04-2018 11:05 AM
From: Jack Woods
Subject: Rebuilding Accthist

Hi All,

Does anyone have a copy of the rebuild accthist script.  I can't seem to find it anywhere.

I redid my sub acct structure and have a few accounts that went a little crazy and want to get the balances right.  I am an ex implementation specialist and know my way around SL and think this would be better than trying to do it manually.

Thanks for the assistance,

Jack

------------------------------
Jack Woods
VP of IT
Icon Eyewear, Inc.

Original Message:
Sent: 09-07-2017 09:43 AM
From: Scott Savlowitz
Subject: Rebuilding Accthist

Hi, I have found with the rebuild accthist script that you need to ensure all Accounts are ACTIVE before running the script.  After running the script you can update the accounts back to inactive.

------------------------------
Scott Savlowitz
Queue Associates, Inc.

Original Message:
Sent: 09-06-2017 16:43
From: Scott Johnson
Subject: Rebuilding Accthist

​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
------------------------------

Thank you, Michael!!!

------------------------------
Justin Fishwick
Manager of Business Analysis
The Brattle Group
------------------------------

Original Message:
Sent: Nov 19, 2019 09:26 AM
From: Michael O'Neill
Subject: Rebuilding Accthist

Hi Justin,

Hope this works for you friend  :)

Let me know of any issues...

Thanks,
Michael

------------------------------
Michael O'Neill
Director of Finance
Eastex Telephone Cooperative
Henderson TX

Original Message:
Sent: Nov 19, 2019 09:01 AM
From: Justin Fishwick
Subject: Rebuilding Accthist

Hi All - I'm a little late to the party on this one, but did anyone have a copy of that accthist rebuild script they are willing to share? I'm asking... for a friend...

Many thanks,
Justin

------------------------------
Justin Fishwick
Manager of Business Analysis
The Brattle Group

Original Message:
Sent: Jul 05, 2018 07:58 AM
From: Tom Schonthaler
Subject: Rebuilding Accthist

Here it is.  (don't forget to backup first :)   )

------------------------------
Tom Schonthaler
Sr. Financial Systems Consultant
Raffa
Washington DC

Original Message:
Sent: 07-04-2018 11:05 AM
From: Jack Woods
Subject: Rebuilding Accthist

Hi All,

Does anyone have a copy of the rebuild accthist script.  I can't seem to find it anywhere.

I redid my sub acct structure and have a few accounts that went a little crazy and want to get the balances right.  I am an ex implementation specialist and know my way around SL and think this would be better than trying to do it manually.

Thanks for the assistance,

Jack

------------------------------
Jack Woods
VP of IT
Icon Eyewear, Inc.

Original Message:
Sent: 09-07-2017 09:43 AM
From: Scott Savlowitz
Subject: Rebuilding Accthist

Hi, I have found with the rebuild accthist script that you need to ensure all Accounts are ACTIVE before running the script.  After running the script you can update the accounts back to inactive.

------------------------------
Scott Savlowitz
Queue Associates, Inc.

Original Message:
Sent: 09-06-2017 16:43
From: Scott Johnson
Subject: Rebuilding Accthist

​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
------------------------------