That Attachment Shows Already TDL Done. Then Why you are asking, is that TDL not working or.......???
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
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 : ""
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
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