× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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
________________________________________________________________________

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.