Open Forum

Rebuilding Accthist

  • 1.  Rebuilding Accthist

    SILVER CONTRIBUTOR
    Posted Sep 06, 2017 08:35 AM
    ​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
    ------------------------------


  • 2.  RE: Rebuilding Accthist

    BRONZE CONTRIBUTOR
    Posted Sep 06, 2017 04:44 PM
    ​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
    ------------------------------



  • 3.  RE: Rebuilding Accthist

    SILVER CONTRIBUTOR
    Posted Sep 07, 2017 08:39 AM
    ​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
    ------------------------------



  • 4.  RE: Rebuilding Accthist

    Posted Sep 07, 2017 09:43 AM
    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.
    ------------------------------



  • 5.  RE: Rebuilding Accthist

    Posted Jul 04, 2018 11:06 AM
    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.
    ------------------------------



  • 6.  RE: Rebuilding Accthist

    BRONZE CONTRIBUTOR
    Posted Jul 05, 2018 07:59 AM
    Here it is.  (don't forget to backup first :)   )

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



  • 7.  RE: Rebuilding Accthist

    GOLD CONTRIBUTOR
    Posted Aug 08, 2018 02:02 PM
    ​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
    ------------------------------



  • 8.  RE: Rebuilding Accthist

    BRONZE CONTRIBUTOR
    Posted 17 days ago
    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
    ------------------------------



  • 9.  RE: Rebuilding Accthist

    TOP CONTRIBUTOR
    Posted 17 days ago
      |   view attached
    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
    ------------------------------

    Attachment(s)



  • 10.  RE: Rebuilding Accthist

    BRONZE CONTRIBUTOR
    Posted 17 days ago
    Thank you, Michael!!!

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