Thanks again for your advice Gary.

Best Regards,
Karim

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx] 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 run 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,
 
Gary Pattinson
Project Manager and System21 Specialist
I.T.Impact Ltd
07711 485608


-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx] 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 there was a 'P' for 'pick note produced'. As it is, there seem to be two audit 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@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx] 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 data would be very iffy.

Regards,
 
Gary Pattinson
Project Manager and System21 Specialist
I.T.Impact Ltd
07711 485608


-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx] 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@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx] On Behalf Of Mike Hill
Sent: 17 January 2012 11:13
To: system21@xxxxxxxxxxxx
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 tended to be in the technology side, in particular workflow. You should look into acquiring this module as it is one of the gems in the System21 toolkit Mike

From: KarimK@xxxxxxxxxxxxx
To: system21@xxxxxxxxxxxx
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 try?

Regards,
Karim

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx] 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 measure each transaction.

Cheers

Mike
Sent from my iPhone

On 17 Jan, 2012, at 6:25 PM, "Karim Khuweldi" <KarimK@xxxxxxxxxxxxx> 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: KarimK@xxxxxxxxxxxxx
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@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.


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: KarimK@xxxxxxxxxxxxx
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@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.


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: KarimK@xxxxxxxxxxxxx
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@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.




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

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].