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
[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
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@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