Re: 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.