As it was a good query for general day to day purpose one needs the Total Sales Figures as on date while making the invoices. Keeping that in mind i had created one TDL for the same.
hello mr taufeeq nice tdl but it shows both on sales and purchase voucher.it would be nice if it only shows in sales voucher
[#Line: EI PartyLimit] Add : Field : After : EI CurrentBalance : TotSales [Field : TotSales] Invisible : NOT ##CurBalanceFlag or NOT @@IsSales Field : Simple Prompt, Amount Field Local : Field : Simple Prompt : Info : $$LocaleString:"Total Sales as on date:" Local : Field : Simple Prompt : Width : 14 Local : Field : Amount Field : Set as : @@TrsTotSales Local : Field : Amount Field : Format : "Symbol,DrCr" Local : Field : Amount Field : Set always : Yes Local : Field : Amount Field : Color : Red [System : Formula] TrsTotSales : $$FromValue:$Date:$$ToValue:$Date:$CreditTotals:Group:$$GroupSales ;$$ToValue:$Date:$CreditTotals:Group:$$GroupSales
dear Sir I m using your code as on Date get item wise total Qty but my requirement is Item Wise Daily Report i m getting yesterday Total Qty as per code but get sales Qty i want Receipt Note Qty what i do. My Field [Field: RemoteInQty] ;; Receipt ;;Purchase Qty Use : Number Field ;;RemoteOpQty Set as : $TrPurcQty Border : Thin Right Set always : Yes [Collection: RemoteVoucher Collection] Type : Voucher [Collection: RemoteSItemColl] Source Collection : RemoteVoucher Collection Walk : All Inventory Entries Compute : TrPurcQty : $$FromValue:##SVFromDate:$$ToValue:##SVToDate:$BilledQty plzzzzzzzzzzzzzzzzzzzzz help i need this report
sir, same like that , we want closing stock qty as voucher date can u modify my code. [#Collection : VCH Stock Item Extract] Add : Subtitle : "My CL.QTY " Add :Format :$$AsSignedQty:$$ToValue:$Date:$$FilterAmtTotal:BatchInGodownName:GdwnOpBalStkClfltr:$TBalClosing,10