Sage 100

 View Only

  • 1.  GL Out Of Balance in Retained Earnings Beginning Balance

    Posted 02-08-2019 13:09
    I have a client on Sage 100 Std 5.3. They discovered that Retained Earnings Beginning Balance for 2019 is out of balance by ~15K. 2018 was in balance with no issues.

    I have a copy of the affected company to test possible solutions. Tried closing the year for 2018 but that had no effect. Why is that, shouldn't that have fixed it? Could it have anything to do with future years? They have a 2020 and 2021 setup with no activity.

    Anyone seen something like this before?

    ------------------------------
    Greg Stiles
    S & W Microsystems
    Torrance CA
    310.787.1010
    ------------------------------


  • 2.  RE: GL Out Of Balance in Retained Earnings Beginning Balance

    Posted 02-08-2019 13:19
    I believe there is a KB article on it, but you could copy to a TST company, recalc GL Balances or I believe you can reinitialize a history file (Periodposting? - it's indicated in the KB).  I'm not in a position to look right now for the article.  Sorry.

    ------------------------------
    Nancy Hanson
    Blytheco LLC
    Eagan MN
    ------------------------------



  • 3.  RE: GL Out Of Balance in Retained Earnings Beginning Balance

    Posted 02-08-2019 13:30
    Recalc the balances per Nancy's post and go from there.  Did they renumber GL accounts lately?  I had a client do this back in v3.71 changing a P/L account to a B/S.  That took a while to root out.  But I don't think you can that in the new framework.  Just a thought.

    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 4.  RE: GL Out Of Balance in Retained Earnings Beginning Balance

    Posted 02-08-2019 13:39
    @Jeff Schwenk I really do not want to recalc the balances if that can be avoided. They are a public company and if anything changes in any prior year, Ernst & Young will have my hide. Not to mention that would be a TON of work to verify all the previous years reports, their COA is massive.
    @Nancy Hanson I cannot find anything in the KB regarding retained earnings being out of balance​. ​
    If I remove the records from PeriodPosting for Retained Earnings for the affected years and then run period end will that recalc them?

    ------------------------------
    Greg Stiles
    S & W Microsystems
    Torrance CA
    310.787.1010
    ------------------------------

    Original Message


  • 5.  RE: GL Out Of Balance in Retained Earnings Beginning Balance

    Posted 02-08-2019 13:51
    @Greg Stiles I just tested and, yes, the recalc recreate a record that I deleted from that table.  Was the BS in balance for Nov?  If so, can you manually calculate what the Retained Earnings should have been for December, just to check it, then change the record via DFDM for January?​

    ------------------------------
    Michelle Taylor
    ERP Team Manager, CS3 Technology
    918-388-9772
    ------------------------------

    Original Message


  • 6.  RE: GL Out Of Balance in Retained Earnings Beginning Balance

    Posted 02-08-2019 14:21
    @Michelle Taylor recalc balances or period end processing?
    I did manually fix things through DFDM, but I can explain a system solution (like doing period end processing) to the auditors better than manually editing the balances.

    ------------------------------
    Greg Stiles
    S & W Microsystems
    Torrance CA
    310.787.1010
    ------------------------------

    Original Message


  • 7.  RE: GL Out Of Balance in Retained Earnings Beginning Balance

    Posted 02-08-2019 15:23
    @Greg Stiles I was addressing your question "If I remove the records from PeriodPosting for Retained Earnings for the affected years and then run period end will that recalc them?"  I removed a record from the PeriodPosting table and the system recreated it when I ran the recalc utility.  Hope that helps.​

    ------------------------------
    Michelle Taylor
    ERP Team Manager, CS3 Technology
    918-388-9772
    ------------------------------

    Original Message


  • 8.  RE: GL Out Of Balance in Retained Earnings Beginning Balance

    Posted 02-08-2019 16:07
    Got it. I'll try just running period end processing. I want to avoid the recalculate balances utility.

    ------------------------------
    Greg Stiles
    S & W Microsystems
    Torrance CA
    310.787.1010
    ------------------------------

    Original Message


Related Content