RE: Sales orders posted into the wrong period

Gary,
You are correct.

Perhaps it is too late at night after a long day for me.

Regards

Michael Berman

(m) 0419 324 558

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx]On
Behalf Of Gary Shipp
Sent: Wednesday, 11 February 2004 10:59 PM
To: 'System 21 Users'
Subject: RE: [SYSTEM21] Sales orders posted into the wrong period

Michael,

Sorry, but perhaps I've missed your point.  Surely posting the credits and
correcting invoices through the SL interface will perform the necessary GL
updates.  Obviously, I'll be populate FLPIx and running GLI00CLP as part of
the SL interface.

Please excuse my ignorance, but why would additional journals need to be
raised?

Thanks for the help so far

Gary

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx]
On Behalf Of Michael Berman
Sent: 11 February 2004 11:33
To: System 21 Users
Subject: RE: [SYSTEM21] Sales orders posted into the wrong period

Gary,
Don't forget about General Ledger.
I suggest the accounts raise appropriate Post Inhibit Journals, based on an
AFI Summary report for the posting details.
There is a report only option for AFI.

I am glad you are using system functions rather than trying to SQL AR files
and rebuilding balances.  You option is by far safer and proven.

Regards

Michael Berman

(m) 0419 324 558

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx]On
Behalf Of Gary Shipp
Sent: Wednesday, 11 February 2004 9:49 PM
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>>



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

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

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