Re: System21 - Time from Pick Note to Despatch Note

Mike Hill <[email protected]> Tue, 17 Jan 2012 18:32:29 +0800
Newsgroups gmane.comp.systems.as400.jbausers
Message-ID <[email protected]>
Karim

One way to do it is use sysyem21 workflow. Create a process with pick and despatch notes included. The workflow audit file will enable you to measure each transaction. 

Cheers

Mike
Sent from my iPhone

On 17 Jan, 2012, at 6:25 PM, "Karim Khuweldi" <[email protected]> wrote:

> 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:     [email protected]
> Web:      www.sauflon.com <http://www.sauflon.com>
> ________________________________
> 
> Disclaimer added by CodeTwo Exchange Rules 2010
> www.codetwo.com<http://www.codetwo.com>
> 
> _______________________________________________
> 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.
> 
_______________________________________________
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.