Minimum Order Quantity - Splitting between 2 parts

Kinetic ERP
1

I searched for a thread on this topic but did not find any results.

We have some suppliers that will spread a Minimum Order Quantity across two different (but similar) parts. So if the MOQ is set at 100 units, we can decide if we want to order 30 of part A and 70 of part B (as long as the sum of the quantity between the two parts is 100 or more per PO). Is Epicor capable of flexing on the MOQ splitting between 2 or more parts?

1 Like
2

Hmmm not natively as far as I’m aware. We have a similar situation where our suppliers have an MOQ of a full artic truck and we just need to fill that truck.

I did look into it previously but there were too many unknowns and too many variables to handle.

  • If you only needed 30 units of part A, how would the system know it was ok to fill the order with 70 units of part B?
  • What if you already had 1000 units of part B in stock, would it still suggest you buy 70 units of Part B and be massively overstocked?
  • What happens when you have part C, part D, part E all with their different minimum stock levels? Which part takes priority?
  • Most businesses would typically say “I’ll just fill the MOQ with a fast runner, I’ll sell it next month no problem”. Epicor wouldn’t know which part would fit this role?
  • What if your supplier supplied items with different units of measure?
  • What if you have different suppliers supplying the same item?

Our buyers are currently handling this themselves by reviewing all buying suggestions together, reviewing time phase then building a mixed Purchase Order from the info available.

Currently trying to train AI to give these insights once I’ve fed it enough info on MOQs, part numbers, part consumption history etc…

1 Like
3

Not to hijack your thread but we have the same challenge of having to build truckloads. I am curious to hear more about how you are solving this with AI . . .

We had started to build a solution where po entry calculates the space remaining on the truck by counting the number of pallets already there, but have been bogged down on lack of complete and correct data ie how many of each part go on a pallet, some can be doible stacked some can’t, etc. The manual process is very time consuming and relies heavily on tribal knowledge.