Re: 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://archive.midrange.com/system21.