Sage Mas 90 / 200 - General Ledger - Finding G/L Problems and Preparing for Sage MAS 90 4.0
DSD Professional Services recommends all current Sage Software Maintenance Plan Sage MAS 90 and Sage MAS 200 users download and run the utility programs and Crystal Reports contained in GL3053_t.EXE in preparation for migrating to Sage MAS 4.0, or to clean up your Sage MAS 90 3.71 (or prior) General Ledger Accounts.
Major changes have been made to the Sage MAS 4.0 General Ledger account structure and data files. In order to migrate your Sage MAS 90 and Sage MAS 200 data file to Sage MAS 4.0, your General Ledger cannot have any missing accounts, special characters or Out Of Balance Source Journals. To assist you in finding these G/L problems, Sage Software has provided the GL-3053_T.EXE download file, as well as two Knowledge Base Articles (GL4000-KBA and GL4001-KBA).
The GL-3053_T.EXE contains G/L programs to remove future date transactions, and five Crystal Reports which will report any accounts with invalid characters, any missing accounts in your GL5 – Detail Transaction file, any missing accounts in your GL8 – Budget and History file, or Out of Balance Source Journals. GL-3053_T.EXE can be run on any Sage MAS 90 3.71 or prior Sage MAS system. GL-3053_T.EXE and Knowledge Base articles can be downloaded from the Support Section of the Sage Website.
The GLWURA and GLWURD programs analyze your G/L files to determine data integrity before migration to Sage MAS 4.0. The five Crystal Reports are:
- InvalidAccountCharacters_371.rpt. checks for invalid special characters in your account numbers.
- MissingAccount_371_GL5.rpt checks your transaction detail for missing accounts in GL1.
- MissingAccount_371_GL8.rpt checks your account summary file for missing accounts in GL1.
- OOBsourceJournal_371.rpt checks your GL5 file for Out of Balance Source Journals.
- OOBsourceJOurnal_400.rpt checks Sage MAS 4.0 G/L files for Out of Balance Source Journals.
Out of Balance Journals normally result from an error during a subsidiary ledger journal or register update, causing the Daily Transaction Register to be out of balance. This would be corrected with a One Sided Journal Entry in the General Journal. All out of balance source journals must be corrected prior to migrating to Sage MAS 4.0
These Crystal Reports can be run on your system, even if you are not planning to upgrade to Sage MAS 4.0 right away, and will assist you in cleaning up your G/L. If you plan to upgrade to Sage MAS 4.0 in the near future, running these programs will allow you to correct the General Ledger in a timely fashion prior to the actual Sage MAS 4.0 migration.
Contact DSD Professional Services if you would like assistance in downloading or running these programs.