Share
Report
5Hi All,
I am a consultant who has been working with BC / NAV for nearly 15 years.
Regarding reservations in Business central, I have a question, if anyone has come across this before please? We have reservations set on Items to Always as want to ensure stock allocation on oldest sales order first basis. Some customers may request a delivery date far into the future, but their stock should be retained i.e. reserved for that order even if new sales orders are received.
This would do the following as set up currently:-
If a Sales Order has a requested delivery date of 01/04/2022.
Then a Purchase Order is created that has an expected receipt date after that date, then auto reserve will not reserve the purchase order against that sales order, nor can you reserve manually against that sales order (I don't believe as SO date in after the PO receipt date). Say the expected receipt date was the set to 15/04/2022 on the Purchase Order.
If a new Sales Order is created with a requested delivery date after that purchase order, say the 20/04/2022, then that sales order would automatically reserve against the purchase order (even if the reason for creating that PO was essentially to fulfil the first sales order). A user would then let the customer know they can have the item on the 20th as requested....
Even if the quantity received on the 15th on the Purchase Oder is sufficient to fulfil Sales Order 1 and Sales Order 2, only Sales Order 2 will end up with reservation entries against physical stock when the items are received. The original Sales Order will stay with no reservation. Any new sales order for that item, would create an automatic reservation from physical stock.
To correct, a user would need to firstly know that sales order could be reserved against actual stock, then open the sales order and manually reserve each line on the sales order. A tedious task for all open sales orders and one for which there is no report or easy way to work out which sales orders lines could be now manually reserved from available stock.
The only way I can see to fix is development to:-
1. Prevent Reservations of Sales Orders against Purchase Orders.
2. Allocate physical stock receipts to reserve against Sales Orders, oldest Sales Order first as Purchase Orders are received into stock.
Any other suggestions? Am I missing something?
Thanks
All responses (
Answers (
