Item XRef by Ship To

[tShip]

we are receiving 10 - 15 complaints per month for shipping the wrong pack size to customers. The main problem is that JDE's Item Cross Reference Table is set up at the customer Sold to Level, as opposed to the customer Ship To level. The customer may only have 1 part # company wide for one of our products, but it may be for a different pack size based on location. For example:

Enron's cross reference item number for our 101010 - Soda. However, their Park plant takes XXXXX1005 which is a 5 kg pack and their Happyville plant takes XXXXX1300 which is a 20 kg pack.



Therefore, since we are unable to set up their cross reference item number at the Ship To level, there is no way to be certain what pack size they want when they order by their part number.



The second problem we face by not being able to set up the Item Cross Reference number at the Ship To level is that different locations for the same company may actually have different numbers for the same Sensient resource number. For example:

Several different divisions of PLAM buy our YYYYY Juice. For some locations their item cross reference number is NNNNTTT54 but for other locations their item number is 12A54NO2. However, since the Item Cross Reference Table is set up at the Sold To level there is no way to differentiate this if the invoice is going to the same address.

 

[mateo31]

Except customization, you could prevent to accept an order on the wrong couple item-Ship to thanks to the advanced pricing. I suppose there is already a post related to that tips.
Refer you to mandatory prcing adjustment which prevent an order entry if this kind of adjustment doesn't apply. You can define a item complex group based on allowed items for ship-to.
Don't hesitate to get back to me for further explanation.