Yes, SAP, for one, can do this. I imagine others, do, as well. Scanning is handy for this (no that I claim to know exactly how that works).
Leah ________________________________ From: Travis Truax <[email protected]> To: Earl Wertheimer <[email protected]> Cc: Joe Matuscak <[email protected]>; [email protected] Sent: Thursday, August 4, 2011 2:10 PM Subject: Re: [EDI-L] 856 design theory documents/web sites/books?? Has anyone worked with a shipping system that didn't record the pallet/case relationship? Where users pre-print labels or stick labels on cartons before they're assigned to a pallet, and determine the pallet after the fact... in some way.... ;) Travis- ----- Original Message ----- From: "Earl Wertheimer" <[email protected]> To: "Joe Matuscak" <[email protected]>, [email protected] Sent: Thursday, August 4, 2011 11:59:50 AM Subject: Re: [EDI-L] 856 design theory documents/web sites/books?? Joe > I'm in the process of working through a design of an 856 transaction and > I've been looking for something that would describe generic design considerations > in the implementation of an 856. Things like how what makes sense for the > hierarchy, etc. I've Googled around and while I've found lots of organizations > implementation guides, I've not found anything that really addresses sort of > addresses the zen of how to build an 856. Brian covered it perfectly: Here's the "golden rule": 1. what's on the truck? (ship level) 2. what orders/invoices are on the truck? (order level) 3. what pallets are on the truck? (maybe) 4. what cartons are on the pallet? (carton level) 5. what's in the box? (item level) ----------------- Bottom line: You need to convert your incoming POs (or existing ERP Orders) into the S (truck) O (Order) T (Tare/Pallet) P (Carton) I (Item) structure. Each of these levels is nested under the next up. I was able to combine the T and P levels with an optional Pallet code. You need at least 3 tables to hold all the data. (important data fields) 1) S = Shipment table (B/L#, ShipTo, ShipDate) 2) T/P = Carton Header (20 digit UCC carton#, UPS waybill(optional), Store, MarkFor, CustomerPO, Pallet# ) 3) I = Carton Details (Item info, pointers back to Order line) I can send you file layouts, etc... or screen shots. The ASN S level is built from the Shipment The O level is built from the CartonHeader.CustomerPO grouping. The T level is built from the CartonHeader.Pallet# grouping (I have not seen this a lot until recently) The P level is build from the CartonHeader The I level is built from the CartonDetails. Earl Wertheimer [email protected] http://www.spe-edi.com ------------------------------------ ... Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Job postings are welcome, but for job postings or requests for work: <JOBS> IS REQUIRED in the subject line as a prefix.Yahoo! Groups Links [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] ------------------------------------ ... Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Job postings are welcome, but for job postings or requests for work: <JOBS> IS REQUIRED in the subject line as a prefix.Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/EDI-L/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/EDI-L/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
