Get all Inventory From Voucher

Discussion in 'Tally Developer' started by Tejesh, Feb 8, 2021.

    
  1. Tejesh

    Tejesh New Member


    Walk: All Inventory Entries
    Fetch : StockItemName, BilledQty, Rate, Discount,Amount
    Fetch : VoucherNumber,CurrencyName, Date, PartyLedgerName,Reference,Address,Statename,CountryofResidence,HSNCode,VoucherTypeName,GodownName,LedgerName,ReferenceDate
    By : VoucherNumber : $VoucherNumber
    By : CurrencyName : $CurrencyName
    By : PartyLedgerName : $PartyLedgerName
    By : PartyGSTIN : $PartyGSTIN
    By : Reference : $Reference
    By : Address : $Address
    By : Statename : $Statename
    $$ListValue : Addresslist : $Address
    By : CountryofResidence : $CountryofResidence
    By : HSNCode :$HSNCode
    By : VoucherTypeName : $VoucherTypeName
    By : Item : $StockItemName
    By : GodownName :$GodownName
    By : LedgerName :$LedgerName
    By : SubAmount :$Amount
    Aggr Compute: BilledQty : Sum : $BiledQty
    Aggr Compute : Date : $Date
    Aggr Compute : ReferenceDate :$ReferenceDate
    Aggr Compute : Discount :$Discount

    [Collection : All Vouchers]
    Type : Voucher
    Fetch : BasicDueDateOfPymt,PartyLedgerName,LedgerName
    Belongs To : Yes
    Set : SVFromDate : Date : 20180401
    Set : SVToDate : Date : 20200331




    The problem is it loop all the inventory . but if the same inventory repeat it will not get that the inventory it will ignore i need that to so match the total amount.
    eg:- In a voucher
    product1. 1no
    product2. 2no
    product1. 1no
    product2 5no

    in this example i can get product 2 2no and product2 5no but i will get product1 1no . the 3rd time product1 1no i didnot get
     


Share This Page