System21 - Time from Pick Note to Despatch Note

--===============1743207668==
Content-Language: en-US
Content-Type: multipart/related;
	boundary="_004_5ABA1C035AB4134D8C0D22FDD765A850419976B3SAUEXCHHOsauflo_";
	type="multipart/alternative"

--_004_5ABA1C035AB4134D8C0D22FDD765A850419976B3SAUEXCHHOsauflo_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

UPDATE TO JANUARY 2012 THREAD "System21 - Time from Pick Note to Despatch N=
ote"


Ok here's how we've gone about it.

After some useful advice by Gary, we created two tables (in SQL Server), on=
e for OE340 transactions (pick note prints) and another for OE125 transacti=
ons (confirmation of despatch).

These were populated from OEP55A: table OE340 with APRG55 =3D 'OE340' and A=
RCT55 =3D '2'; table OE125 with APRG55 =3D 'OE125' and ARCT55 =3D '2'.

A select query then joins these two tables to show the times (ADAT55 and AT=
IM55) for both transactions side by side and the amount of time between the=
 two.

In theory, it should be possible to query the source table directly, withou=
t the need for the two tables above. However, OEP55A is a huge table and is=
 optimised for inserts rather than reporting.

Regards,
Karim


________________________________

Karim Khuweldi
Sauflon Pharmaceuticals Ltd, 49-53 York Street,
Twickenham, Middlesex TW1 3LP England

[cid:image0015985.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>


--_004_5ABA1C035AB4134D8C0D22FDD765A850419976B3SAUEXCHHOsauflo_--

--===============1743207668==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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


--===============1743207668==--