Re: GL year end closing
"Ram Hari" <[email protected]>
| Newsgroups | gmane.comp.systems.as400.jbausers |
|---|---|
| Message-ID | <FC30EEA42EC06449A52089B2FB90F5235A9479@nwsexch2k3.nws.wasserstrom.com> |
Mon, The report usually prints the AR/AP control accounts matched to Customer/Supplier year end balances. Here are the steps 1. Run your unprocessed transactions report in the modules that are not in balance from the utilities menu and fix those issues 2. Run your Debtors/Creditors report (Summary option) by period and see which period you are out of balance. You would find 2 reports in your spool the first one would be similar to your GL year end discrepancy report. 3. In most cases your GL might have a higher balance than AR/AP. This is due to the fact that the system might not have updated the customer/supplier balance for some transactions. 4. If you are able to isolate those specific customers or Suppliers you can rebuild their balances or else you can rebuild the balances for entire company from the period you had out of balance issues. 5. If you have had Hierarchy accounts in your customer database and you recently maintained them that might cause an out of balance issue too where you have to manually go in and fix the customer period balances. If you have done purges to your AR system it is always better to set up a new customer instead of deleting/detaching a customer from hierarchy. Here are the major files that GL year end close takes into account. SLP10, PLP10 and FLP004 if the out of balance is in AR or AP. We do not have manufacturing module so I am not aware of other files. Let me know if I can be of further assistance Ram S. Hari Director, Information Services N. Wasserstrom & Sons Phone: (614) 737 8542 Fax: (614) 737 3275 -----Original Message----- From: system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Mon M. Ferriols Sent: Friday, February 22, 2008 4:44 AM To: system21-Zwy7GipZuJhWk0Htik3J/[email protected] Subject: [SYSTEM21] GL year end closing Dear list: User is trying to close GL, however can't proceed and system prints out a list of accounts that are not balanced. What can be done to correct the imbalance? TIA. Mon M. Ferriols Information Technology Department Ionics EMS, Inc. _______________________________________________ This is the System 21 Users (SYSTEM21) mailing list To post a message email: SYSTEM21-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/system21 or email: SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/system21. The recipient of this email should check this email and any attachments for the presence of viruses. The Wasserstrom Companies accepts no liability for any damage caused by any virus transmitted by this email. This footnote also confirms that this email message has been scanned for the presence of computer viruses. The Wasserstrom Companies _______________________________________________ This is the System 21 Users (SYSTEM21) mailing list To post a message email: SYSTEM21-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/system21 or email: SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/system21.