We have an Item Number that we actual purchase from 5 different Vendors (different Vendors have different availability from time-to-time). The majority of these Vendors include the cost of shipping into their item price, but one Vendor has their cost of shipping as a separate line item on their invoice. In order to compare the costs of these different vendors on an apples-to-apples basis, I was thinking the best way to do this is to create a Landed Cost for that specific vendor for the Flat Amount of their shipping cost. However, there seems to be the obstacle where if I add the Landed Cost Group to this Item Number, it will automatically apply to POs for all Vendors and we will have to manually remove the Landed Cost Group from all the other vendor's PO. This is something I can see us messing up too much for it to be really worth it.
Does anyone know how to work around this? Or is there a better, automatic way to get the shipping cost applies to the Item Numbers cost?
Thank you,
Jake
*This post is locked for comments