NEW METHOD

Discussion in 'Tally Developer' started by rajendra mithari, May 9, 2015.

    

  1. DEAR ALL,
    to get items last sale date we can use following method from default tally
    $LastSaleDate:StockItem:##StockItemName
    but how can we get for last sale date for a ledger ? is it as per following ?
    $LastSaleDate:mycoll:##partyledgername
    [collection:mycoll]
    Type : Vouchers : ledger
    Child of : $PartyLedgerName
    Filter : IsSalesVch
    Fetch : VoucherTypeName,Date,amount,LastSalesDate,LastSaleDate

    pl gude
     


  2. admin

    admin Administrator Staff Member


    [collection:mycoll]
    Type : Vouchers : ledger
    Child of : ##LedgerName
    Filter : IsSalesVch
    Fetch : VoucherTypeName,Date
    sort: @@InCr: -$Date

    [System:FOrmula]
    IsSalesVch: $$IsSales:$VoucherTypeName
    [Field:MyField]
    Set As: $$CollectionField:$Date:1:mycoll
     



  3. no sir, its not getting last sales date of partyname of current bill which we are printing.
    also dont understand @@InCr
    is it like this sort:mad:@default: -$date ?

    i got last date by same type of collection but
    last date is not changing , it always same
    for eg partyledger have four sales bills as
    10.04.15 , 20.04.15, 02.05.15 amd 12.05.15
    now each time last date means 12.05.15 or 02.05.15 ( because of Set As: $$CollectionField:$Date :1 : mycoll

    need last date means
    while printing bill of 20.04.15 last bill date 10.04.15
    while printing bill of 02.05.15 last bill date 20.04.15
    now due to the code only 02.05.15 is same for each and all invoices as last date ?

    pl help
     


Share This Page