Billed Qty & Actual Qty only in Sales Voucher..CODE ATTACHED

Discussion in 'Tally Developer' started by Sagrika, Apr 4, 2015.

    
  1. Sagrika

    Sagrika New Member


    i want to remove billed qty from purchase voucher batch allocation and active for only sales voucher
    please help me in code
    Code:
    ;;[#Field: VCH DiffActualQty]
    ;;Option : VCH DiffActualQty1 : @@IsPurchase
    ;;[!Field: VCH DiffActualQty1]
      ;;Inactive : (@@IsPurchase OR @@IsPurcOrder) OR @@IsDebitNote
    ;;Invisible : (@@IsPurchase OR @@IsPurcOrder) OR @@IsDebitNote
    
    
    [#Line: VCHBATCH ColumnOne]
           
    
                        Local       : Field : VCH GodownTitle     : Invisible : $$IsStockJrnl:##SVVoucherType OR NOT $$IsMultiGodownOn
                        Local       : Field : VCH BatchNameTitle  : Inactive  : NOT @@HasBatchWise
                        Local       : Field : VCH BatchNameTitle  : Align : Right
       
    
    
    
    
    [#Field: VCH QtyTitle]
    
       
        Width :      @@VCHQtyWidth + 5
        SubTitle    : Yes
        Setas       : $$LocaleString:"Quantity"
        Style       : Small Bold
        Align       : Center
        Delete : Border
        Skip        : Yes
        Fixed       : Yes
    
    
    
    
    
    [#Line: EI ColumnOne]
    
    Option : DNS EI ColumnOne : (@@IsSales OR @@IsPurchase) OR (@@IsPurcOrder OR @@IsCreditNote) OR @@IsDebitNote
    
    [!Line : DNS EI ColumnOne]
    
    Local : Field : VCH QtyTitle : Info : "Quantity"
    
    [#Line: EI ColumnTwo]
    Option : DNS EI ColumnTwo : (@@IsSales OR @@IsPurchase) OR (@@IsPurcOrder OR @@IsCreditNote) OR @@IsDebitNote
    
    [!Line : DNS EI ColumnTwo]
    Local : Field : VCH ActualQtyTitle : Inactive : (@@IsSales OR @@IsPurchase) OR (@@IsPurcOrder OR @@IsCreditNote) OR @@IsDebitNote
    Local : Field : VCH BilledQtyTitle : Inactive : (@@IsSales OR @@IsPurchase) OR (@@IsPurcOrder OR @@IsCreditNote) OR @@IsDebitNote
    ;;Local : Field : VCH ActualQtyTitle : Invisible : (@@IsSales OR @@IsPurchase) OR (@@IsPurcOrder OR @@IsCreditNote) OR @@IsDebitNote
    Local : Field : VCH ActualQtyTitle : Delete : Border
    
    
    [#Line : EI InvInfo]
    
    Option : DNS EI InvInfo : (@@IsSales OR @@IsPurchase) OR (@@IsPurcOrder OR @@IsCreditNote) OR @@IsDebitNote
    
    [!Line : DNS EI InvInfo]
    
    Local : Field : VCH ActualQty : Inactive : (@@IsSales OR @@IsPurchase) OR (@@IsPurcOrder OR @@IsCreditNote) OR @@IsDebitNote
    Local : Field : VCH ActualQty : Invisible : (@@IsSales OR @@IsPurchase) OR (@@IsPurcOrder OR @@IsCreditNote) OR @@IsDebitNote
    Local : Field : VCH ActualQty : Delete : Border
    Local : Field : VCH BilledQty : Width :   @@VCHQtyWidth + 5
    ;;Local : Field : VCH BilledQty : Align : Center
    
    
    
    
    
    [!Field: VCH BatchNameTitle1]
    Width : 17
    Align : Centre
    [#Field: VCH BatchNameTitle]
    Option : VCH BatchNameTitle1 :@@IsSales
    
        ;;Width        : if @@HasMfgDateSet OR @@HasExpiryDate then 19 else @@VCHBatchNameWidth
    Width : 19
        Setas       : $$LocaleString:"Batch / Lot No."
        Style       : Small Bold
        Align       : Left
        SubTitle    : Yes
        Border      : Double Sub Column Titles  : @@HasMfgDateSet OR @@HasExpiryDate
        Invisible   : NOT $$IsPhysStock:##SVVoucherType AND NOT @@HasBatchWise
        Skip        : Yes
        Fixed       : Yes
    
    
    
     

    Attached Files:



  2. NAGARAJKMAR SUBRAMANIAN

    NAGARAJKMAR SUBRAMANIAN Active Member


    [#Line: EI ColumnTwo]
    Local: Field: VCH ActualQtyTitle : Invisible: @@Ispurchase

    [#Field: VCH ActualQty]
    Invisible : If @@IsJobOrdersOn or @@Ispurchase Then Yes Else NOT $DiffActualQty

    [#Field: VCHBATCH ActualQty]
    Invisible : If @@IsJobWorkVouchers OR @@IsExciseSupplementaryInv or @@Ispurchase Then Yes Else NOT $DiffActualQty OR $$IsStockJrnl:##SVVoucherType

    [#Line: VCHBATCH ColumnTwo]
    Local: Field: VCH ActualQtyTitle : Invisible: @@Ispurchase
     


  3. Vikas617yadav

    Vikas617yadav New Member


    Dear Nagarajkmar Sir..

    my query is if yellow color total qty auto pickup in Billed qty then , If i selected 1 item then all good but if i selected more then 1 items then last select qty modify for all above items , please suggest me on this topics
     

    Attached Files:



Share This Page