Total like ClosingBalance

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

 

Here BilledQty means storage Name ?
And $BilledQty means Field Name ?
Please explain, thanks

 

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

 

???? anyone plz.

 

Will you clearly explain your requirement. Do you need Salesmanwise / Brokerwise like thing ?

 

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

 

Add following thing in your collection.
By : LedgerName : $LedgerName
Aggr Compute :Amount : $Amount

 

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)

 

please explain,, still i am not getting result

 

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

 

Dear Admin & Experts
Request to Solve & complete next collection code
Thanks

 

please Share code...

 

Dear Laxman,
Code is shared here (at Top), i want UDFName in place of ItemName
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 Admin, Experts or Members,
Any idea?

 

VCHSALESMAN Error Is Correct But Reporting Not Show .....

 

salesman name is not saving at the time of invoicing . pl. correct it.

 

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

 

Dipu369

Above program is working fine remove all semi-colon

Johar

 

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