Travis > 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.... ;)
I had a client that had a huge tray of pre-printed UCC-128 labels. Each Store had a little compartment. They would put the label on, then scan it, then build the ASN. The labels were printed in bulk by another company.... blehhhhh > ----- 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] > > > > ------------------------------------ > > ... > 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 > > > > > __________ Information from ESET NOD32 Antivirus, version of virus signature > database 6351 (20110804) __________ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > > > 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 <*> 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/
