Itemwise-SalesRoprt18082019

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

 

Help me Admin....

 

but Collection Line no need mention.. Why because not appearing

 

[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

 

Fantastic... Thanks for your help @admin ,@Murali & @Rajendra.....☺☻

 

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 ..

 

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...

 

THIS IS ITEM WISE SALES REPORT