Different Master Case Quantities

Question

Hello, 
 
 I have a situation where we need to be able to sell the same product with different master pack outs to different customers. For example, I may produce product A which has 72 eaches in a case, but I also produce product A to have 4 eaches in a case that is only sold to Customer B. We produce and stock everything in eaches, but I can't seem to figure out how to stock, pick, and ship the alternate pack items to those specific customers. Does anyone have any ideas?

Julien Patureau · Accepted Answer

There are 2 possible solutions: using a single product code with different pack units or 2 products codes. To me the key questions to ask to pick one or another: 
 
 Do they have the same value in you GL? if not, then better to have 2 different product codes 
 How to track the packing activities? A unit change is simpler but not possible to schedule the load or track the cost. On the opposite, with 2 differents product codes a work order can be useful if youconsider this is part of your production process. An assembly can be a good balance between accurate costing and time entry. 
 What is the stock available that the MRP should consider? What should trigger the packing process? 
 Are you relying 100% on automatic allocation? If, not you have the risk of sending the wrong pack unit to the customer. On the opposite, with 2 differents products no error can be done. 
 Do you have customers that can accept A both in 72/case and 4/case ? 
 Impact on the volume of the product base: if all products can be sold in 20 different units, this will increase the number of product record to handle; 
 Do you have scrap in the packing process? 
 
 I hope this would help choosing the right solution.

Sage X3

Different Master Case Quantities

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING