How to table all opening batch names

Discussion in 'Tally Developer' started by dhanapal, Aug 30, 2012.

    
  1. dhanapal

    dhanapal New Member


    How to table all opening batch names without give stockitem.
    Only All Batchs in Table.
    If I have 001,002 batches in item01 and 003,004 in item02
    I need Table as Below
    001
    002
    003
    004

    Help . as soon as possible.
     


  2. admin

    admin Administrator Staff Member


    [Collection : Stock Main Coll]
    Type: Stock Item

    [Collection : Stock Coll]
    Source Collection: Stock Main Coll
    Walk : Batch Allocations
    By : Batch Name : $batchName
    Format : BatchName

    [Field: My Field]
    Table : Stock Coll
     


  3. gtendra

    gtendra Member


    not working sir
     


  4. vishnu joshi

    vishnu joshi Member


    ;Try This

    Code:
    [Collection: Barcode Item List_COl1]
        Type        : Stock Item
        Fetch        : GSTRateVal
        Fetch        : Parent, GodownName, BatchName, IsBatchWiseOn, Name, StkClBalance, TBalClosing,  StkClBalance
          Fetch        : MFdOn, Expiry Period, StockItemName, ClosingBalance,ClosingValue, ClosingRate, OpeningValue, StkOpBalance
        Fetch        : TBalOpening, TBalCredits, StkOutQty, StkInQty, TBalDebits, TBalNettCredits,BarcodeNo2,PurcRate,GSTRateVal,SellingPrice
         Compute        : GSTRateValNew: $GSTRateVal
        Filter        : IsItemBatchEnabled
       
    
    [Collection: Barcode Item List_COl2]
        Type        : Stock Item
        Fetch        : GSTRateVal
        Fetch        : Parent, GodownName, BatchName, IsBatchWiseOn, Name, StkClBalance, TBalClosing,  StkClBalance
          Fetch        : MFdOn, Expiry Period, StockItemName, ClosingBalance,ClosingValue, ClosingRate, OpeningValue, StkOpBalance
        Fetch        : TBalOpening, TBalCredits, StkOutQty, StkInQty, TBalDebits, TBalNettCredits,BarcodeNo2,PurcRate,GSTRateVal,SellingPrice
         Compute        : GSTRateValNew: $GSTRateVal
        Filter        : IsItemBatchNotEnabled
    
    [System:Formulae]
        IsItemBatchNotEnabled        : $IsBatchWiseOn=No
    
       [Collection: Barcode List_COl1]
       
            Collection        : Barcode BatchList_COl1 : Barcode Item List_COl1
    Format : $Name,20
    Format : $Parent,20
     


  5. vishnu joshi

    vishnu joshi Member


    Use this code

     


  6. gtendra

    gtendra Member


    GIVE ME ERROR SIR : COULD NOT FIND COLLECTION DESCRIPTION OF Barcode BatchList_COl1

    PLZ HELP SIR HOW TO USE
     
    Last edited: Feb 6, 2024


  7. vishnu joshi

    vishnu joshi Member


    Add this Collection

    Code:
    [Collection: Barcode BatchList_COl1]
       
        Type        : Batch
        Child Of    : ($$LoopCollObj:$Name)
        Fetch        : Parent, GodownName, BatchName, IsBatchWiseOn, Name, StkClBalance, TBalClosing,  StkClBalance,PurchVCHSRate
          Fetch        : MFdOn, Expiry Period, StockItemName, ClosingBalance,ClosingValue, ClosingRate, OpeningValue, StkOpBalance
        Fetch        : TBalOpening, TBalCredits, StkOutQty, StkInQty, TBalDebits, TBalNettCredits,BarcodeNo2,PurcRate,GSTRateVal,SellingPrice
        Fetch        : SClosingRate
       
        Format        : $$Name
        Compute Var : cvStkItemParentAlias    : String  : $$ReptField:Name:2:StockItem:$Parent
        Compute Var : cvStkItemParentPNAlias: String  : $$ReptField:MailingName:2:StockItem:$Parent
        Compute Var : cvStkItemParentPNName    : String  : $PartNo:StockItem:$Parent
        Compute Var : cvStkItemParentDesc    : String  : $Description:StockItem:$Parent
    
        Compute        : StkItemParentAlias    : ##cvStkItemParentAlias
        Compute        : StkItemParentPNAlias    : ##cvStkItemParentPNAlias
        Compute        : StkItemParentPNName    : ##cvStkItemParentPNName
        Compute        : StkItemParentDesc        : ##cvStkItemParentDesc
        Compute        : GSTRateValNew            : $GSTRateVal:stockItem:$parent
    
     


  8. gtendra

    gtendra Member


    DEAR SIR
    HOW TO CHANGE MODE OF STOCK JOURNAL VOUCHER TO INTER GODOWN TRANSFER WITHOUT USE ANY CLASS
    BY DEFUALT OPEN IN "INTER GODOWN TRANSFER"
     


  9. sivam

    sivam Active Member


    Add a new menu with create collection option and add class name in that report
     


  10. gtendra

    gtendra Member


    NOT USE ANY CLASS NAME DIRECT OPEN STOCK JOURNAL IN INTER GODOWN TRANSFER
     
    Last edited: Feb 17, 2024


  11. sivam

    sivam Active Member


    Try this
    Code:
    [#Form: Stock Journal Voucher]
    
        Switch        : STKJrnlVoucher    : GTRN StkJrnl  : yes
     


Share This Page