What is the Formula For Free quantity

Discussion in 'Tally Developer' started by NMS, Oct 31, 2012.

    
  1. NMS

    NMS Member


    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.
     


  2. Kamal Sharma

    Kamal Sharma New Member


    $ActualQty-$BilledQty
     


  3. NMS

    NMS Member


    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.
     


  4. Kamal Sharma

    Kamal Sharma New Member


    Add a new field on Item Alllocation level and set the value as above
     


  5. kamalpatel

    kamalpatel New Member


    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
     

    Attached Files:



  6. mahgs

    mahgs Member


    Dear Kamal patel:

    Upload your code for best understanding and solve this problem
     
    kamalpatel likes this.


  7. kamalpatel

    kamalpatel New Member


    sir i hope you will rectify my code and reply me whr i am wrong.... sir..
    thank you,
    sir
     


  8. Neha19

    Neha19 Member


    How to Find Free Qty in Sales Columnar Report?
    Please Help
     


  9. balajimg

    balajimg Active Member


    [#Part: DBC QtyDetails]
    Line : DSP ColVchDetail
    Repeat : DSP ColVchDetail : Inventory Entries

    Here you can add your field and set as : $ActualQty - $BilledQty
     


  10. Neha19

    Neha19 Member


    This Code is giving Negative Value of BilledQty. M not getting Free Qty
     


  11. balajimg

    balajimg Active Member


    In sales entry, your actual qty should be more than billed qty, only then you'll get positive free qty
     


  12. Neha19

    Neha19 Member


    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
     


  13. Neha19

    Neha19 Member


    Shall i post my code here???
     


  14. Neha19

    Neha19 Member


    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
     


  15. balajimg

    balajimg Active Member


    its correct
     


  16. Neha19

    Neha19 Member


    Not working
     


  17. balajimg

    balajimg Active Member


    check your entry, actual qty should be more than billed qty
     


Share This Page