Re: Transaction Posting to the wrong period.

We had this very problem yesterday, and the files that we updated to correct it 
were:

osld1f3.inp96
osld1f3.inp96
osld1f3.inp95
osld1f3.inp95
oslpdf3.pcp56
oslpdf3.pcp62
oslpdf3.pcp59
oslpdf3.pcp58
oslpdf3.pcp53
oslpdf3.pcp93

PCP58, PCP53 and PCP93 would have been affected but did not actually have any 
data in them. The SQL statements that we ran to fix the problem are as follows:

update osld1f3.inp96 set perd96 = 1 WHERE YRPR96 = 10602
update osld1f3.inp96 set yrpr96 = 10601 WHERE YRPR96 = 10602
update osld1f3.inp95 set perd95 = 1 WHERE YRPR95 = 10602
update osld1f3.inp95 set yrpr95 = 10601 WHERE YRPR95 = 10602
update oslpdf3.pcp56 set cper56 = 1 WHERE CYER56=106 and CPER56=2
update oslpdf3.pcp62 set cper62 = 1 WHERE CYER62=106 and CPER62=2
update oslpdf3.pcp59 set cper59 = 1 WHERE CYER59=106 and CPER59=2

anyone running mass updates against live production files should be VERY 
careful, and when we did all this, we had GEAC on the phone, which I think is 
probably a very good idea for anyone planning on changing large amounts of data 
by hand. Another potential problem is whether or not these transactions have 
hit the financial side yet.

Christopher

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx] On 
Behalf Of Ostrowski, Bruce
Sent: Thursday, January 05, 2006 10:44 AM
To: System 21 Users
Subject: [SYSTEM21] Transaction Posting to the wrong period.

We had 1 ½ days of transaction post to the wrong period at the beginning of 
this year.  The transactions were invoices and inventory transactions.  Does 
anyone know all the files that need change to correct the posting period?  We 
have correct the posting problem but know need to clean up the incorrect 
transactions.

 

Bruce Ostrowski            

Utilimaster

 

_______________________________________________
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.