Dear Experts, What is the Formula For Free quantity .I want to add New Field in sales Voucher Free Quantity . When We are Giving Actual Quantity Billed Quantity Free Quantity Should come Automatically. Plz Help me. Thanks in Advance.
Dear sir Thanks For Reply where i want to use this function in Field level at set as or i want to use system formula and use collection please help me.
hello sir i use 2 user-defined fields 1)BF 2) GSM and this 2 field multiplication totalvalue display in existing field Quantity....colmn plz sir ,,,,i need this things
[#Part: DBC QtyDetails] Line : DSP ColVchDetail Repeat : DSP ColVchDetail : Inventory Entries Here you can add your field and set as : $ActualQty - $BilledQty
In sales entry, your actual qty should be more than billed qty, only then you'll get positive free qty
Yes my actual qty is more than billed qty. When i use this formula it gives negative of billed qty. Means,Suppose my Billed qty is 5, Then on my created field it gives (-5). By this formula only
Here is my code [#Part: DBC QtyDetails] Line : DSP ColVchDetail Repeat : DSP ColVchDetail : Inventory Entries [#Line: DSP VchDetail] Add : Field: DBC FreeQty [Field: DBC Freeqty] set as: $Actualqty - $Billedqty color: Blue width:12 Please check and revert