×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
UPDATE TO JANUARY 2012 THREAD "System21 - Time from Pick Note to Despatch Note"
Ok here's how we've gone about it.
After some useful advice by Gary, we created two tables (in SQL Server), one for OE340 transactions (pick note prints) and another for OE125 transactions (confirmation of despatch).
These were populated from OEP55A: table OE340 with APRG55 = 'OE340' and ARCT55 = '2'; table OE125 with APRG55 = 'OE125' and ARCT55 = '2'.
A select query then joins these two tables to show the times (ADAT55 and ATIM55) 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, without 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: KarimK@xxxxxxxxxxxxx
Web: www.sauflon.com <
http://www.sauflon.com>
________________________________
Disclaimer added by CodeTwo Exchange Rules 2010
www.codetwo.com<
http://www.codetwo.com>
midrange.com
