Agent wise Sales and Outstanding Required

Can Any one give the code for Agent wise

Check the requirement in attached file

 

That Attachment Shows Already TDL Done.
Then Why you are asking, is that TDL not working or.......???

 

TDL not available, this manual igot from Google browsing, some one is posted

 

This is the customised tdl on the tally shop. Tried for the coding but unsuccessful attempt. Therefore purchsed directly from the developer for lifetime at ₹2000/- if interested ping back on shubhamsancheti1993@yahoo.com

 

Source Code or TCP File...????

 

TCP file it is..will be compiled on the serial number you provide

 

Shubham Can you send me demo limt version for this tcp for check at rajsrisrimal@gmail.com

 

please check your mail.

 

please send me this tdl on jeetendrachopra@gmail.com

 

agent commission module send me the source code kindly help me??
sathiyaraj@winways.co.in

 

plz send me tdl
amitprj796@gmail.com

 

Code:

[#Menu        : Accounts Info.]

Add : Item : Sales man : Menu : Salesman Menu

[Menu: Salesman Menu]
Add : Item : Salesman Master : Alter : Salesman Name

[Report: Salesman Name]
Form : Salesman Name
Object : Company

[Form: Salesman Name]
Part : FormSubTitle, Salesman
;Button : Delete All, Remove Line, Restore Line, Restore All,Report Operations
FullWidth : No
Height : 90% Screen
Background : @@SV_CHEQUE
SpaceRight : 0.5
SpaceLeft : 1.5
Local : Field : Form SubTitle : Info : $$LocaleString:"Salesman Name"
Option : Small Size Form


[Part: Salesman]
Lines : CMP Salesman
Repeat : CMP Salesman:mydbSalesman
Break on: $$IsEmpty:$SalesmanName
Scroll : Vertical
Height : 90% Screen

[Line: CMP Salesman]
Fields : Multi SNo, CMPSalesman Name
Local : Field : Default : Delete : Border

[Field: CMPSalesman Name]
Use : Short Name Field
Storage : Salesman Name
Unique : Yes


[System: UDF]
mydbSalesman : Aggregate: 979
Salesman Name : String : 1003 ;: Yes

[Collection : Salesman NameCollection]
Type : mydbSalesman : Company
Childof : ##SVCurrentCompany
Format : $SalesmanName, 15
Title : Salesman_name
   

;------------------------------- during Purchase voucher
   

[#Part:DBLLINE Narration]
    Option: EI Freightman: $$IsSales:##SVVoucherType

[!Part: EI Freightman]
   Add    : Line: Freightman
  

[Line: Freightman]
    Add: Field: lblTruckno, CommBro, lblStation, fldStation
Border: Thin Box


[System    : UDF]
    CWTRUCKNO   :String    : 58504
    CWSTATION   :String    : 58506
      
      
   
[Field: lblTruckno]
    Info: "Sales Man :"
    color : WHITE
    Width: 9
    Style: normal bold
    Background:BLUE

[Field: CommBro]
    Use : Name Field
    Width: 12
    Set as    : $CWTRUCKNO
    Storage: CWTRUCKNO
    Table : Salesman NameCollection, not applicable
    Show Table: Always
    Color: blue



[Field: lblStation]
    Info: "Remarks :"
    Width: 10
    color : white
Style: normal bold
Background:DARK RED

[Field: fldStation]
       
    Use : Name Field
    Width: 25
        Set as    : $CWSTATION
    Storage: CWSTATION
        Color: DARK RED
;-----------------------

[#Line: DBTitle1]   
Add : Right Field    : At Beginning : BILLCol25
Local : Field    : BILLCol25 : Set as    : "Salesman"
Local : Field : Default : Style : Normal Bold
Local:Field:BILLCol25:Align:Centre

[#Line: DSP VchDetail]   
Add    : Right Field: At Beginning: BILLCol25
   
[Field    : BILLCol25]
   
    Use    : Name Field
    Set as    : $CWTRUCKNO
    Set Always    : Yes   
    Align    : Left
    Width    : 9
    Style    : Small Bold

[#Collection: MethodTable]   
Add:Object : TrackMethodFirm
   
[#Line: DSP VchDybkDetail]
Add: Right Fields: Before: Refnobb :Refnobx


[Field:Refnobx]
                Use :Name Field
                Set As : $CWTRUCKNO
                Width : 9
                Align:right
                color : geranium
                Style : Normal bold
                Border: Thin Left

[#Collection: Daybook Vouchers of Company]
                Fetch: CWTRUCKNO              

[#Collection: Filtered Vouchers of Company]
                Fetch: CWTRUCKNO

[Object: TrackMethodFirm]
   
    User Method Name : $$LocaleString:"Salesman Name"
    Method Name    : "CWTRUCKNO"
    Collection Source     : ""
    Method Type    : "String"
    Secondary Object    : ""

 

***** CAN POSSIBLE TO ADD SALESMAN NAME IN LEDGER / GROUP OUTSTANDING ALSO......

 

yes...you can

 

Jenny Can You Provide The Code How To Add Salesman in Outstanding Report.

Please Help.

 

Kindly advice how to add salesman in outstanding report...

 

use this code
;===============================================================
;======================= F11 Feature ===========================
;===============================================================
[#Part: CMP TallyShopFeatures Left]
Add : Line : At End : CMP EnableSalesmanTable
[Line: CMP EnableSalesmanTable]
Field: Medium Prompt, CMP EnableSalesmanTable
Local: Field: Medium Prompt: Info: "Enable Salesman ? "
Local: Field: Long Prompt: Info: "Enable Broker wise Report.?:"
;;Invisible: NOT $$MODAdvInventory or NOT $IsInvoicingOn
Space Top: 1
[Field: CMP EnableSalesmanTable]
Use: Logical Field
Storage: EnableSalesman
Set as: If $$IsEmpty:$$Value then "No" else $$Value
Sub Form: SmReport: $$Value = "Yes"
[#Menu: Gateway Of Tally]
Add : Item : Salesman : Menu : SalesmanMenu
[Menu: SalesmanMenu]
Add : Item : Salesman Master : Alter : Salesman Name
Add : Item : Blank
Add : Item : Salesman Sales Report : Display : SmReport
Add : Item : Blank
[Report: Salesman Name]
Form : Salesman Name
Object : Company
[Form: Salesman Name]
Part : FormSubTitle, Saleman
;Button : Delete All, Remove Line, Restore Line, Restore All,Report Operations
FullWidth : No
Height : 90% Screen
Background : @@SV_CHEQUE
SpaceRight : 0.5
SpaceLeft : 1.5
Local : Field : Form SubTitle : Info : $$LocaleString:"Salesman 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 OR $$IsDelNote:##SVVoucherType
[!Part: HPSalesmanName]
Add: Line: HPSalesmanName
[Line: HPSalesmanName]
Add: Field: HPSalesmanNameTitle
Add: Field: VCHSalesmanName
[Field: HPSalesmanNameTitle]
Info : "Salesman: "
Width: 10
;;This is where the User will input the "Salesman"
[Field: VCHSalesmanName]
Use : Name Field
Storage : VCHSalesmanName
Set as : $VCHSalesmanName
Width : 25
Table : SalesmanNameCollection, not applicable
Show Table: Always
Key : Create SalesmanName
[Key: Create SalesmanName]
Key :Alt + C
Action: CREATE: SalesmanName
[System: UDF]
VCHSalesmanName:String:375
;;================= Report Code start from here=====================
;====================================================Salesman sales Report==================================================
TDLLic : $$CmpUserName:CompanyUsersCollection <> ÒadminÓ
;; Limiting based on Company Users
[Report: SmReport]
Use : DSP Template
Form : PQRReport
Title : "Salesman Report"
Set : SVFromDate : $$MonthStart:##SVCurrentDate
Set : SVToDate : $$MonthEnd:##SVCurrentDate
Set : SalesManChqVar : "Full"
Set : SalesManName : ""
[Form: PQRReport]
Use : DSP Template
Parts : PQRReport
Height : 100% screen
Width : 100% screen
Delete : Buttons: ExplodeFlag
Background: @@SV_RELEASEDLEAFGREEN_PL; Very Light Green
;Delete : Bottom Buttons: DSPAutoColumns, RelReports,BudgetAnalysis, ReportConfig
Bottom Toolbar Buttons : BottomToolBarBtn1, BottomToolBarBtn6, BottomToolBarBtn7, BottomToolBarBtn8, BottomToolBarBtn9, BottomToolBarBtn10, BottomToolBarBtn11, BottomToolBarBtn12,
Add: Button: Salesmanfilter
[Part: PQRReport]
LinesQRTitile,PQRBody
BottomLines : PQRBody Total
Repeat : PQRBodyQRSalesManVouchersColl
CommonBorder: Yes
Scroll : Vertical
TotalQRPartyAmount,PQRVCHGP
[Line: PQRTitile]
UseQRBody
Local : Field : Default : Type : String
Local : Field : Default : Style : Tiny Bold
Local : Field : Default : Align : Centre
Local : Field : Default : set as : $$LocaleString:"S. No"
Local : Field : PQRPartyDate : Set as: $$LocaleString:"Date"
Local : Field : PQRPartyVchNo : Set as: $$LocaleString:"Vch No."
Local : Field : PQRPartyName : Set as: $$LocaleString:"Party Name"
Local : Field : PQRPartySalesMan: Set as: $$LocaleString:"SalesMan"
Local : Field : PQRVCHGP: Set as: $$LocaleString:"GrossProfit"
Local : Field : PQRVCHGPPER: Set as: $$LocaleString:"Profit%"
Local : Field : PQRPartyVchType : Set as: $$LocaleString:"Vch Type"
Local : Field : PQRPartyAmount : Set as: $$LocaleString:"Amount"
Border : Flush Totals
[Line: PQRBody]
FieldQRSno, PQRPartyDate,PQRPartyVchNo,PQRPartyName,PQRPartySalesMan,PQRVCHGP,PQRVCHGPPER,PQRPartyVchType
RightFieldQRPartyAmount
Border :Thin Bottom
[FieldQRSno]
Set as : $$Line
Width : 1.5 cm
Align : Center
Border : Thin Left Right
[Field: PQRPartyDate]
Set as : $Date
Width : 9% Screen
Align : Right
;Style : Tiny
Border : Thin Left
[Field: PQRPartyVchNo]
Set as : $VoucherNumber
Width : 9% Screen
Align : Center
;Style : Tiny
Border : Thin Left
[Field: PQRPartyName]
Use : Name Field
Set as : $PartyLedgerName
Border : Thin Left
Width : 38% Screen
Align : Left
;Style : Tiny
Variable: LedgerName
Display : Ledger Vouchers
[Field: PQRPartySalesMan]
Use :Name Field
Set as :$VCHSalesmanName
Border : Thin Left
Width : 12% Screen
Align : Left
;Style : Tiny
Key : Create SalesmanName
[Field: PQRVCHGP]
Use :Amount Forex Field
Set as :$GrossProfit
Border : Thin Left
Width : 10% Screen
Align : Left
;Style : Tiny
Key : Create SalesmanName
[FieldQRVCHGPPER]
use : amount field
width: 10% Screen
Border:thin left
align: right
set as: $GROSSPROFIT/$GROSSREVENUE*100
[Field: PQRPartyVchType]
Set as : $VoucherTypeName
Border : Thin Left
;Width : 15% Screen
Align : Left
;Style : Tiny
[Field: PQRPartyAmount]
Use : Amount Forex Field
Set as : $GROSSREVENUE
Border : Thin Left
;Width : 15% Screen
Align : Right
;Style : Tiny
Format : "No Zero,DrCr,Symbol," + ##ShowForex
[Line: PQRBody Total]
UseQRBody
Local : Field : Default : Type : String
Local : Field : Default : Style : Tiny Bold
Local : Field : Default : Align : Centre
Local : Field : PQRSno : Set as: ""
Local : Field : PQRPartyDate : Set as: ""
Local : Field : PQRPartyVchNo : Set as: ""
Local : Field : PQRPartyName : Set as: "TOTAL"
Local : Field : PQRPartyName : Align : Centre
Local : Field : PQRPartySalesMan: Set as: ""
local : field : PQRVCHGP :set as: $$Totalqrvchgp
local : field : PQRVCHGPPER :set as: $$Totalqrvchgp/$$TotalQRPartyAmount*100
Local : Field : PQRPartyVchType : Set as: ""
Local : Field : PQRPartyAmount : Set as: $$TotalQRPartyAmount
Border : Flush Totals
;============================== Filter ===================================
[Button:SalesmanFilter]
Key : Alt+S
Action : Execute : SalesmanFilter
Title : Salesman Name
[Report:SalesmanFilter]
Form : SalesmanFilter
;Set : SalesmanName : ""
Set : SalesManChqVar : "Filter"
[Form:SalesmanFilter]
Part : SalesmanFilter
No Confirmation : Yes
[Part:SalesmanFilter]
Line : SalesmanFilter
[Line:SalesmanFilter]
Field : Medium Prompt,SalesmanFilter
Local : Field : Medium Prompt : Set as : "Select Salesman Name: "
[Field:SalesmanFilter]
Table : SalesmanNameCollection,EndOfList
ShowTable : Always
Use : Name Field
Width : 20
Border : Thin Box
Variable : SalesmanName
Modifies : SalesmanName
;================================================================================================
;===================================== Collections =================================================
[Collection: PQRSalesManVouchersColl]
Type : Voucher
Fetch : Date, VoucherNumber, VoucherTypeName,LedgerName,PartyLedgerName,VCHSalesmanName,GrossProfit,GROSSREVENUE, LedgerEntries.*
Filter : PQRSaleManVouchers
Filter : SalesManFilter
[System:UDF]
EnableSalesman : Logical : 1000
Commission : Number : 1001
[Variable:SalesManName]
Type : String
[Variable:SalesManChqVar]
Type : String
[System:Variable]
SalesManName : ""
SalesManChqVar : ""
[System: Formula]
;PQRSaleManVouchers: $$IsSales:$VoucherTypeName OR $$IsDelNote:$VoucherTypeName
PQRSaleManVouchers: $$IsSales:$VoucherTypeName
SalesManWise : $VCHSalesmanName=@@SAlesManEOL
SalesManFull : $VCHSalesmanName=$VCHSalesmanName
SAlesManEOL : if $$IsEndOfList:##SalesManName then $VCHSalesmanName Else ##SalesManName
SalesManFilter : if ##SalesManChqVar="Filter" Then @@SalesManWise Else @@SalesManFull

 

In this code can calculate sales man commission? Please need this

 

no effect coming in sales voucher agent name input is not there in sales bill any where only can create master

 

what would be the correct code for adding multiple line description for item master in Prime
[#Part: CMP InvFeat Left]

Add : Lines : After : CMP ActualQty : TSPL FFE Enable MultiLineItemDesc

please help me