Unable to explode ledger entries under inventory entries

Discussion in 'Tally Developer' started by software tech, May 15, 2021.

    
  1. software tech

    software tech New Member


    I had a report which will be displayed by a button click from sales voucher
    the report will contain the details about the current sales voucher, which needs to be exported
    in the report, I had a line that repeats inventory entries
    the same line will explode a part for repeating ledger entries
    But I am unable to get ledger entries exploded under inventory entries

    Here is what I done:
    Code:
    
    [Collection:EVListofInv]
        Source Collection:...
        Walk:InventoryEntries
        Compute:StockItemName:$StockItemName
        Compute:Amount:$Amount
       
       
    [Collection:EvListOfLed]
        Source Collection:...
        Walk:LedgerEntries
        Compute:LedgerName:$LedgerName
        Compute:Amount:$Amount
    
    
    ;select $VoucherNumber from ListOfSalesvch
    
    [#Form:Voucher]
        Add:Button:EVsalesRpt
    
    [Button:EVsalesRpt]
        Title:"EV Sales Report"
        Key:ALT+T
        Action:Display:EvSalesReport
        Inactive:NOT @@Issales
    
    [Report:EvSalesReport]
        Form:EvSalesReport
        Title:"Sales Report"
       
    [Form:EvSalesReport]
        Part:EvInvEntries
        Width:100% page
        Height:100% page
    
    [Part:EvInvEntries]
        Line:EvInvEntries
        Repeat:EvInvEntries:EVListofInv
       
    [Line:EvInvEntries]
        Fields:Evfld4,Evfld5
        Explode:EvLedEntries
       
    [Field:Evfld4]
        Use:Name Field
        Set as:$StockItemName
       
    [Field:Evfld5]
        Use:Amount Field
        Set as:$Amount
       
    [Part:EvLedEntries]
        Line:EvLedEntries
        Repeat:EvLedEntries:EvListOfLed
       
    [Line:EvLedEntries]
        Fields:Evfld6,Evfld7
       
    [Field:Evfld6]
        Use:NameField
        Set as:$LedgerName
       
    [Field:Evfld7]
        Use:Amount Field
        Set as:$Amount
       
    
    Any suggestions will be helpfull.
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Make a Collection of Vouchers and Filter it to get SALES Vouchers only.........

    Use Above collection as a SOURCE in your 2 collections.
     


  3. software tech

    software tech New Member


    But I want only the current voucher which user is entering.
    Is there any way to get only the current voucher collection?
     


  4. Vijay Shetye

    Vijay Shetye Member


    Replace
    Source Collection : ...
    to
    Source Collection : Default

    for both the collection
     


Share This Page