dear Sir i m also Design customize report Sales That Report Display in Stock Item Wise Group please help any no idea to group
Dear admin, i want to add some column in this following code. like godown wise / location wise sales report Particular | Location -1 sales Qty | Location -2 sales Qty | Location -3 sales Qty | Total Sales Avg sales Sales Value ABC | 20 | 50 | 10 | 80 XYZ | 60 | 20 | 50 | 130 [#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
Sir, Child of : $$VchTypeSales for sales Child of : $$VchTypeSalesorder for sale order Child of : $$VchTypePurchsae for purchase please guide me that what will be for manufacturing ? I want to generate report in same way for manufacturing . my manufacturing voucher "MFG" is under "Stock journal". Please guide me. Thank you