Re: System21 - Time from Pick Note to Despatch Note
Karim Khuweldi <[email protected]> Tue, 17 Jan 2012 13:39:42 +0000
| Newsgroups | gmane.comp.systems.as400.jbausers |
|---|---|
| Message-ID | <5ABA1C035AB4134D8C0D22FDD765A8504199649D@SAUEXCH-HO.sauflon.local> |
Thanks again for your advice Gary. Best Regards, Karim -----Original Message----- From: system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] = On Behalf Of Gary Pattinson Sent: 17 January 2012 13:12 To: System 21 Users Subject: Re: [SYSTEM21] System21 - Time from Pick Note to Despatch Note Karim, You need to be very careful with the data and what you can achieve. - I might be mis-understanding what you are saying. OE 340 - is pick note print - but this only shows the time, the pick note r= un was produced. Not the time the picking was done. OE125 - is confirm despatch, which - if done manually, will only record the= time the confirm despatch was done. It might be easier to discuss your process on the phone - Sorry ? Regards, =A0 Gary Pattinson Project Manager and System21 Specialist I.T.Impact Ltd 07711 485608 -----Original Message----- From: system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] = On Behalf Of Karim Khuweldi Sent: 17 January 2012 12:16 To: Gary.Pattinson Subject: Re: [SYSTEM21] System21 - Time from Pick Note to Despatch Note Yes as usual the report needs to be ready by yesterday! The matching part is definitely complicated. The status field seems only to= be populated with a 'C' (when OE125 is run). It would have been great if t= here was a 'P' for 'pick note produced'. As it is, there seem to be two aud= it rows created when OE125 or OE340 (pick note) are run. We generate the pick notes through 2/OER so I expect this is real time. Regards, Karim -----Original Message----- From: system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] = On Behalf Of Gary Pattinson Sent: 17 January 2012 11:58 To: System 21 Users Subject: Re: [SYSTEM21] System21 - Time from Pick Note to Despatch Note It also depends how your transactions are captured. - via HHTs - i.e. real time, or manually entered - which means the audit d= ata would be very iffy. Regards, =A0 Gary Pattinson Project Manager and System21 Specialist I.T.Impact Ltd 07711 485608 -----Original Message----- From: system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] = On Behalf Of Karim Khuweldi Sent: 17 January 2012 11:30 To: Gary.Pattinson Subject: Re: [SYSTEM21] System21 - Time from Pick Note to Despatch Note OK Mike I will bring this to my manager's attention. Will this question be posted on the System21 forum? Thanks, Karim -----Original Message----- From: system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] = On Behalf Of Mike Hill Sent: 17 January 2012 11:13 To: system21-Zwy7GipZuJhWk0Htik3J/[email protected] Subject: Re: [SYSTEM21] System21 - Time from Pick Note to Despatch Note Karim, I don't know the database structure that well I'm afraid. My expertise tend= ed to be in the technology side, in particular workflow. You should look in= to acquiring this module as it is one of the gems in the System21 toolkit M= ike > From: [email protected] > To: system21-Zwy7GipZuJhWk0Htik3J/[email protected] > Date: Tue, 17 Jan 2012 10:53:54 +0000 > Subject: Re: [SYSTEM21] System21 - Time from Pick Note to Despatch = > Note > > Thanks Mike, > > Unfortunately we don't use this module. Is there any other way we could t= ry? > > Regards, > Karim > > -----Original Message----- > From: system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] > [mailto:system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Mike Hill > Sent: 17 January 2012 10:33 > To: System 21 Users > Subject: Re: [SYSTEM21] System21 - Time from Pick Note to Despatch = > Note > > 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 measur= e each transaction. > > Cheers > > Mike > Sent from my iPhone > > On 17 Jan, 2012, at 6:25 PM, "Karim Khuweldi" <[email protected]> wrot= e: > > > Hello. > > > > Can I please post the following question. > > > > -------------------------------------------------- > > > > We use System21 Aurora 2.3 and have had a request from manufacturing fo= r a report that measures the time it takes from picking an order (using 2/O= ER) to confirming it. > > > > Identifying confirmation times is the (relatively) easy part. Some of t= he tables we can use are INP56 & INP57. > > > > The part we are struggling with is identifying and matching the pick no= tes to the confirmations. This is made more difficult when there are multip= le 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-fulfille= d orders. We would have to look at the programs used (OE340P & OE125) and s= omehow create sequences, etc. It can all get very messy. > > > > Furthermore, the table is huge. We are trying to resolve this by purgin= g, backing up, indexing, etc. > > > > Is there an easier way to go about this? Any advice would be much appre= ciated. > > > > -------------------------------------------------- > > > > 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. > > > KarimKhuweldi > Sauflon Pharmaceuticals Ltd, 49-53 York Street, Twickenham, Middlesex > TW1 3LP England > > > > > Contact Information > > Tel: +44(0) 20 8322 4277 > Fax: +44(0) 845 051 8704 > Email: [email protected] > Web: www.sauflon.com > > Disclaimer added by CodeTwo Exchange Rules 2010 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://archi= ve.midrange.com/system21. KarimKhuweldi Sauflon Pharmaceuticals Ltd, 49-53 York Street, Twickenham, Middlesex TW1 3= LP England Contact Information Tel: +44(0) 20 8322 4277 Fax: +44(0) 845 051 8704 Email: [email protected] Web: www.sauflon.com Disclaimer added by CodeTwo Exchange Rules 2010 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://archi= ve.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://archi= ve.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://archi= ve.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://archi= ve.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.