We are using Product Bundles extensively. Sales Order when saved (before submitting) shows a Packing List with all Items needed for that order.
I think it would make a lot of sense to add three columns in this list showing for each item the actual quantity, projected quantity and projected quantity including that order.
The third column would show the projected quantity of items in picking list including this sales order. Currently there is no way of calculating projected quantity before submitting orders.
Our customers ask for a delivery date estimate before confirming their orders. This would allow us to know whether we need to wait for any material to be supplied.
I am new to ERPNext and python, so it would be great if you could guide me.
In Erpnext, At the time of Delivery Note (means in Save mode) Packing slip get made.
In sales order ,Current Quantity means -your actual Quantity available in warehouse.
Projected Quantity=Actual Qty + Planned Qty + Requested Qty + Ordered Qty - Reserved Qty
Hi, Thanks for the reply.
The current screen is below. I want to add three more columns on this table showing the current qty, projected qty and estimated qty. Current Qty and Projected Qty is as you have explained.
Here the Estimated Qty = Projected Qty + Packing Qty (shown on the column Qty in the below picture)
Those Field you want to display on table view. Make that field as “In List View”
1.Go to Customize Form
2.Enter Form Type =Packed Item
3.click on that
4.Open row of “Actual Quantity”
5.check “In List View”
6.Sames For projected Quantity.
Then click on “Update” button.