Sage 100

2014 Premium. End user is a distributor of many products that have serialized inventory valuation. They may sell 20 of an item and 10 items ship in one box and 10 items ship in another box, and each box has a different tracking number. Some of the large customers have requested an advance ship notice detailing the tracking numbers associated with each serial number. It gets worse.... They want to have a similar configuration in purchase order receipts. Because many PO receipts are drop shipped they are requesting the primary vendors, via EDI to transmit an ASN detailing tracking information by serial number. Because a PO is tied to a sales order on drop ship orders, the serial number / tracking information can be joined to the sales order and invoice data entry tables. Does anyone know of an existing enhancement or other solution?

Sounds like a Starship + TrueCommerce (High Jump) solution. They integrate quite nicely and can probably do what you are needing

They have Starship and TrueCommerce. True Commerce is not yet implemented but will be ready to go by February 1. They won't be using the X12 protocol. They will be using custom XML that all the trading partners will need to conform to. I'm still unclear how we could report to the customer the invoice number, item number, quantity shipped, serial number for each item, and tracking number by serial number in this case: One item code ships more than one serialized item, and the items are separated in different boxes with different tracking numbers. The Sage 100 SO_InvoiceTracking table doesn't have a serial number field.

I believe Starship BOI can package the items in any way you want, including by serial. Starship then knows what's in each package, including Invoice#, item#, serial, etc. It also creates the shipping labels so it knows the tracking number of each package. That info is sent to TrueCommerce allowing you to do the ASN. It doesn't go through Sage100. Give Starship a call, I could be misunderstanding all that is needed by your customer

Thanks Kenny. On the sales side that makes sense. They drop ship about 70% of the sales directly from the vendor. The vendor will send an ASN (Receipt of Goods or Receipt of Invoice) that contains the tracking number by serial number. We need a way to capture that information and link it back to the sales order and the SO invoice so that the tracking information can be displayed on the customer portal. I know the info may be able to be captured in the Starship db but ideally we would like to have it reside in Sage 100 so that the reporting from the sales side will be consistent with the drop ship data received from the vendors.

Looks like you will need to use a drop ship warehouse as it doesn't seem to let you record serial numbers at all on drop ship PO receiving. Then you could add a UDF to the receipt line distribution table and have it flow through to lotserial history and the sales side.

That is a good idea Phil... as long as the udf can be mapped to the correct tables.