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
Hello, I want to filter item stock according to my stock group I had selected on Partywise Item sales Report. Plz help me...……………..
Share your code...so it could be examined............. if you cannot or don't want to share in open forum then share it of nehalsofttech@gmail.com Without looking at the code, it is not easy to give solutions.
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
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 Variable : IGroup 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 : If @@GrpCond then ##IName Else "" 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 : If @@GrpCond Then $$ReportObject:$$CollectionFieldByKey:$BilledQty:@MyFormula:CFBKSummVoucher Else "" 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 Fetch:parent,name Filter:testmyfilter ;select $parent,$name from stkitemcol [System:Formulae] testmyfilter:$parent="Primary" GrpCond : $Parent:StockItem:##IName = ##Igroup [System:formula] ;itemfilter:$$IsGroup:$StockItemName:##stockGroupName ;itemfilter: $Parent:StockItem:##IName ;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 ;Filter : itemfilter [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 Default : "" [Variable: IGroup] Type : String Default : "" [System: Formula] IsSalesVT : $$IsSales:$VoucherTypeName NonEmptyQty : NOT $$IsEmpty:$BilledQty ;; End-of-File [Button:Stkgroupbtn] Title:"Stock Group" Key:Alt+g Action:Execute:stock Rept ;Action : Modify Variable : Iname [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 : IGroup Modifies : IGroup : Yes
I have managed to Filter it.............. But you now need to find a way to hid/remove the empty columns. I do not have time now.....will check next week when free..............or maybe other experts might help.
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.
Well then...give conditional formula in your column title field.... If Igroup is empty then primary else igroup............... I think u can manage this formula on your own.............try it.
[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
"remove if" is not valid in field level U sud follow what code I have given...............also given you where to put it...........
[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
Did i mention..... CFBK Rep Details in my response??? Can't help you more, if you can't read and implement as it is given.
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.
There are lots of examples in the Forum to add a Filter. Add a Button ...to filter as per group .... and modify the "Particulars" field accordingly.