Are there any fields that provide information about a specific warehouse’s stock and the available free stock, and in which doctype, please?
Bin (tabBin) is the Doctype that acts as a cache/materialized view (implemented in python, not postgres) of the Warehouse/ Item quantity levels. “/app/bin/view/report” is probably what you’re looking for.
“Available Free stock” is not a terminology that ERPNext uses. What you’re after is likely some math that takes the “Actual Qty” in Bin and reduces it by some combination of “Reserved Qty”, “Reserved Qty for Production”, “Reserved Qty for sub contract”, “Reserved Qty for Production Plan” depending on your workflow.
Of note, the Bin doctype is time-insensitive; it is only able to to show you the facts as they exist right now.
1 Like