Re: Pick List to Invoice Number translation -- SYSTEM21

Kevin

Your logic is sound, be careful to bear in mind how you commit the picks and how they may be consolidated, i.e. one WHP77 record could be a consolidation of many INP57 pick/despatch lines.

WHP77 does not hold the event type, this can be determined from WHP73 (Action L:ist Header) or WHP75 (Event Header). An event type (EVTP) of '2' indicates a sales pick.

Hope this helps.

Regards ----- Original Message ----- From: "Brunk, Kevin" <KBrunk@xxxxxxxxxxxx> To: "System 21 Users" <system21@xxxxxxxxxxxx> Sent: Thursday, December 02, 2004 2:05 PM Subject: [SYSTEM21] Pick List to Invoice Number translation

I'd like to build a process that creates a file of pick list numbers and their resulting invoice numbers. In our environment, a pick list can contain lines from one or more orders. A separate invoice is produced for each order on the pick list, once the pick is complete and confirmed.

I've looked at a program that can display the pick list associated with a given order and, essentially, I'd like to reverse the process. Conceptually, it looks like I need to read selected WHP77 records to find the correct event number (EVNO77) associated with a pick list number (ACNO77). Having obtained the event number, I should then be able to read INP57 using the event number to find the corresponding Customer Order number(s) and despatch note sequence number. Finally, knowing that, I should be able to read OEP65 using Customer Order number and despatch note sequence number to obtain the corresponding invoice number.

Assuming that's correct logic, my dilemma is how do I determine which WHP77 records represent pick list "events"?

(Santa: can I have a book, for Christmas, that explains the S21 database, field meanings and how files are related?)!!
==Kevin Brunk
The Butler Company
********************************************************************** CONFIDENTIALITY NOTICE: The information transmitted in this message is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy all copies of this document. Thank you. The Butler Company **********************************************************************
_______________________________________________
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.