Re: Net Profit (memo)
Srimal Athukorale <srimalc-/[email protected]>
| Newsgroups | gmane.comp.systems.as400.jbausers |
|---|---|
| Message-ID | <[email protected]> |
Dear Richard U always gives a solution. ----- Original Message ---- From: "[email protected]" <[email protected]> To: System 21 Users <system21-Zwy7GipZuJhWk0Htik3J/[email protected]> Sent: Tue, October 13, 2009 10:05:39 PM Subject: Re: [SYSTEM21] Net Profit (memo) I guess everyone is nervous about the possibility of changes figures that have already been reported. Also the job can take a long time. It is often easier and quicker to find the error and fix it manually If it is really necessary to rebuild the balances, what I have sometimes done, is to repost everything instead - mainly because I can control it. Assuming you have no currency balances... First, after ending the background job, you have to check that you have no FLP008 records with an updnog of 0 and no FLP007 with an UPDNOG of -1 (Note this sometimes displays as a positive 1 due to editing). Next you chose your starting point and set your company profile back to that period (say 10812) and change all FLP007 records greater than your start period to an UPDNOG of -1 and FLP008 to an UPDNOG of 0. Next remove all FLP004 records for periods greater than your start. Now perform month end. Change all FLP007 records for the new period to 0 and then start the background job. This will post that periods transactions. Then end the background job and advance the period, repeating the process until you are up to date. You could of course do all the updates and then roll the periods. The usual things about testing and backing up apply as always. I guess my biggest concern here is understanding what happened as I don't like mysteries. There is always a reason as to why things happen. Richard Caldicott Director - Implementation Tandy Brands Accessories 817-548-0090 extn 146 From: <[email protected]> To: System 21 Users <system21-Zwy7GipZuJhWk0Htik3J/[email protected]> Date: 10/13/2009 09:25 AM Subject: Re: [SYSTEM21] Net Profit (memo) Sent by: <system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]> Nope we didn't roll updnog numbers or try to recover a g/l transaction. Bob Keeley told me once not to run G/L rebuild for a prior year, hence my hesitation. Do you have any idea why he would've said that? [email protected] Sent by: system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] 10/12/2009 05:20 PM Please respond to System 21 Users To: System 21 Users <system21-Zwy7GipZuJhWk0Htik3J/[email protected]> cc: Subject: Re: [SYSTEM21] Net Profit (memo) Has you UPDNOG rolled recently? One problem I have comes across is where the UPDNOG reaches 9999999 and when the next number is allocated to a transaction, it gets zero, but the balances are updated. It looks as if the transaction didn't update and if 'recover' the transaction you actually update it a second time, causing an imbalance. A rebuild should fix the data but it might be easier to fix the account if it is as the result of a single entry similar to that I described above. Why not run a query totalling up your FLP008 records for the periods you think may be out and put in a work file. Do the same with FLP004 adding up NPCR04 & NPDR04 and then compare the 2 files. It should give you more confidence in the outcome if you decide to rebuild. Richard Caldicott Director - Implementation Tandy Brands Accessories 817-548-0090 extn 146 From: [email protected] To: system21-Zwy7GipZuJhWk0Htik3J/[email protected] Date: 10/12/2009 03:50 PM Subject: [SYSTEM21] Net Profit (memo) Sent by: system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] We have a problem where the Balance Sheet Report (43/GLE) is out of balance after month end. The discrepancy is in the period balance (FLP004) for the Net Profit account (970000). The sum of the transactions (FLP008) on the accounts that make up the Profit and Loss ledger do not match the period balances (FLP004) of the Net Profit account. The problem is that the out of balance goes back to a prior year's period. I can't find any evidence of a transaction(s) that updated the prior period. Can we run a g/l rebuild for a prior year? Retained Earnings amount has changed as well. We're on version 3.5.1. Any ideas would be appreciated. Thanks, Jeri Kilroy _______________________________________________ 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) 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) 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) 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) 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.