Hello All
I am looking into Business Central as a possible replacement of our current ERP. I am having a hard time however to find a solution to our current way of working concerning inventory shortages and distributing the available quantity over our customers orders.
Example: Customer A B & C order Product A (1000,500 & 200 pcs). Only 1200 items are on stock (due to shortage or these 3 are unusually large orders) and reordering will take 6 weeks but we have another 500 on the way already. We also want to have some spare stock for other customers that might need Product A in then next few weeks.
If i create a warehouseshipment for these 3 orders and then a picking sheet then the first order will be assigned 1000 to pick and the second order would get 200.
What would be the best approach to mimic this business logic ? Currently all our orders are placed into backorder on creation and then quantities are assigned on creation of the picking sheets for that day where we can see the available stocks and dangerously low stocks are highlighted to show that picking that amount would cause issues.
How can we for example assign 300 from our current stock to Customer A and then assign 200 from the order thats already on its way and place a new order for 500 already assigned to him for later delivery. For customer B we could then assign 200 from current stock, 100 from the PO thats on the way and 200 on a new PO. For Customer C we could deliver 100 from current stock and 100 on a new PO.
Is there for example a way to put certain order lines partially in backorder in MRP as a possible action when it gives a warning ? Can you make PO and reserve that stock to multiple Sales Orders ?
Will those (partial) Sales Order Lines then go to backorder untill that PO is actually received ?
Thanks in Advance
