Does re-opening Sub-ledgers and GL Accounting Periods lead to corrupt or inaccurate data, or is the system designed to work this way?

Our fiscal year has ended and in reviewing the detail GL I have found that sales from the previous fiscal year were updated to the current fiscal year, due to a date error. All sub-ledgers have been closed, and the G/L has also been closed for the last fiscal year. In order to re-enter the invoices into the correct period, I will re-open the INV, SO and AR, and GL modules to the correct period and rebill those invoices. But we have a subcontractor that helps us and she is indicating that we should never re-open a closed period. I thought the system was designed to allow this functionality without corrupting data or the losing the detail information, and would like to confirm whether or not anyone else has experienced any issues in this regard.   

  • 0

    Your subcontractor is correct. For sub-ledgers you should not try to re-open periods. Bad things happen. With the G/L you should keep it open at least a year so you can go back and make changes such as these.  You can reopen G/L and make your correction and reclose.

  • 0 in reply to BigLouie

    A lot of the answers here depend on the version of Sage 100 (MAS 90) you are running.

    G/L is generally no big deal to reopen and post back (although in 3.x and prior versions you had to make sure you reran year end close to get the balances in future years to update).

    I'm still a fan of NOT opening things like A/R,  S/O,  A/P etc. once closed because of the way the older versions of the software operated.   You would have running totals that were current month,  ONE future month,  current year (and I think prior year?).  So reopening prior months would mess up these running totals.  I have not revisited the this is the upgraded modules (Business Frameworks vs Legacy) to determine if this is really still an issue.   Definitely DO NOT try this in modules such as payroll and work order.  Others I am no sure.