RE: Sales orders posted into the wrong period

Gary,

If you are using sales analysis you may also need to check SAP20.

HTH.
Bill

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


This message has been successfully checked by the Centura Foods Email
System.

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



****************************************************************************

****************************************************************************

The information contained in or attached to this email is intended only for

the use of the individual or entity to which it is addressed.

If you are not the intended recipient, or a person responsible for

delivering it to the intended recipient, you are not authorised to and

must not disclose, copy, distribute, or retain this message or any part of

it. It may contain information which is confidential and/or

covered by legal professional or other privilege (or other rules or laws

with similar effect in jurisdictions outside England and Wales).

The views expressed in this email are not necessarily the views of System 3

Technology Ltd. It's directors or employees make no representation or accept

any liability for it's accuracy or completeness unless expressly stated to

the contrary.  If you have received this email in error please forward to

solutions@xxxxxxxxx



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


________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________


***********************************************************************************
This e-mail, its content and any files transmitted with it are confidential and 
intended solely for the use of the individual (s) to whom it is addressed.
If you are not the intended recipient, be advised that you have received this 
email in error and that any use, dissemination, forwarding, printing or copying 
of this email is strictly prohibited.
This email, its contents and any files transmitted with it have been prepared 
using information believed by the author to be reliable and accurate but 
Centura Foods Ltd makes no warranty as to accuracy or completeness.  In 
particular Centura Foods Ltd does not accept responsibility for changes made to 
this email or related files after it was sent.  Any opinions expressed in this 
email and any related documents are those of the author and do not necessarily 
reflect the opinions of Centura Foods Ltd or its associated companies.
If you have received this email in error please notify the Centura Foods IT 
Helpdesk by telephone on +44 (0) 1606830533.
***********************************************************************************


________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________