Mark,One possible solution is to have each product in a different stocking location for each country (if you are already using Location Control). Then using user exit UMBSHP8R, create a shipment Item comment based on the location's characteristics. If you ship from multiple locations, you could even create the comment for each stock location: Country of Origin Mexico - xx units, Country of Origin France - xx units, etc.
I had to investigate this for a similar problem but did not have to create the code since my customer stopped purchasing products from one of the countries.
We manufacture products in multiple production facilities including the US, China, Mexico, and France which are the same product. Based on capacity we may sell product though the US facility from any of the other facitiltes. This creates a problem for NAFTA and other export compliance since we need to identify the county of origin. Currently we have a different part number of each county of origin for example part 123 is from the us and C123 is from China. This creates a problem because we may choose to ship product produced in a different facility as a result of regional capacity or quality issues, if we do this we need to maintain the order to change the ordered part. How are others tracking country of origin for product with multiple countries of origin?
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.