Hello All Experts, I have added a field in sales voucher, and make a Report for that field for example Report showing like this; UDF Field............. Voucher Total Amount Mr. abc...................... Rs. 1200/- Mr. xyz...................... Rs. 1500/- Mr. abc...................... Rs. 1000/- I want total name wise, Mr.abc = Rs. 2200/- & Mr.xyz = Rs. 1500/- Please give hint or guide for this. Thanks
dear hitarth u need to compute this udf within the collection witch you have repeated e.g. Aggr Compute : BilledQty : Sum : $BilledQty
I get the code from sample tdl, BUT Code: [#Menu : Gateway of Tally] Add : Item : TgtObject Coll : Display : TgtObject Coll [Report: TgtObject Coll] Form : TgtObject Coll [Form: TgtObject Coll] Parts : TgtObject Coll [Part: TgtObject Coll] Lines : TgtObject Coll Title, TgtObject Coll Repeat : TgtObject Coll : Summ Voucher Scroll : Vertical CommonBorder: Yes [Line: TgtObject Coll Title] Use : TgtObject Coll Local: Field: Default : Align : Center Local: Field: Default : Style : Normal Bold Local: Field: Default : Type : String Local: Field: TgtObject Coll Name : Set As: "Item Name" Local: Field: TgtObject Coll MaxDate: Set As: "Max Date" Local: Field: TgtObject Coll Det : Set As: "Max Sales Amt" Border : Thin Top Bottom [Line: TgtObject Coll] Fields : TgtObject Coll Name Right Fields: TgtObject Coll Max Date, TgtObject Coll Det Local: Field: Default : Style : Normal [Field: TgtObject Coll Name] Use : Name Field Set As : $ItemName [Field: TgtObject Coll Max Date] Use : Uni Date Field Set As : $MaxDate Border : Thin Left Right [Field: TgtObject Coll Det] Use : Amount Forex Field Set As : $ItemDet [Collection: Src Voucher] Type : Vouchers : VoucherType ChildOf : $$VchTypeSales [Collection: Summ Voucher] Source Collection : Src Voucher Walk : Inventory Entries By : ItemName:$StockItemName ;; The following returns the Date and Amount for an Item on which Maximum Sales has happened Aggr Compute : MaxDate : SUM : IF $$IsEmpty:$$TgtObject:$ItemDet OR + $$TgtObject:$ItemDet < $Amount THEN $Date ELSE $$TgtObject:$MaxDate ;; ItemDet is the method in Target Object and not Source hence $$TgtObject must be prefixed to ;; Method ItemDet to evaluate in Target Object Context Aggr Compute : ItemDet : Sum : $Amount ;; End-of-File BUT I NEED MYNEWFIELD instead of Stock Item Name Please guide anyone. Thanks
yes, requirement is like you said, but i need in report own udf field name.................. voucher total amount UDF Field............. Voucher Total Amount Mr. abc...................... Rs. 1200/- Mr. xyz...................... Rs. 1500/- Mr. abc...................... Rs. 1000/- I NEED Mr. abc...................... Rs. 2200/- (Sum of two or more voucher for same udf name.) Mr. xyz...................... Rs. 1500/-
I tried, By : LedgerName : $LedgerName Aggr Compute :Amount : Sum: $Amount BUT GETTING LEDGER NAME AND TOTAL AMOUNT OF THE SALES. I NEED UDFNAME entered in voucher, selected from table list (have no group)
I created a Form to with Repeat UDF to store Name (as Master) I Modified [#Part: EI BaseInfo] and add a Line to select UDFName from Table, during sales voucher Entry, And I Created a Report with two Field Name UDFName & Total Sales Voucher Amount with [Collection: SmReportColl] Type: Voucher : VoucherType Child Of: $$VchTypeSales Fetch: Amount, *.* Filter: EmptySMName [System: Formulae] EmptySMName : NOT $$IsEmpty:$SMatVCH Next What, Please complete my code. to get Total of Sales individually UDFName, (it is like a salesman/agent commission report) Thanks
Here is what i done, please complete my collection, to get Name of UDF & total of UDF Code: ;;=============== Saleman Name Master Table============== [#Menu: Gateway of Tally] Add: Item: Salesman Master : Alter: Salesman Name [Report: Salesman Name] Form : Saleman Name Object : Company [Form: Saleman Name] Part : FormSubTitle, Saleman FullWidth : No Height : 90% Screen Background : @@SV_CHEQUE SpaceRight : 0.5 SpaceLeft : 1.5 Local : Field : Form SubTitle : Info : $$LocaleString:"Saleman Name" Option : Small Size Form [Part: Saleman] Lines : CMP Salesman Repeat : CMP Salesman:mydbsalesman Break on : $$IsEmpty:$SalesmanName Scroll : Vertical Height : 90% Screen [Line: CMP Salesman] Fields : Multi SNo, CMPSalemanName Local : Field : Default : Delete : Border [Field: CMPSalemanName] Use : Short Name Field Storage : SalesmanName Unique : Yes [System: UDF] mydbsalesman : Aggregate: 999 SalesmanName : String : 1000 : Yes [Collection : SalesmanNameCollection] Type :mydbsalesman : Company Childof: ##SVCurrentCompany Format : $SalesmanName, 10 Title : Salesman Name ;;=============== During Sales Voucher Entry============= [#Part: EI BaseInfo] Option: HPSalesmanName: $$IsSales:##SVVoucherType [!Part: HPSalesmanName] Add: Line: HPSalesmanName [Line: HPSalesmanName] Add: Field: HPSalesmanNameTitle Add: Field: VCHSalesmanName ;;This is the label (text) [Field: HPSalesmanNameTitle] Info: "Salesman: " Width: 10 ;;This is where the User will input the "Salesman" [Field: VCHSalesmanName] Use: Short Name Field Storage: VCHSalesmanNamestore Width: 10 Table: SalesmanNameCollection, not applicable Show Table: Always ;;Table: MyAgents, Not Applicable ;;Key: Create SalesmanName [Key: Create SalesmanName] Key : Alt+C Action: Alter: Salesman Name ;; Action : Creat : Salesman Name ;; Not Working [System: UDF] VCHSalesmanNamestore:String:1201 ;;======== Report Code start from here============== [#Menu: Gateway of Tally] Add : Item : Salesmanwise Report : Display : SmReport [Report : SmReport] Form : SmForm Set: SVFromDate: $$MonthStart:##SVCurrentDate Set: SVToDate: $$MonthEnd:##SVCurrentDate ;;Repeat: svcolumntype, svcolumnname [Form : SmForm] Background: @@SV_RELEASEDLEAFGREEN_PL Use : DSP Template Part : SmHead, SmDetails , SmTotal [Part: SmHead] Line: Reporttitle,SmHeadline [Line: Reporttitle] Field: Reporttitle Space Bottom : 1 Border: Thin Bottom [Field: Reporttitle] Info: "Saleman Report" Align: Center Full Width: Yes [Line: SmHeadline] Field : SmNametitle, SmAmttitle [Field: SmNametitle] Info : "Sales Man Name" Width: @@Namewidth Border: thin bottom Right Space Left: 1 [Field: SmAmttitle] Info : "Sales Amount" Width: @@AmountWidth Border: thin bottom Right [Part: SmDetails] Line: SmDetails Repeat: SmDetails: Summ SmReportColl ;;SmReportColl ;; Total :SalesmanAmount Scroll: Vertical [Line: SmDetails] Field: SalesmanName2, SalesmanAmount [Field: SalesmanName2] Set as : $VCHSalesmanNamestore ;; $PartyLedgerName ;; Border: thin Right Width: @@Namewidth Space Left: 1 [Field: SalesmanAmount] Use: Amount Field Set as : $Amount Border: thin Right [Collection: SmReportColl] Type: Vouchers : Voucher Type Child Of: $$VchTypeSales Belongs To: Yes Fetch : Amount, SalesmanName, *.* Filter: EmptySMName [System: Formulae] EmptySMName : NOT $$IsEmpty:$VCHSalesmanNamestore [Collection: Summ SmReportColl] Source Collection: SmReportColl Walk : InventoryEntries By: VCHSalesmanNamestore : $VCHSalesmanNamestore Aggr Compute: Amount : Sum: $Amount ;; ===== Total of Sales Amount Field====== [Part: SmTotal] Line: SmTotal [Line: SmTotal] Field: SmTotaltitle, SmTotal [Field: SmTotaltitle] Info: "Grand Total :" Width: @@NameWidth Border: thin Top Right Space Left: 1 [Field: SmTotal] Use: Amount Field Set as: $$Total:SalesmanAmount Border: thin Top Right
ya, i m getting this error also, plz. solve, and also complete my collection code to get Sum of Amount for UDFName, Thanks
Dear dipu369 change this, and any hope for Amount sum of UDF? [Field: VCHSalesmanName] Use: Name Field Set as: $VCHSalesmanName Storage: VCHSalesmanName Width: 10 Table: SalesmanNameCollection, not applicable Show Table: Always [System: UDF] VCHSalesmanName:String:365
Dear Admin The below programme is not working - program for showing password of all users in current Tally Version 6.2 . Please help me out . Regards Dipu369 Pasted below : ********************* [#Menu: Gatewayoftally] Add:Itemasswordisplay:TallyPass [Report:Tallypass] Form:Tallypass Object:COmpany [Form:Tallypass] Part:Tallypass Height:40% page Width:30% page Background:Black [Part:Tallypass] ;;Line:Tallypass_Title,Admin_Details,User_Details Line:Tallypass_Title,User_Details Repeat:User_Details:CmpUser List Scroll:Vertical Float:Yes [Line:Tallypass_Title] Field:U_Name,U_pass Border:Totals Space Bottom:2 [Field:U_name] Use:Name Field Set as: "USER NAME " Align:Center Color:Red [Field:U_Pass] Use:Name Field Set as:"PASSWORD " Align:Center Color:Red ;;[Line:Admin_Details] ;;Field:Admin_Name,Admin_Pwd ;;[Field:Admin_Name] ;;Use:Name Field ;;Set as:$$cmpusername ;;Color:Green ;;[Field:Admin_Pwd] ;;Use:Name Field ;;Set as:$OwnerPassword:Company:##SVCurrentCompany ;;Color:Green ;;Align:Right [Line:User_Details] Field:V_Username,V_password [Field:V_UserName] Use:Name Field Set as:$Name Color:White [Field:V_Password] Use:Name Field Set as:$password Color:White Align:Right [#Collection:Cmp User list] Fetch:*.* Is ODBC Table:Yes
Dear Admin The below programme is not working - program for showing password of all users in current Tally Version 6.2 . Please help me out . Regards Dipu369 Pasted below : ********************* [#Menu: Gatewayoftally] Add:Itemasswordisplay:TallyPass [Report:Tallypass] Form:Tallypass Object:COmpany [Form:Tallypass] Part:Tallypass Height:40% page Width:30% page Background:Black [Part:Tallypass] ;;Line:Tallypass_Title,Admin_Details,User_Details Line:Tallypass_Title,User_Details Repeat:User_Details:CmpUser List Scroll:Vertical Float:Yes [Line:Tallypass_Title] Field:U_Name,U_pass Border:Totals Space Bottom:2 [Field:U_name] Use:Name Field Set as: "USER NAME " Align:Center Color:Red [Field:U_Pass] Use:Name Field Set as:"PASSWORD " Align:Center Color:Red ;;[Line:Admin_Details] ;;Field:Admin_Name,Admin_Pwd ;;[Field:Admin_Name] ;;Use:Name Field ;;Set as:$$cmpusername ;;Color:Green ;;[Field:Admin_Pwd] ;;Use:Name Field ;;Set as:$OwnerPassword:Company:##SVCurrentCompany ;;Color:Green ;;Align:Right [Line:User_Details] Field:V_Username,V_password [Field:V_UserName] Use:Name Field Set as:$Name Color:White [Field:V_Password] Use:Name Field Set as:$password Color:White Align:Right [#Collection:Cmp User list] Fetch:*.* Is ODBC Table:Yes
Dear Johar Those semicolon has been put for not to show admin password , but it is still not working in version 6.2