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@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx] On Behalf Of Mon M. Ferriols
Sent: Friday, February 22, 2008 4:44 AM
To: system21@xxxxxxxxxxxx
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@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
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
midrange.com
