Code :- Code: #Menu : Gateway of Tally] Item : Sales Summary - Item wise : Display : My SalesSummary [Report :My SalesSummary] Form :My SalesSummary Variable : SVFromDate,SVToDate Set : SVFromDate : $$MonthStart:##SVFromdate Set : SVToDate : $$MonthEnd:##SVFromdate [Form :My SalesSummary] Part : MyReportTitle,My SalesSummaryTL,My SalesSummary Button : Change Period,Print Button,Export Button Bottom Part : My SalesSummaryBTM Background : @@SV_UNYELLOW [Part : MyReportTitle] Line :MyReportTitle [Line :MyReportTitle] Field : Simple Field Local : Field : Simple Field : Set As : "Sales Summary - Item wise from " + $$String:##SVFromDate +" to " + $$String:##SVToDate Local : Field : Simple Field : Style : Normal Bold [Part : My SalesSummaryTL] Use : My SalesSummary Delete : Repeat Delete : Scroll Border : ColumnTitles Local : Field : Default : Type : string Local : Field : My SalesSummaryItem : Set As : "Particulars" Local : Field : MyItemsSalesQty: Set As : "Sales Qty" Local : Field : MyItemsSalesRate : Set As : "Avg. Rate" Local : Field : MyItemsSalesAmount : Set As : "Sales Value" Local :Field : Default : Style : Small Bold [Part :My SalesSummary] Line : My SalesSummary Repeat : My SalesSummary :MySalesItems Scroll : Vertical Total : MyItemsSalesQty,MyItemsSalesAmount [Line :My SalesSummary] Field : My SalesSummaryItem Right Field : MyItemsSalesQty,MyItemsSalesRate,MyItemsSalesAmount Border : Thin bottom [Field : My SalesSummaryItem] Set As : $Stockitem Style : Small Display : Item Monthly Summary Variable : StockitemName [Field : MyItemsSalesQty] Use : Qty Primary Field Style : Small Set As : $BilledQtyToT [Field : MyItemsSalesRate] Use : Rate Price Field Set as : $AmountToT / $BilledQtyToT Style : Small [Field : MyItemsSalesAmount] Use : Amount Field Set As : $AmountToT Style : Small [Part : My SalesSummaryBTM] Use : My SalesSummary Delete : Repeat Delete : Scroll Delete : Total Border : Totals Local : Field : My SalesSummaryItem : Set As : "Total" Local : Field : MyItemsSalesQty: Set As : $$Total:MyItemsSalesQty Local : Field : MyItemsSalesAmount : Set As : $$Total:MyItemsSalesAmount Local :Field : Default : Style : Small Bold [Collection : MySalesSummaryCollection] Type : Vouchers : VoucherType Child of : $$VchTypeSales Belongs to : yes Fetch : Date,Inventory Entries [Collection : MySalesItems] Source Collection : MySalesSummaryCollection Walk : Inventory Entries By : Stockitem : $StockitemName Aggr Compute : BilledQtyToT : Sum : $BilledQty Aggr Compute : AmountToT : Sum : $Amount
Dear Psjain_jal and Experts, Very Good tdl, but not getting Quantity Total at Bottom Line. plz. check. Thanks
;; Aggr Compute : BilledQtyToT : Sum : $BilledQty ;; Aggr Compute : AmountToT : Sum : $Amount ;;Compute : BilledQtyToT : Sum : $BilledQty ;;Compute : AmountToT : Sum : $Amount This codes not working in my tally 9 2.14 version please do the needful
I am very happy to see this report but how can i get Items wise Sales Order summary. Can any body help me?
Hello! I have a distribution business and I am looking for a similar report in my tally. Can you help me how to use a code to get the desired report? Thanks