Dear Team,
I am facing an issue where Reserved Qty for Production is not being reduced, even though all Work Orders are “Completed” and all Stock Entries have been “Submitted.”
According to the documentation:
Reserved Qty for Production: Raw materials are reserved on submission of Work Order and is reduced when raw materials are transferred to Work in Progress warehouse via a Stock Entry.
Despite following this process and transferring the materials, the Reserved Qty remains on the items. Could you please advise on how to resolve this or how to recalculate the reserved quantities?
1 Like
@IvanGvozdev Based on how ERPNext calculates reserved_qty_for_production, this field should clear automatically once a Work Order is marked as Completed, Stopped, or Closed. If it is not clearing, please work through the following four checks to identify the cause.
1. Verify the exact Work Order status. Open each Work Order and confirm the Status field reads exactly “Completed”. If a Work Order is only partially finished, the remaining required quantity stays reserved.
- Action: If you do not intend to complete the remaining quantity, click Stop on the Work Order. This explicitly releases the reservation.
2. Confirm the Stock Entry was linked to the Work Order. The reserved quantity only clears if the Stock Entry (type: Material Transfer for Manufacture) is explicitly linked to the Work Order via the Work Order field on the entry.
- If you created the Stock Entry manually without selecting the Work Order in that field, the system has no way to reduce the reservation for that specific order.
3. Check the “Skip Material Transfer” setting Did you enable Skip Material Transfer on the Work Order?
- When this option is enabled, the system can fail to trigger the Bin update correctly upon Stock Entry submission. This is a known edge case in certain versions. (source)
4. Check the Bin record directly Go to the Awesomebar → search Bin → filter by your Item Code and Warehouse. Open the record and check the value of reserved_qty_for_production.
- This confirms whether the issue is a display/cache problem or an actual incorrect value in the database.
Recommended fix to try first (no technical access required):
Go to Stock → Tools → Repost Item Valuation → create a new entry → select the affected Item and Warehouse → click Submit.
This recalculates stock balances and may trigger a background update of the Bin record. (source)
(Note: Repost Item Valuation primarily targets valuation discrepancies. It may not directly fix Bin reservation fields in all cases — flagging this honestly rather than overpromising.)
If the issue persists: Please share your ERPNext version and the exact Work Order name. A verified bench console command can then be provided that is specific to your setup. We are intentionally not sharing an unverified command to run against production data.
Please share which Stock Entry type you used and we can narrow this down further.
@Falguni_Satat_Tech
I will suggest you to re consider your message cleanly after copying it from ChatGPT.
@ahsantareen Sorry, I didn’t understand that. We’re all helping each other here, so let’s keep the conversation respectful.
Thank you for your response.
However, that is exactly the problem: all Work Orders associated with this item are already Completed, and all related Stock Entries have been Submitted.
Despite the full completion of the production cycle and material transfer, the Reserved Qty is still not being released. It seems like the stock levels are stuck.
