One way to get around this is to act like the 800 lb gorilla and insist entire orders arrive all at once. This way, when lines 1-3 arrive you can fine your vendor for short-shipping, and when lines 4 & 5 arrive a day later you can fine your vendor for shipping excess merchandise. This makes for a nice profit center.
Failing that, you will need to do some more sophisticated matching, on line number (if you don't allow partial line shipments), or ultimately on item and quantity. Howard Parks 1 Peter 4:10 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of luvinedi Sent: Tuesday, January 10, 2006 3:54 PM To: [email protected] Subject: [EDI-L] EDI Flow Question Hello, hello! The company I work for is in the preliminary stages of implementing EDI, and we plan to start with the 810 (PO), 850 (Invoice) and 856 (ASN). We are in the retail industry, so our trading partners will mainly be vendors and manufacturers. Here is the planned flow on a broad level: 1) We generate the PO and transmit to vendor. 2) They ship what they have and transmit to us an Invoice & ASN. 3) We put the invoice in a staging table (we do not want to import it into our ERP system until the goods have been received). 4) We put the ASN in a staging table (will be used to ensure the physical goods we receive matches the ASN). 5) The goods arrive and is checked against the ASN as it is scanned in. Also, our ERP system assigns a receiver number to this receiving transaction. 6) If all matches, the invoice is submitted to the ERP and all is good; otherwise the invoice and receiver are flagged for manual review by A/P. Now, here is the rub: Since a PO can have multiple receivings and invoices (for partial shipments), how do we identify what receiving / ASN belongs to what invoice? If the ASN contains the invoice number we are home free, but when it does not, on what information do we link them together? For example: Document PO # Invoice # Amount ------------ ----- --------- ------- Original PO 48000 Not known $10,000 ASN (Monday) 48000 Not known $4,000 ASN (Tuesday) 48000 Not known $6,000 Invoice 48000 120 $4,000 Invoice 48000 121 $6,000 As you can see, the PO Number (48000) appears on all documents. The invoice numbers, however, only appear on the invoices. We will also have an internal receiver number and ASN number, but again, those will not be present on any other documents and therefore cannot be used as linking mechanisms. How do you currently get around not having an invoice number on an ASN document? What data do you use as a link between the 850, 810, and 856's? Thank you in advance for any and all guidance! -K . Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Access the list online at: http://groups.yahoo.com/group/EDI-L Yahoo! Groups Links . Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Access the list online at: http://groups.yahoo.com/group/EDI-L Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/EDI-L/ <*> 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/
