Re: [SYSTEM21] Pick List to Invoice Number translation

["Glenn Melville" <glennmelville@xxxxxxxxxxxxx>]

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.