Dear Admin, I need your help.. how to fetch the part number , item category in this screen. I tried below line but coming [Field : My SalesSummaryItemPart] Set as: $PartNo Style : Small Display : Item Monthly Summary Variable : StockitemPart Width : 10 [Field : My SalesSummaryItemCate] Set As : $StockGroupName Style : Small Display : Item Monthly Summary Variable : StockGroupName [Collection : MySalesItems] Source Collection : MySalesSummaryCollection Walk : Inventory Entries By : StockitemPart :$PartNo By : StockGroupName : $StockGroupName
[Field : My SalesSummaryItemPart] Set as: $PartNo:Stockitem:$Stockitemname Style : Small Display : Item Monthly Summary Variable : StockitemPart Width : 10 [Field : My SalesSummaryItemCate] Set As : $Name:StockCategory:$StockCategoryName Style : Small Display : Item Monthly Summary Variable : StockGroupName
No Sir... Not Coming. Please check my below codes. I need Item Category name & Item Part Number. [#Menu : Gateway of Tally] Item : Sales Summary Item wise - ANAND : 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,;Test 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 : ""; 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 : StockGroupName1 : Set As : "Category" Local : Field : My SalesSummaryItem : Set As : “Descriptipon†Local : Field : My SalesSummaryItemPart : Set As : “PartNoTT†Local : Field : MyItemsSalesQty: Set As : “Sales Qty†Local : Field : MyItemsSalesRate : Set As : “Avg. Rate†Local : Field : MyItemsSalesAmount : Set As :"Amount" 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 : StockGroupName1,My SalesSummaryItemPart,My SalesSummaryItem, Right Field : MyItemsSalesQty,MyItemsSalesRate,MyItemsSalesAmount Border : Thin bottom [Field : My SalesSummaryItem] Set As : $Stockitem Style : Small Display : Item Monthly Summary Variable: StockitemName Border : Thin Left [Field : MyItemsSalesQty] Use : Qty Primary Field Style : Small Set As : $BilledQtyToT Border : Thin Left Right [Field : MyItemsSalesRate] Use : Rate Price Field Set as : $AmountToT / $BilledQtyToT Style : Small [Field : MyItemsSalesAmount] Use : Amount Field Set As : $AmountToT Style : Small Border : Thin Left Right [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 Fetch : Inventory Entries ;By : My SalesSummaryItemPart : $PartNo:StockItem:$StockItemName ;By : StockGroupName1 : $StockGroupName [Field : My SalesSummaryItemPart] Set as: $PartNo:Stockitem:$Stockitemname Style : Small Display : Item Monthly Summary Variable : StockitemPart Width : 10 [Field : StockGroupName1] Set As : $Name:StockCategory:$StockCategoryName Style : Small Display : Item Monthly Summary Variable : StockGroupName Width : 10 ;;By: PartyName : $PartyLedgerName ;;By: ItemName : $StockItemName ;;By : Stockitem : $StockitemName ;;By : StockGroupName1 : $StockGroupName ;;##Category ;;Variable : StockitemName ;;;END OF FILES
i think collection line we need to give extra line .. i dont know exact line. Admin can you give any idea... [Collection : MySalesItems] Source Collection : MySalesSummaryCollection Walk : Inventory Entries By : Stockitem : $StockitemName Aggr Compute : BilledQtyToT : Sum : $BilledQty Aggr Compute : AmountToT : Sum : $Amount Fetch : Inventory Entries
[Field : My SalesSummaryItemPart] Set as: $PartNo:Stockitem:#MySalesSummaryItem Style : Small Display : Item Monthly Summary Variable : StockitemPart Width : 10 [Field : StockGroupName1] Set As : $category:stockitem:#MySalesSummaryItem ; $Name:StockCategory:$StockCategoryName Style : Small Display : Item Monthly Summary Variable : StockGroupName Width : 10
;; try this [#Menu : Gateway of Tally] Item : Sales Summary Item wise - ANAND : 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,;Test 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 : ""; 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 : StockGroupName1 : Set As : "Category" Local : Field : My SalesSummaryItem : Set As : “Descriptipon†Local : Field : My SalesSummaryItemPart : Set As : “PartNoTT†Local : Field : MyItemsSalesQty: Set As : “Sales Qty†Local : Field : MyItemsSalesRate : Set As : “Avg. Rate†Local : Field : MyItemsSalesAmount : Set As :"Amount" 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 : StockGroupName1,My SalesSummaryItemPart,My SalesSummaryItem, Right Field : MyItemsSalesQty,MyItemsSalesRate,MyItemsSalesAmount Border : Thin bottom [Field : My SalesSummaryItem] Set As : $Stockitem Style : Small Display : Item Monthly Summary Variable: StockitemName Border : Thin Left [Field : MyItemsSalesQty] Use : Qty Primary Field Style : Small Set As : $BilledQtyToT Border : Thin Left Right [Field : MyItemsSalesRate] Use : Rate Price Field Set as : $AmountToT / $BilledQtyToT Style : Small [Field : MyItemsSalesAmount] Use : Amount Field Set As : $AmountToT Style : Small Border : Thin Left Right [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 Fetch : Inventory Entries ;By : My SalesSummaryItemPart : $PartNo:StockItem:$StockItemName ;By : StockGroupName1 : $StockGroupName [Field : My SalesSummaryItemPart] Set as: $PartNo:Stockitem:#MySalesSummaryItem Style : Small Display : Item Monthly Summary Variable : StockitemPart Width : 10 [Field : StockGroupName1] Set As : $category:stockitem:#MySalesSummaryItem ; $Name:StockCategory:$StockCategoryName Style : Small Display : Item Monthly Summary Variable : StockGroupName Width : 10 ;;By: PartyName : $PartyLedgerName ;;By: ItemName : $StockItemName ;;By : Stockitem : $StockitemName ;;By : StockGroupName1 : $StockGroupName ;;##Category ;;Variable : StockitemName ;;;END OF FILES
it should be as follows [Collection : MySalesItems] Source Collection : MySalesSummaryCollection Walk : Inventory Entries By : Stockitem : $StockitemName Compute : ItemPartNo : $PartNo:StockItem:$StockItemName Compute : ItemCategory : $Category:StockItem:$StockItemName Aggr Compute : BilledQtyToT : Sum : $BilledQty Aggr Compute : AmountToT : Sum : $Amount Fetch : Inventory Entries and in field levels as follows [Field : My SalesSummaryItemPart] Set as: $ItemPartNo Style : Small Display : Item Monthly Summary Variable : StockitemPart Width : 10 [Field : StockGroupName1] Set As : $ItemCategory Style : Small Display : Item Monthly Summary Variable : StockGroupName Width : 10
Dear Admin.... I tried so many lines... how to add the altf12 and controlf12 button.....in this report.
Super Admin.. I Checked ControlF12 Value Button is working good. But AltF12 not working (Range Button) its coming blank). I am searching more than 2Hrs Admin ..
the default AltF12 and CtrlF12 will be active, based on the variable of the reports and the objects contained therein. If the Objects and Variable are not pertinent, then it will not be active.
Ok Admin.I dont have that much idea for Objects and Variables. But i need one button for Item Group Filter. So give me idea for that .. already i added the button but i don't know the Item Group Filter Line...
That button will not work for your code, as there is no link.....to perform any search/filter on your code. And since you do not know much about Objects and Variables, implementing the same in your code will be complicated for you. Easy way would be to make your own button for search/filter operations. There are few codes on customized search buttons existing in this forum..........find that code, learn and understand it and then you can implement the same within your code.