http://archive.midrange.com/system21 Mailing list archive for system21 at midrange.com en-us Copyright (c) 1997-2012 midrange.com and David Gibbs as a compilation work david@midrange.com (David Gibbs) 2012-01-27T13:58:13-06:00 This is an XML content feed. It is intended to be viewed in a newsreader or syndicated to another site, subject to copyright and fair use. http://static.midrange.com/images/logo.jpg http://www.midrange.com http://feeds.midrange.com/~r/system21/~3/aPe_JUR8AhM/msg00015.html Jim Kerr 2012-01-27T13:58:06-06:00 You could also consider journaling those files of interest. A bit of an overhead but may be worth it if it is important. Jim. -----Original Message----- From: system21-bounces@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx] On Behalf Of Deon A von Blerk Sent: Friday, January 27, 2012 11:27 AM To: system21@xxxxxxxxxxxx Subject: Re: [SYSTEM21] SYSTEM21 Digest, Vol 10, Issue 6 I agree with Geoff. Added to that is the fact that many of the S21 files have no audit e.g. INP15. Regards Kit www.ecofitonline.com... <p><a href="http://feedads.g.doubleclick.net/~a/FsFym61nP5n-AVJ9ogkLQ3YhHoQ/0/da"><img src="http://feedads.g.doubleclick.net/~a/FsFym61nP5n-AVJ9ogkLQ3YhHoQ/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/FsFym61nP5n-AVJ9ogkLQ3YhHoQ/1/da"><img src="http://feedads.g.doubleclick.net/~a/FsFym61nP5n-AVJ9ogkLQ3YhHoQ/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.midrange.com/~ff/system21?a=aPe_JUR8AhM:7Lbto0wosBI:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/system21?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=aPe_JUR8AhM:7Lbto0wosBI:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/system21?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=aPe_JUR8AhM:7Lbto0wosBI:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/system21?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/system21/~4/aPe_JUR8AhM" height="1" width="1"/> http://archive.midrange.com/system21/201201/msg00015.html http://feeds.midrange.com/~r/system21/~3/jK9z8ZFtxG8/msg00014.html Deon A von Blerk 2012-01-27T13:27:15-06:00 I agree with Geoff. Added to that is the fact that many of the S21 files have no audit e.g. INP15. Regards Kit www.ecofitonline.com <p><a href="http://feedads.g.doubleclick.net/~a/eANl_ToXiXEi7g4iF_8qp0CAGag/0/da"><img src="http://feedads.g.doubleclick.net/~a/eANl_ToXiXEi7g4iF_8qp0CAGag/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/eANl_ToXiXEi7g4iF_8qp0CAGag/1/da"><img src="http://feedads.g.doubleclick.net/~a/eANl_ToXiXEi7g4iF_8qp0CAGag/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.midrange.com/~ff/system21?a=jK9z8ZFtxG8:xdMs593HS_4:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/system21?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=jK9z8ZFtxG8:xdMs593HS_4:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/system21?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=jK9z8ZFtxG8:xdMs593HS_4:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/system21?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/system21/~4/jK9z8ZFtxG8" height="1" width="1"/> http://archive.midrange.com/system21/201201/msg00014.html http://feeds.midrange.com/~r/system21/~3/9NWf7CCp5is/msg00013.html Gary Lewis 2012-01-27T04:35:23-06:00 Geoff, Isn't that called journaling? :) Regards Gary. -----Original Message----- From: system21-bounces@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx] On Behalf Of Geoff Boreland Sent: 27 January 2012 00:01 To: 'System 21 Users' Subject: Re: [SYSTEM21] System21 - Time from Pick Note to Despatch Note You might also want to contemplate the use of database triggers to ensure you capture all the information required. A typical audit file is only ever going to be as useful as all of the programs that write ... <p><a href="http://feedads.g.doubleclick.net/~a/H-uddpHl1rCB-BUs4GJ0fU7xKOk/0/da"><img src="http://feedads.g.doubleclick.net/~a/H-uddpHl1rCB-BUs4GJ0fU7xKOk/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/H-uddpHl1rCB-BUs4GJ0fU7xKOk/1/da"><img src="http://feedads.g.doubleclick.net/~a/H-uddpHl1rCB-BUs4GJ0fU7xKOk/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.midrange.com/~ff/system21?a=9NWf7CCp5is:SpwHvje9Fkw:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/system21?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=9NWf7CCp5is:SpwHvje9Fkw:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/system21?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=9NWf7CCp5is:SpwHvje9Fkw:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/system21?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/system21/~4/9NWf7CCp5is" height="1" width="1"/> http://archive.midrange.com/system21/201201/msg00013.html http://feeds.midrange.com/~r/system21/~3/XwY8xoqyMWM/msg00012.html Geoff Boreland 2012-01-26T18:03:02-06:00 You might also want to contemplate the use of database triggers to ensure you capture all the information required. A typical audit file is only ever going to be as useful as all of the programs that write / update it. As soon as someone performs a write or an update to the master file without including the audit file, then the audit trail is compromised. We have found that installing database triggers will ensure you capture all database I/O's including SQL / DFU style updates, as the I/O is performed at t... <p><a href="http://feedads.g.doubleclick.net/~a/KBsBFXM4HyZgo2hbBSpa1OC-dQY/0/da"><img src="http://feedads.g.doubleclick.net/~a/KBsBFXM4HyZgo2hbBSpa1OC-dQY/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/KBsBFXM4HyZgo2hbBSpa1OC-dQY/1/da"><img src="http://feedads.g.doubleclick.net/~a/KBsBFXM4HyZgo2hbBSpa1OC-dQY/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.midrange.com/~ff/system21?a=XwY8xoqyMWM:6-WhwyDJiNA:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/system21?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=XwY8xoqyMWM:6-WhwyDJiNA:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/system21?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=XwY8xoqyMWM:6-WhwyDJiNA:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/system21?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/system21/~4/XwY8xoqyMWM" height="1" width="1"/> http://archive.midrange.com/system21/201201/msg00012.html http://feeds.midrange.com/~r/system21/~3/F0-ZXPlijoY/msg00011.html Gary Lewis 2012-01-26T07:56:49-06:00 Karim, OEP55 is not especially &quot;optimized&quot; for inserts, rather, it's just that no one has bothered to create any sensible indexes over it. If you create the indexes necessary for your query they will perform fine. This is what I have done and use OEP55a extensively for reporting and audits. Best regards Gary. -----Original Message----- From: system21-bounces@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx] On Behalf Of Karim Khuweldi Sent: 26 January 2012 13:04 To: system21@xxxxxxxxxxxx Subject: [SYSTEM2... <p><a href="http://feedads.g.doubleclick.net/~a/V0R4sNGftgq1uUrCY_N5ZpU5M28/0/da"><img src="http://feedads.g.doubleclick.net/~a/V0R4sNGftgq1uUrCY_N5ZpU5M28/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/V0R4sNGftgq1uUrCY_N5ZpU5M28/1/da"><img src="http://feedads.g.doubleclick.net/~a/V0R4sNGftgq1uUrCY_N5ZpU5M28/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.midrange.com/~ff/system21?a=F0-ZXPlijoY:b-rWYtH6PKc:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/system21?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=F0-ZXPlijoY:b-rWYtH6PKc:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/system21?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=F0-ZXPlijoY:b-rWYtH6PKc:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/system21?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/system21/~4/F0-ZXPlijoY" height="1" width="1"/> http://archive.midrange.com/system21/201201/msg00011.html http://feeds.midrange.com/~r/system21/~3/cQbm0xstTs0/msg00010.html Karim Khuweldi 2012-01-26T07:05:33-06:00 UPDATE TO JANUARY 2012 THREAD &quot;System21 - Time from Pick Note to Despatch Note&quot; 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 ATIM... <p><a href="http://feedads.g.doubleclick.net/~a/lCUjU-kbO5sc0CZQiWZgK37CBfQ/0/da"><img src="http://feedads.g.doubleclick.net/~a/lCUjU-kbO5sc0CZQiWZgK37CBfQ/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/lCUjU-kbO5sc0CZQiWZgK37CBfQ/1/da"><img src="http://feedads.g.doubleclick.net/~a/lCUjU-kbO5sc0CZQiWZgK37CBfQ/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.midrange.com/~ff/system21?a=cQbm0xstTs0:xQC9O1NhL8M:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/system21?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=cQbm0xstTs0:xQC9O1NhL8M:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/system21?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=cQbm0xstTs0:xQC9O1NhL8M:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/system21?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/system21/~4/cQbm0xstTs0" height="1" width="1"/> http://archive.midrange.com/system21/201201/msg00010.html http://feeds.midrange.com/~r/system21/~3/7qXw-4E_iFY/msg00009.html Karim Khuweldi 2012-01-17T07:41:01-06:00 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 wa... <p><a href="http://feedads.g.doubleclick.net/~a/PSajl8RX_sPHE1YrtlEUXLtqTCE/0/da"><img src="http://feedads.g.doubleclick.net/~a/PSajl8RX_sPHE1YrtlEUXLtqTCE/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/PSajl8RX_sPHE1YrtlEUXLtqTCE/1/da"><img src="http://feedads.g.doubleclick.net/~a/PSajl8RX_sPHE1YrtlEUXLtqTCE/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.midrange.com/~ff/system21?a=7qXw-4E_iFY:mVitiHmivB0:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/system21?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=7qXw-4E_iFY:mVitiHmivB0:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/system21?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=7qXw-4E_iFY:mVitiHmivB0:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/system21?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/system21/~4/7qXw-4E_iFY" height="1" width="1"/> http://archive.midrange.com/system21/201201/msg00009.html http://feeds.midrange.com/~r/system21/~3/vhP_NVHgTP0/msg00008.html Gary Pattinson 2012-01-17T07:12:03-06:00 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, &#xA0; Gary Pattinson Project Manager and System21 Specialist I.T.Impact Ltd... <p><a href="http://feedads.g.doubleclick.net/~a/QDW9u7P-AyULp6DOeEyyXY5tyvA/0/da"><img src="http://feedads.g.doubleclick.net/~a/QDW9u7P-AyULp6DOeEyyXY5tyvA/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/QDW9u7P-AyULp6DOeEyyXY5tyvA/1/da"><img src="http://feedads.g.doubleclick.net/~a/QDW9u7P-AyULp6DOeEyyXY5tyvA/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.midrange.com/~ff/system21?a=vhP_NVHgTP0:dD9ZeS5GHYM:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/system21?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=vhP_NVHgTP0:dD9ZeS5GHYM:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/system21?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=vhP_NVHgTP0:dD9ZeS5GHYM:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/system21?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/system21/~4/vhP_NVHgTP0" height="1" width="1"/> http://archive.midrange.com/system21/201201/msg00008.html http://feeds.midrange.com/~r/system21/~3/UcoHwA1T_hY/msg00007.html Karim Khuweldi 2012-01-17T06:05:04-06:00 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... <p><a href="http://feedads.g.doubleclick.net/~a/8fCZ5jInO7NLNx6gJfxhaK-7rB4/0/da"><img src="http://feedads.g.doubleclick.net/~a/8fCZ5jInO7NLNx6gJfxhaK-7rB4/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/8fCZ5jInO7NLNx6gJfxhaK-7rB4/1/da"><img src="http://feedads.g.doubleclick.net/~a/8fCZ5jInO7NLNx6gJfxhaK-7rB4/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.midrange.com/~ff/system21?a=UcoHwA1T_hY:2P5NzsdExLE:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/system21?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=UcoHwA1T_hY:2P5NzsdExLE:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/system21?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=UcoHwA1T_hY:2P5NzsdExLE:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/system21?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/system21/~4/UcoHwA1T_hY" height="1" width="1"/> http://archive.midrange.com/system21/201201/msg00007.html http://feeds.midrange.com/~r/system21/~3/xMBpj8htGFg/msg00006.html Gary Pattinson 2012-01-17T05:58:35-06:00 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, &#xA0; 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 brin... <p><a href="http://feedads.g.doubleclick.net/~a/xQOc_E_d5wB01iq1Z4MCSxR52FQ/0/da"><img src="http://feedads.g.doubleclick.net/~a/xQOc_E_d5wB01iq1Z4MCSxR52FQ/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/xQOc_E_d5wB01iq1Z4MCSxR52FQ/1/da"><img src="http://feedads.g.doubleclick.net/~a/xQOc_E_d5wB01iq1Z4MCSxR52FQ/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.midrange.com/~ff/system21?a=xMBpj8htGFg:_TtUgRz14To:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/system21?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=xMBpj8htGFg:_TtUgRz14To:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/system21?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=xMBpj8htGFg:_TtUgRz14To:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/system21?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/system21/~4/xMBpj8htGFg" height="1" width="1"/> http://archive.midrange.com/system21/201201/msg00006.html http://feeds.midrange.com/~r/system21/~3/mhN4hoOaA4o/msg00005.html Gary Pattinson 2012-01-17T05:51:21-06:00 Sounds like you need to get your report out asap. I think the files you are using are the best, but you may need to be careful which records (including statuses) you match together. Regards, &#xA0; 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 D... <p><a href="http://feedads.g.doubleclick.net/~a/GJnpQvsX54syJ3OLSV568cxXhhM/0/da"><img src="http://feedads.g.doubleclick.net/~a/GJnpQvsX54syJ3OLSV568cxXhhM/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/GJnpQvsX54syJ3OLSV568cxXhhM/1/da"><img src="http://feedads.g.doubleclick.net/~a/GJnpQvsX54syJ3OLSV568cxXhhM/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.midrange.com/~ff/system21?a=mhN4hoOaA4o:pMX9oLlEbUY:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/system21?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=mhN4hoOaA4o:pMX9oLlEbUY:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/system21?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=mhN4hoOaA4o:pMX9oLlEbUY:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/system21?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/system21/~4/mhN4hoOaA4o" height="1" width="1"/> http://archive.midrange.com/system21/201201/msg00005.html http://feeds.midrange.com/~r/system21/~3/KvjnVC_8-r8/msg00004.html Karim Khuweldi 2012-01-17T05:15:43-06:00 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... <p><a href="http://feedads.g.doubleclick.net/~a/G6bpuxzGbOEVms5J_h9qzQkGgFw/0/da"><img src="http://feedads.g.doubleclick.net/~a/G6bpuxzGbOEVms5J_h9qzQkGgFw/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/G6bpuxzGbOEVms5J_h9qzQkGgFw/1/da"><img src="http://feedads.g.doubleclick.net/~a/G6bpuxzGbOEVms5J_h9qzQkGgFw/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.midrange.com/~ff/system21?a=KvjnVC_8-r8:WPlqB-d9808:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/system21?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=KvjnVC_8-r8:WPlqB-d9808:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/system21?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=KvjnVC_8-r8:WPlqB-d9808:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/system21?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/system21/~4/KvjnVC_8-r8" height="1" width="1"/> http://archive.midrange.com/system21/201201/msg00004.html http://feeds.midrange.com/~r/system21/~3/M-CchPQD5rI/msg00003.html Mike Hill 2012-01-17T05:13:58-06:00 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 _______________________________________________ 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... <p><a href="http://feedads.g.doubleclick.net/~a/lIG13ZDadgf9pQB07BfNMor9kYA/0/da"><img src="http://feedads.g.doubleclick.net/~a/lIG13ZDadgf9pQB07BfNMor9kYA/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/lIG13ZDadgf9pQB07BfNMor9kYA/1/da"><img src="http://feedads.g.doubleclick.net/~a/lIG13ZDadgf9pQB07BfNMor9kYA/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.midrange.com/~ff/system21?a=M-CchPQD5rI:jrm4WRBlCd0:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/system21?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=M-CchPQD5rI:jrm4WRBlCd0:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/system21?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=M-CchPQD5rI:jrm4WRBlCd0:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/system21?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/system21/~4/M-CchPQD5rI" height="1" width="1"/> http://archive.midrange.com/system21/201201/msg00003.html http://feeds.midrange.com/~r/system21/~3/VwbCSbObrLk/msg00002.html Karim Khuweldi 2012-01-17T04:55:13-06:00 _______________________________________________ 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 Infor... <p><a href="http://feedads.g.doubleclick.net/~a/c-tfIelTrQK1wPvF54A_T3C8_nw/0/da"><img src="http://feedads.g.doubleclick.net/~a/c-tfIelTrQK1wPvF54A_T3C8_nw/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/c-tfIelTrQK1wPvF54A_T3C8_nw/1/da"><img src="http://feedads.g.doubleclick.net/~a/c-tfIelTrQK1wPvF54A_T3C8_nw/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.midrange.com/~ff/system21?a=VwbCSbObrLk:EyIQkDWrKP0:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/system21?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=VwbCSbObrLk:EyIQkDWrKP0:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/system21?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=VwbCSbObrLk:EyIQkDWrKP0:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/system21?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/system21/~4/VwbCSbObrLk" height="1" width="1"/> http://archive.midrange.com/system21/201201/msg00002.html http://feeds.midrange.com/~r/system21/~3/g4J2fJB3sLQ/msg00001.html Mike Hill 2012-01-17T04:33:09-06:00 <p><a href="http://feedads.g.doubleclick.net/~a/DKQBauY6MkMLzwWwgboP_yqj6Po/0/da"><img src="http://feedads.g.doubleclick.net/~a/DKQBauY6MkMLzwWwgboP_yqj6Po/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/DKQBauY6MkMLzwWwgboP_yqj6Po/1/da"><img src="http://feedads.g.doubleclick.net/~a/DKQBauY6MkMLzwWwgboP_yqj6Po/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.midrange.com/~ff/system21?a=g4J2fJB3sLQ:qvq1g89zMG0:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/system21?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=g4J2fJB3sLQ:qvq1g89zMG0:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/system21?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=g4J2fJB3sLQ:qvq1g89zMG0:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/system21?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/system21/~4/g4J2fJB3sLQ" height="1" width="1"/> http://archive.midrange.com/system21/201201/msg00001.html http://feeds.midrange.com/~r/system21/~3/q8IciUCV-r4/msg00000.html Karim Khuweldi 2012-01-17T04:25:19-06:00 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 &amp; INP57. The part we are struggling with is identifying and matching the pick notes to the confirmations. This is made more difficult when the... <p><a href="http://feedads.g.doubleclick.net/~a/8EHA5F7KMbkQZeOsS8Iz8E8PkcE/0/da"><img src="http://feedads.g.doubleclick.net/~a/8EHA5F7KMbkQZeOsS8Iz8E8PkcE/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/8EHA5F7KMbkQZeOsS8Iz8E8PkcE/1/da"><img src="http://feedads.g.doubleclick.net/~a/8EHA5F7KMbkQZeOsS8Iz8E8PkcE/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.midrange.com/~ff/system21?a=q8IciUCV-r4:cnqjb3pe8zY:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/system21?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=q8IciUCV-r4:cnqjb3pe8zY:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/system21?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/system21?a=q8IciUCV-r4:cnqjb3pe8zY:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/system21?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/system21/~4/q8IciUCV-r4" height="1" width="1"/> http://archive.midrange.com/system21/201201/msg00000.html