We have a manufacture that charges us the additional $x for orders for different B2B customers due to the additional work that goes into palletizing and such. It's baked into the cost they charge us. We use a single SKU for our B2B items which are dropship items (creates outbound PO for us to send via EDI) but now we need to have multiple costs associated with single SKU based on what B2B customer they're going to. If we add a service fee, or second line item for the palletization fee- it breaks the manufacture's EDI integration, so we need to send if over included in the cost.
Item A cost = $250
Pallet fee per Item= $7
Total cost = $257 This is the cost that the Manufacture needs on the outbound PO
It's same concept as Price Levels, but for the acquisition side, so more like a Cost Level. Is there any way to achieve this without blowing up the item master and making SKU's for each supplier/customer cost?
Thanks!