Party-Wise Product-Wise Qty Sales Report

very good tdl sir . thank you very much

 

I did not remember the name but who asked 4 sales order report TDL take little time and find form "gst bill" tdl . It has it find that tdl and edit as per Ur requirement.
Regards

 

Can anybody provide a tdl for billwise-itemwise-quantity for Tally.

 

Search forum it is there.
Thanks

 

Search forum it is there.
Thanks

 

Hello,
I want to filter item stock according to my stock group I had selected on Partywise Item sales Report. Plz help me...……………..

 

Here is the code
[#Menu: Gateway of Tally]
Item: My Report: Display: CFBK Rep
[Report: CFBK Rep]
Use : DSP Template
Form : CFBK Rep
Variable : DoSetAutoColumn, IName
Repeat : IName
Set : DoSetAutoColumn : Yes
Set : DSPRepeatCollection : "CFBK Party"
Set : SVFromDate : $$MonthStart:##SVCurrentDate
Set : SVToDate : $$MonthEnd:##SVCurrentDate
[Form: CFBK Rep]
Use : DSP Template
Parts : PrtHdr,CFBK Rep
Background : White, Light Orange
Button : ExplodeFlag, ChangeDybkDate, ChangePeriod
BottomButton : BlankButton, RelReports, InvReports, AcctReports, Report Operations, StatRegConfigure, FilterButton, ValueButton
Bottom Toolbar Buttons : BottomToolBarBtn1, BottomToolBarBtn2_EditVch, BottomToolBarBtn3, BottomToolBarBtn4, BottomToolBarBtn5, BottomToolBarBtn6, BottomToolBarBtn7, BottomToolBarBtn8, BottomToolBarBtn9, BottomToolBarBtn10, BottomToolBarBtn11, BottomToolBarBtn12
Button:Stkgroupbtn
Buttons : PrintButton, ExportButton, UploadButton, MailButton
Option : Set Auto Vch Option : ##DoSetAutoColumn AND $$SetAutoColumns:IName
[!Form: Set Auto Vch Option]
[Part: PrtHdr]

Lines : PrtHdr
[Line: PrtHdr]

Field : Name Field
Right Field : DSP MainDateTitle
Field : FldHrd
Local : Field : Name Field : Style : Normal Bold
Space Bottom : 1.5

[Field: FldHrd]

Set As : "Party-Wise Product-Wise Sales QTY Report"
Style : Normal Bold
FullWidth : Yes
Border : Thin Bottom
Align : Centre
Skip : Yes
Fixed : Yes
Width : 50% Screen
[Part: CFBK Rep]
Lines : CFBK Rep Title, CFBK Rep Details
BottomLines : CFBK Rep Total
Repeat : CFBK Rep Details : Smp Stock Item
Scroll : Vertical
CommonBorder: Yes
Total : CFBK Rep Party, CFBK Rep Col Total
[Line: CFBK Rep Title]
Use : CFBK Rep Details
Local : Field : Default : Type : String
Local : Field : Default : Align : Center
Local : Field : CFBK Rep Name : Set as : "Particulars"
Local : Field : CFBK Rep Name : Widespaced: Yes
Local : Field : CFBK Rep Party : Set as : ##IName
Local : Field : CFBK Rep Party : Lines : 0
Local : Field : CFBK Rep ColTotal : Set as : "Total"
Border : Flush Totals
[Line: CFBK Rep Details]
Fields : CFBK Rep Name, CFBK Rep Party, CFBK Rep Col Total
Repeat : CFBK Rep Party
Total : CFBK Rep Party
[Field: CFBK Rep Name]
Use : Name Field
Set as : $PName
Variable : LedgerName
Display : Ledger Monthly Summary
[Field: CFBK Rep Party]
Use : Qty Primary Field
Set as : $$ReportObject:$$CollectionFieldByKey:$BilledQtyMyFormula:CFBKSummVoucher
MyFormula : ##IName + #CFBKRepName
Format : "NoZero"
Border : Thin Left
[Field: CFBK Rep Col Total]
Use : Qty Primary Field
Set as : $$Total:CFBKRepParty
Border : Thin Left
[Line: CFBK Rep Total]
Fields : CFBK Rep Name, CFBK Rep Party, CFBK Rep Col Total
Repeat : CFBK Rep Party
Local : Field : Default : Type : String
Local : Field : Default : Align : Center
Local : Field : CFBK Rep Name : Set as : "Total"
Local : Field : CFBK Rep Name : Widespaced: Yes
Local : Field : CFBK Rep Party : Set as : $$Total:CFBKRepParty
Local : Field : CFBK Rep ColTotal : Set as : $$Total:CFBKRepColTotal
Border : Thin Top

;; Collection Definition
[Collection: CFBK Voucher]
Type : Voucher
Filter : IsSalesVT
Childof : $$GroupSundryDebtors
Belongs To : yes
[Collection:stkitemcol]
Source Collection:CFBK Voucher
Type:stockitem
Fetcharent,name
Filter:testmyfilter
;select $parent,$name from stkitemcol
[System:Formulae]
testmyfilter:$parent="Primary"



[System:formula]
;itemfilter:$$IsGroup:$StockItemName:##stockGroupName
;itemfilter:If ##Iname="" Then 1-1 Else ##Iname=$Parent:StockItem:##IName
[Collection: CFBK Summ Voucher]
Source Collection : CFBK Voucher
Walk : Inventory Entries
By : PName : $PartyLedgerName
By : IName : $StockItemName
Aggr Compute : BilledQty : SUM : $BilledQty
Search Key : $IName + $PName
[Collection: Smp Stock Item]
Source Collection : CFBK Voucher
Walk : Inventory Entries
By : PName : $PartyLedgerName
Aggr Compute : BilledQty : SUM : $BilledQty
;Filter : NonEmptyQty
[Collection: CFBK Party]
Source Collection : CFBK Voucher
Walk : Inventory Entries
By : IName : $StockItemName
Aggr Compute : BilledQty : SUM : $BilledQty
;Filter : NonEmptyQty
[Variable: IName]
Type : String
Repeat : ##DSPRepeatCollection
[System: Formula]
IsSalesVT : $$IsSales:$VoucherTypeName
NonEmptyQty : NOT $$IsEmpty:$BilledQty
;; End-of-File
[Button:Stkgroupbtn]
Title:"Stock Group"
Key:Alt+g
Action:Execute:stock Rept
[Report:stock Rept]
[Form:stock Rept]
Part:Testpart
;Height : 10% Page
Width : 18% Page
Vertical Alignment:Top
Horizontal Align:Center
Full Width:No
No Confirm:Yes

[Part:testpart]
Line:testlineTL grp, StockGrpTrigger
Horizontal Align:Center

[Line: testlineTL grp]

Fields: Name field
Local : Field: Name field : Info: "Select Stock Group"
Local : Field: Name field : Align:Center
;Space Bottom : .20

[Line: StockGrpTrigger]

Fields: StockGrpTrigger
[Field: StockGrpTrigger]
Use:name field
Table:Stock Group
Width:20
Align:Center
Border:thin box
Set Always : Yes
Show Table : Always
Variable : Iname
Modifies : Iname : Yes

 

Dear Amit Sir, Thanks for your support and help. If group is not select then all item should be apear, if i select group then it should be filtered.
By the way a lot of Thanks.

 

Yes, Thanks a lot Amit ji

 

Amit sir If I had select the filter group sum total is mistake how resolved it?

 

I resolved All the things by applying logic of condition, Now i want to remove line

 

[Field: CFBK Rep Party]

Field:stkqty,STKITEMVALUE

dear sir, I had used two field in field [Field: CFBK Rep Party] on that case i had used
Remove If : if #stkqty="" or #STKITEMVALUE="" then $$IsEmpty:#CFBKRepParty else ""
but not removed column

 

[Line: CFBK Rep Details]
Fields : CFBK Rep Name, CFBK Rep Party, CFBK Rep Col Total
Repeat : CFBK Rep Party
Total : CFBK Rep Party
Remove If : not $$IsEmpty:#CFBKRepParty
i had done this one but not remove line. I don't know where is error

 

We Useful code Sir if You Add Opening Qty and also Closing Qty of that Item it will be much more useful

 

; What should do if we want to Ledger GroupWise Filter on this report , kindly suggest i had tried but not get solution.

 

Use invisible
[Field: CFBK Rep Party]

Invisible : @YourCondition