System21 - Time from Pick Note to Despatch Note

--===============2144994169==
Content-Language: en-US
Content-Type: multipart/related;
	boundary="_004_5ABA1C035AB4134D8C0D22FDD765A85041995376SAUEXCHHOsauflo_";
	type="multipart/alternative"

--_004_5ABA1C035AB4134D8C0D22FDD765A85041995376SAUEXCHHOsauflo_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hello.

Can I please post the following question.

--------------------------------------------------

We use System21 Aurora 2.3 and have had a request from manufacturing for a =
report that measures the time it takes from picking an order (using 2/OER) =
to confirming it.

Identifying confirmation times is the (relatively) easy part. Some of the t=
ables we can use are INP56 & INP57.

The part we are struggling with is identifying and matching the pick notes =
to the confirmations. This is made more difficult when there are multiple d=
espatch notes for an order line.

The closest thing we can find is in OEP55A, the order line audit table. Eve=
n here, though, we are struggling because there don't appear to be pick not=
e sequence numbers (as there are with despatch notes) for part-fulfilled or=
ders. We would have to look at the programs used (OE340P & OE125) and someh=
ow create sequences, etc. It can all get very messy.

Furthermore, the table is huge. We are trying to resolve this by purging, b=
acking up, indexing, etc.

Is there an easier way to go about this? Any advice would be much appreciat=
ed.

--------------------------------------------------

Thanks,
Karim

________________________________

Karim Khuweldi
Sauflon Pharmaceuticals Ltd, 49-53 York Street,
Twickenham, Middlesex TW1 3LP England

[cid:image00129.gif]

________________________________

Contact Information

Tel         +44(0) 20 8322 4277
Fax:       +44(0) 845 051 8704
Email:     [email protected]
Web:      www.sauflon.com <http://www.sauflon.com>
________________________________

Disclaimer added by CodeTwo Exchange Rules 2010
www.codetwo.com<http://www.codetwo.com>


--_004_5ABA1C035AB4134D8C0D22FDD765A85041995376SAUEXCHHOsauflo_--

--===============2144994169==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.


--===============2144994169==--