How to show Batch column in Stock vouchers report?

Discussion in 'Tally Developer' started by suresh mittal, Feb 18, 2024.

    
  1. suresh mittal

    suresh mittal New Member


    Code:
    [#Line : DSP VchInv1Titles]
    Add : Field : After : DSP VchAcctTitle : DBC Batch
    
    [Field : DBC Batch]
    Set As : "Batch"
    Width : 15
    Align : center
    Style : Normal Bold
    
    [#Line: DSP VchInvDetail]
    Add : Field : After : DSP VchItemAccount : DBC Batch1
    
    [Field : DBC Batch1]
    Use : Batch Name Field
    Width : 15
    Set as : $BatchName
    ;Set as :  $$FullList:BatchAllocations:$BatchName
    Align : Center
    Style : Normal bold
    Background: yellow

    I am unable to fetch the batchname in stock vouchers report. But if i put Set as : $Narration it working. Please help
     
    Last edited: Feb 18, 2024


  2. sivam

    sivam Active Member


    [System:Formula]
    MyFormula:$$FullList:BatchAllocations:$BatchName

    [Field : DBC Batch1]
    Use : Name Field
    Width : 15
    Set as : $$FullList:InventoryEntries:mad:@MyFormula
     


  3. suresh mittal

    suresh mittal New Member


    its working Thanks. however is it possible for us to display just the batch that is chosen in the stock voucher?
     


  4. sivam

    sivam Active Member


    Code:
    [System:Formula]
    MyFormula:$$FullList:BatchAllocations:$BatchName
    MyFormula2 : $StockItemName = ##StockItemName
    
    [Field : DBC Batch1]
    Use : Name Field
    Width : 15
    Set as : $InventoryEntries[1,@@MyFormula2].@@MyFormula
     


  5. suresh mittal

    suresh mittal New Member


    not working
     


  6. sivam

    sivam Active Member


    [#Object:InventoryEntry]
    KNSBatchList : $$FullList:BatchAllocations:$BatchName

    [Field : DBC Batch1]
    Use : Name Field
    Width : 15
    Set as : $InventoryEntries[1,@@MyFormula2].KNSBatchList
     
    AMIT JALAN likes this.


  7. suresh mittal

    suresh mittal New Member


    Thank you Functioning flawlessly
     


  8. suresh mittal

    suresh mittal New Member


    Code:
    $$FilterValue:$BatchName:InventoryEntries:First:ForVarGodonwStockItem
    this is also working
     
    AMIT JALAN likes this.


  9. suresh mittal

    suresh mittal New Member


    Code:
    $Description:StockItem:##StockItemName
    How do I show the description of a stock item? The above code is not functioning.
     

    Attached Files:



Share This Page