Re: SYSTEM21 Digest, Vol 6, Issue 28
"Mon M. Ferriols" <[email protected]>
| Newsgroups | gmane.comp.systems.as400.jbausers |
|---|---|
| Message-ID | <[email protected]> |
Ram, Thank you. -----Original Message----- From: system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of system21-request-Zwy7GipZuJhWk0Htik3J/[email protected] Sent: Sunday, February 24, 2008 2:00 AM To: system21-Zwy7GipZuJhWk0Htik3J/[email protected] Subject: SYSTEM21 Digest, Vol 6, Issue 28 Send SYSTEM21 mailing list submissions to system21-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe or unsubscribe via the World Wide Web, visit http://lists.midrange.com/mailman/listinfo/system21 or, via email, send a message with subject or body 'help' to system21-request-Zwy7GipZuJhWk0Htik3J/[email protected] You can reach the person managing the list at system21-owner-Zwy7GipZuJhWk0Htik3J/[email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of SYSTEM21 digest..." Today's Topics: 1. Re: [SYSTEM21] SYSTEM21 Digest, Vol 6, Issue 27 (Bobby Mouton) 2. Re: [SYSTEM21] GL year end closing (Ram Hari) 3. Re: [SYSTEM21] GL year end closing ([email protected]) ---------------------------------------------------------------------- message: 1 date: Fri, 22 Feb 2008 12:06:32 -0600 from: Bobby Mouton <bmouton-BTK87QoPN9CmRm6sBn/[email protected]> subject: Re: [SYSTEM21] SYSTEM21 Digest, Vol 6, Issue 27 I will be out of the office on Friday February 22nd, returning on Monday February 25th. ------------------------------ message: 2 date: Fri, 22 Feb 2008 13:25:29 -0500 from: "Ram Hari" <[email protected]> subject: Re: [SYSTEM21] GL year end closing 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 ------------------------------ message: 3 date: Fri, 22 Feb 2008 12:36:08 -0600 from: [email protected] subject: Re: [SYSTEM21] GL year end closing Do you have the following flag set to '1' on your G/L company profile? Separate DR & CR . . . . 0 (0/1) If so, do you need it set? Some countries have a requirement that the debits posted to control accounts (A/R & A/P) balance based on by debit & credit to transactions in the subsidiary ledger. This flag sets on this validation, which might be the error you are getting. If you do not need this type o validation for your country, then simply turning this flag off may fix your problem. If not there is a way to correct the data, but you probably need to call Answerlink for assistance. Many people think that if you simply want to see debits and credits printed separately on reports you need to set this flag on. That is not the case. It only controls the functionality I described above. Richard Caldicott Director of Implementations & Efficiency Tandy Brands Accessories 817-548-0090 extn 146 "Mon M. Ferriols" <[email protected]> Sent by: system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] 02/22/2008 03:48 AM Please respond to System 21 Users <system21-Zwy7GipZuJhWk0Htik3J/[email protected]> To "system21-Zwy7GipZuJhWk0Htik3J/[email protected]" <system21-Zwy7GipZuJhWk0Htik3J/[email protected]> cc 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. ------------------------------ _______________________________________________ This is the System 21 Users (SYSTEM21) digest 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. End of SYSTEM21 Digest, Vol 6, Issue 28 *************************************** _______________________________________________ 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.