RE: [SYSTEM21] Sales orders posted into the wrong period

["Jeff Klipa" <jklipa@xxxxxxxxxxx>]

Oh the tangled web we weave...

Let this be a warning to all of us out there...  This could happen to anyone 
of us at any time.
If you've ever had this particular mess to clean up then you will appreciate 
where Gary is coming from right now...  Mike hit the nail squarely on the 
head...

Since the period number for all SOP -> A/R invoice postings are based on the 
current Inventory calendar period, that means that all of Gary's Inventory 
movements and G/L valuations after week one of 10402 are posted to 
10403...!!!

Doh...!!!

So INP95, INP96 and PCP01 and the explosion of files that the OSLMJ 
background job proliferates into (to name only a few) are 'infected' with 
the wrong period...  Talk about a domino effect...!  Assuming your using AFI 
the G/L will be carrying these valuations in the wrong period as well...  So 
once you fix the A/R side as you have suggested your G/L will be thrown off 
again...  The accountants will not be able to balance the A/R with the 
Inventory...

Ouch, what an ugly mess...!!!

I suffered a similar event in 1997 when unbeknownst to me a user had 
actually closed the Inventory period twice...!!!  It took a while to realize 
the error but by then the damage was widespread throughout the database...  
I attempted to clean everything up but I was left with the nagging feeling 
that I never did find all of the files to fix...

Needless to say I don't let the users populate the calendars or close the 
Inventory Period any more...  And, even though we have successfully 
automated the Inventory monthend close I still always log in and check the 
Inventory and Sales Analysis calendars to make sure the current period is 
set correctly before any users are allowed to post anything...

An ounce of prevention IS better than a pound of cure for sure in this 
case...

It's a good thing we have users to blame these kinds of things on...  ;8<)
Have you audited your security for the Calendar Maintenance options 
lately...?

Good luck Gary...

----Original Message Follows----
From: MLemon@xxxxxxxxxxx
Reply-To: System 21 Users <system21@xxxxxxxxxxxx>
To: system21@xxxxxxxxxxxx
Subject: RE: [SYSTEM21]   Sales orders posted into the wrong period
Date: Wed, 11 Feb 2004 08:25:20 -0500

Did all of your inventory movements post to the correct period?  Each
invoice/credit is almost guaranteed to be accompanied by some inventory
movements in GL?  If you are correcting this via JE, then you may want to
SQL the period in INP95/INP96.  I'm certain that there are inventory reports
that look at the period in these files.

-----Original Message-----
From: Gary Shipp [mailto:gary.shipp@xxxxxxxxx]
Sent: Wednesday, February 11, 2004 5:49 AM
To: SYSTEM21@xxxxxxxxxxxx
Subject: [SYSTEM21] Sales orders posted into the wrong period

A user at our company made an error when creating our calendar file for
2004, entering dates so that period 2 was only effectively only 1 week long
and period 3 7 weeks.  Several sales invoice posting sessions were performed
before anyone noticed the error.

As a result, we now have a few thousand invoices in period 4/3 instead of
4/2.  The calendar has now been corrected, however, the accountants want the
items moved into the right period.

What I was intending to do is as follows;

 1) Use the SL Interface to firstly credit each invoice currently in period
3, than create new invoices in period 2.  We realise that new invoice
numbers will be created and are happy to put up with this.
 2) SQL OEP65 and OEP70 to correct the period number from 10403 to 10402.

Are there any other issues that I need to consider addressing?  Is simply
SQL'ing OEP65 and OEP70 an acceptable solution to resolving the incorrect
periods on the SOP side of things?

Thanks for any help.
--
________________________
Gary Shipp
(iSeries Development Project Manager)
System Three Technology Ltd
Tel:     01553 636792
Fax:     01553 636414
Mob:     07974 328454
URL:    <www.s3t.co.uk> << <http://www.s3t.co.uk/> http://www.s3t.co.uk>>

_________________________________________________________________
Create your own personal Web page with the info you use most, at My MSN. 
http://click.atdmt.com/AVE/go/onm00200364ave/direct/01/