Help need in this tdl file

Discussion in 'Tally.ERP 9' started by silpa dravid, Jun 7, 2021.

    
  1. silpa dravid

    silpa dravid Member


    Code:
    ;;===== STOCK item
    [*Collection: Vch Stock Item Extract]
    
        Use            : ExtractAlias Collection
        Source Collection    : Stock Item Src
        Collection        : StockItem PartNo With Closing
        Title               : $$LocaleString:"List of Items                                     Stock Qty     LastSale Price "    
        Fetch               : Name, VchStkItmBalance,LastSalePrice,ClosingBalance
        Set as             : $FirstName
        Keep Source        : ().
        Client Only        : Yes
        Format          : $VchStkItmBalance   : "Base"
        Format          : $LastSalePrice: "Base"
        ;Format          : $RateofMRP: "Base"
    
    
       
    Filter      : Zero Filter21
    [System: Formula]
    
      
    Zero Filter21 : NOT $$IsEmpty:$ClosingBalance
    I am getting the empty closing balance but if i want to purchase any new stock, stock item is not allowing
    in purchase voucher.
     


  2. Himanshu-2002

    Himanshu-2002 Active Member


    Then Write the Formula Like This

    ZeroFilter: $$IsPurchase:##SVVoucherType AND Not $$IsEmpty:$ClosingBalance
     
    silpa dravid likes this.


  3. silpa dravid

    silpa dravid Member


    not working
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    remove the filter. Why you need it, when you want to enter data?
     
    silpa dravid likes this.


  5. silpa dravid

    silpa dravid Member


    Amit sir i want the filter for sales only
     


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Do it this manner.............

    [#Collection: Vch Stock Item Extract]
    Use : ExtractAlias Collection
    Source Collection : Stock Item Src
    Collection : StockItem PartNo With Closing
    Title : $$LocaleString:"List of Items Stock Qty LastSale Price "
    Fetch : Name, VchStkItmBalance,LastSalePrice,ClosingBalance
    Set as : $FirstName
    Keep Source : ().
    Client Only : Yes
    Format : $VchStkItmBalance : "Base"
    Format : $LastSalePrice: "Base"
    ;Format : $RateofMRP: "Base"
    Filter : Zero Filter21
    Option : RemoveFilteronPur : $$InCreateMode
    [!Collection : RemoveFilteronPur]
    Delete : Filter : Zero Filter21
    [System: Formula]
    Zero Filter21 : NOT $$IsEmpty:$ClosingBalance
     
    silpa dravid likes this.


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    I have just made a general condition........ $$InCreateMode.......... you can alter that for selective Vouchers also.
     


  8. silpa dravid

    silpa dravid Member


    Thank you amit sir for ur help
    got it by changing
    Option : RemoveFilteronPur : $$IsPurchase:$VoucherTypeName
     
    Last edited: Jun 8, 2021


Share This Page