×
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.
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 tables 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 despatch notes for an order line.
The closest thing we can find is in OEP55A, the order line audit table. Even here, though, we are struggling because there don't appear to be pick note sequence numbers (as there are with despatch notes) for part-fulfilled orders. We would have to look at the programs used (OE340P & OE125) and somehow create sequences, etc. It can all get very messy.
Furthermore, the table is huge. We are trying to resolve this by purging, backing up, indexing, etc.
Is there an easier way to go about this? Any advice would be much appreciated.
--------------------------------------------------
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: KarimK@xxxxxxxxxxxxx
Web: www.sauflon.com <
http://www.sauflon.com>
________________________________
Disclaimer added by CodeTwo Exchange Rules 2010
www.codetwo.com<
http://www.codetwo.com>
As an Amazon Associate we earn from qualifying purchases.