[#Line: DSP VchAccTitles] Add :Field: At Beginning: DNSSNoT Add : Fields : AFter : DSP VchAcctTitle : TEPLChequeNoTitle [#Line: DB Title1] Add :Field: At Beginning: DNSSNoT Add : Fields : AFter : Dsp VchAcctTitle : TEPLChequeNoTitle Add : Left Field : After : DSP VchAcctTitle : DBRouteN Add : Field : After : DSP VchAcctTitle : DBSalesmanN [FieldNSSNoT] Set As : "S.No" Width : 5 Align : Center Style : Normal Bold Border : Thin Bottom Color : Red [Field : TEPLChequeNoTitle] Set as : "Instrument No" Skip : Yes Width : 15 Align : Center Style : Normal Bold Color : Red Line : 0 Border : Thin Bottom [FieldBRouteN] Set as : "Route" Width : 15 Align : center Style : Normal Bold Color : Red Border : Thin bottom Line : 0 [FieldBSalesmanN] Set as : "Salesman" Width : 15 Align : center Style : Normal Bold Color : Red Border : Thin bottom Line : 0 [#Line: DSP VchDetail] Add :Field: At Beginning: DNSSNo Add : Right Fields : Before : DSP Vchtype : TEPLChequeNoFld [#Line: DSP VchDyBkDetail] Add:Field:At BeginningNSSNo Add : Field : After : DSP VchAccount : DBRoute Add : Field : After : DSP VchAccount : DBSalesman [Field: DNSSNo] Use : Simple Field Set as : $$ZeroFill:$$Line:2+"." Width : 5 Align : Center Color : Red Style : Normal Bold [Field : TEPLChequeNoFld] Use : Short Name Field Set as : $AllLedgerEntries[2].BankAllocations.InstrumentNumber Skip : Yes Align : Centre Width : 15 Style : Normal Bold Color : Red [FieldBRoute] Use : Name Field Set As : $Reference Width : 15 Align : Centre Color : Black Style : Normal [FieldBSalesman] Use : Name Field Set As : $EISMan Width : 15 Align : Centre Color : Black Style : Normal [#Collection: Vouchers of Ledger] Fetch : AllLedgerEntries.BankAllocations.INSTRUMENTNUMBER, Fetch : Reference [#Collection: Daybook Vouchers of Company] Compute : VCHSalesmanName :$EISMan Fetch : Reference,AllLedgerEntries.VCHSalesmanName,AllLedgerEntries.BankAllocations.INSTRUMENTNUMBER [#Collection : Specific Vouchers of Company] Fetch : AllledgerEntries.BankAllocations.INSTRUMENTNUMBER,VCHSalesmanName Fetch : Reference [#Collection: Vouchers of Group] Fetch : AllLedgerEntries.BankAllocations.INSTRUMENTNUMBER,VCHSalesmanName Fetch : Reference [#Collection : Vouchers of Company] Fetch : AllLedgerEntries.BankAllocations.INSTRUMENTNUMBER,VCHSalesmanName Fetch : Reference
[#Collection: Daybook Vouchers of Company] Fetch : Reference,EISMan,AllLedgerEntries.BankAllocations.INSTRUMENTNUMBER
[#Menu : Gateway of Tally] Add : Item : After : ~Quit : Sales Men Module : Menu : Customised Report [Menu : Customised Report ] Add : Item : Grouped SalesmenWise Outstanding : Display : Grouped Sales ManWise Report Add : Item : Party Sales - Salesmen wise : Display : SM PartyWise Add : Item : Grouped Salesmen Report : Display : Grouped Sales Man Report [ System : Formula ] Ashu : $IsSalesmanactive:Company:##SvCurrentCompany [#Menu: Accounts Info.] ;Add: Key Item :Before : Quit : @@SMan : M : Menu : Sales Man NOT $$IsEmpty:$$SelectedCmps) And ( @@Ashu = Yes) [Collection : SM Collection] Type : MyDBSalesman : Company Childof : ##SVCurrentCompany Format : $SalesmanName,25 Title : "List of Executives" Variable : SMSalesMan Trigger : SM Trigger Report : SM PartyWise [Variable : SMSalesMan] Type : String [System : Variable] SMSalesMan : "" [Report : SM Trigger] Use : Collection Variable Variable : SM SalesMan Local : Line : Collection Variable : Field : SM Field Local : Field : MV Title : Info : $$LocaleString:"List of Executives" [Field: SM Field] Use : Name Field Table : SM Collection Show Table : Always Modifies : SMSalesMAn Variable : SM SalesMan [Report :SM PartyWise] Use : DSP Template Form : SM PartyWise Variable : SM SalesMan, LedgerName Set : SMSalesMan : $$CollectionField:$SalesmanName:1:SMCOllection [Form : SM PartyWise] Use : DSP Template Delete : PageBreak Part : DSP Company Name, SM PartyWise Titles, SM PartyWiseBody Button : Change SalesMan Add : PageBreak : SM ClPgBreak, SM OpPgBreak [Part : SM OpPgBreak] Part : DSP Company Name, SM PartyWise Titles Vertical : Yes [Part : SM ClPgBreak] Line : SM ClPgBreak [Line : SM ClPgBreak] Right Field : SM ClPgBreak [Fiel d: SM ClPgBreak] Use : Short Name Field Set as : "Continued...." Align : Right Style : Small Italc [Part : SM PartyWiseBody] Part : SM PartyWise, SM PartyWiseBottom Vertical : Yes Scroll : Vertical Common Border : Yes Total : SM FreeQTy, SM BilledQTy, SM GrossValue [Part : SM PartyWise Titles] Line : SM SalesmanTitle, SM PartyWise Titles [Line : SM SalesmanTitle] Field : Short Prompt, SM SalesmanTitle Right Field : SM PEriod Local : Field : Short Prompt : Set as : "Salesman : " Local : Field : Short Prompt : Style : Small [Fiel d: SM PEriod] Use : Name Field Align : Right Set as : @@DSPDateStr Style : SMall Italic [Field : SM SalesmanTitle] Use : Name Field Set as : ##SMSalesMan Style : Small Bold [Line : SM PartyWise Titles] Use : SM PartyWise Delete : Explode Delete : Empty Delete : Option Local : Fiel d: Default : Type : String Local : Fiel d: Default : Style : Small Bold Local : Fiel d: Default : ALign : Centre Local : Field : SM PartyCode : Set as : "Party Alias" Local : Field : SM PartyName : Set as : "Party Name" Local : Field : SM ItemName : Set as : "Product Name" Local : Field : SM FreeQTy : Set as : "Free Qty" Local : Field : SM BilledQTy : Set as : "BilledQty" Local : Field : SM GrossValue : Set as : "Gross Sales Value" Border : Column Titles [Part : SM PartyWise] LIne : SM PartyWise Repeat : SM PartyWise : SM Parties Scroll : Vertical [Line : SM PartyWise] Field : SM PartyCode, SM PartyName Right Field : SM ItemName, SM FreeQTy, SM BilledQTy, SM GrossValue Explode : SM ItemWise Empty : $$NumItems:SMPartyVouchers2 = 0 [Field : SM PartyCode] Use : Short Name Field Set as : $$CollectionField:$Name:2:name Style : Small [Field : SM PartyName] Use : Name Field Set as : $$Name Style : Small FullWidth : Yes Border : Thin Left Option : SM IsLedger : $$IsLedger [!Field : SM IsLedger] Variable : LedgerName ;;Display : Ledger Vouchers [Field : SM ItemName] Use : Name Field Set as : " " Style : Small Bold Border : Thin Left Width : 15 [Field : SM FreeQTy] Use : Qty Primary Field Set as : $$CollQtyTotal:SMPartyVouchers2:$SMItemFreeQty2 Style : Small Bold Border : Thin Left Format : "NoZero" [Field : SM BilledQTy] Use : Qty Primary Field Set as : $$CollQtyTotal:SMPartyVouchers2:$SMItemBilledQty2 Style : Small Bold Border : Thin Left Format : "NoZero" [Field : SM GrossValue] Use : Amount Forex Field Set as : $$CollAmtTotal:SMPartyVouchers2:$SMItemAmount2 Style : Small Bold Border : Thin Left Width : 18 Align : Right Format : "NoZero" [Fiel d: SM CurSymbol] Use : Short Name Field [Collection : SM Parties] TYpe : Ledger Childof : $$GroupSundryDebtors BelongsTo : Yes Format : $Name, 25 [Button : Change SalesMan] Key : F4 Title : "Salesman" Action : Modify Variables : SM Trigger [Part : SM ItemWise] LIne : SM ItemWise Repeat : SM ItemWise : SMPartyVouchers [Line : SM ItemWise] Use : SM PartyWise Delete : Explode Local : Field : SM PartyCode : Set as : "" Local : Field : SM PartyName : Set as : "" Local : Field : SM ItemName : Set as : $VoucherNumber Local : Field : SM FreeQTy : Set as : $Date Local : Field : SM BilledQTy : Set as : $$CollQtyTotal:Inventoryentries:$BilledQty Local : Field : SM GrossValue : Set as : $Amount ;;$$ColLAmtTotal:Inventoryentries:$Amount Delete : Empty Local : Field : SM FreeQTy : Style : Small Local : Field : SM BilledQTy : Style : Small Local : Field : SM GrossValue : Style : Small Local : Field : SM ItemName : Style : Small [Collection : SMPartyVouchers] TYpe : Vouchers : Ledger Childof : #LedgerName Filter : HasSameSalesMan, IsSMSalesVoucher [Collection : SMPartyVouchers2] TYpe : Vouchers : Ledger Childof : $$ReqObject:$Name Filter : HasSameSalesMan, IsSMSalesVoucher [#Object : Voucher] SMItemFreeQty : $$FilterQtyTotal:InventoryENtries:IsSMSalesItem:$FreeQty SMItemBilledQty : $$FilterQtyTotal:InventoryENtries:IsSMSalesItem:$BilledQTy SMItemAmount : $$FilterAmtTotal:InventoryENtries:IsSMSalesItem:$Amount SMItemFreeQty2 : $$CollQtyTotal:InventoryENtries:$FreeQty SMItemBilledQty2 : $$CollQtyTotal:InventoryENtries:$BilledQTy SMItemAmount2 : $Amount ;; $$CollAmtTotal:InventoryENtries:$Amount [#Object : Inventory Entry] FreeQty : $ActualQty - $BilledQty ;; FreeQty2 : If $$isEmpty:$FreeQty then 0 else $FreeQTy [System : Formula] IsSMSalesItem : $StockItemName = $$IsOwner:$$ReqObject:$Name HasSameSalesMan : $EISalesmanName = ##SMSalesMan HasSameSalesMan1 : $EISalesmanName = #SMSalesMan IsSMSalesVoucher : $$IsSales:$VoucherTypeName [Part : SM PartyWiseBottom] Line : SM PartyWiseBottom [Line : SM PartyWiseBottom] ;;SM FreeQTy, SM BilledQTy, SM GrossValue Use : SM PartyWise Delete : Explode Delete : Empty Local : Field : SM PartyCode : Set as : "" Local : Field : SM PartyName : Set as : "Gross Total :" Local : Field : SM PartyName : Style : Small Bold Local : Field : SM ItemName : Set as : "" Local : Field : SM FreeQTy : Set as : $$Total:SmFreeQty Local : Field : SM BilledQTy : Set as : $$Total:SmBilledQty Local : Field : SM GrossValue : Set as : $$Total:SmGrossValue Border : Thin Top Bottom ;; eof [System : UDF] MyDBSalesman: Aggregate: 2 SalesmanName: String: 1000 : Yes Commission : Number: 1001 : Yes [#Menu : Accounts Info.] Add : Key Item :Before : Quit : SMan : M : Menu : Sales Man : NOT $$IsEmpty:$$SelectedCmps [Menu : Sales Man] Title : $$LocaleString:"Executive" KeyItem : @@locCreate : C : Alter : CMP SalesmanReport ;;Allowed AND $$Allow:Create:AccountsMasters [Report : CMP SalesmanReport] Form : CMP SalesmanForm Object : Company [Form : CMP SalesmanForm] Part : CMP Salesman PartTitle, CMP Salesman PartDetails Background : White, Petal Pink [Part : CMP Salesman PartTitle] Line : CMP Salesman LineTitle [Line : CMP Salesman LineTitle] Field : Name Field Local : Field: Name Field: Style: Small Bold Local : Field: Name Field: Info: "Executive" Local : Field: Name Field: Align : Centre Local : Field: Name Field: Border : Thin Bottom [Part : CMP Salesman PartDetails] Line : CMP Salesman LineDetails Repeat : CMP Salesman LineDetails: MyDBSalesman BreakOn : $$IsEmpty:$SalesmanName Height: 6 Scroll: Vertical CommonBorder: Yes [Line: CMP Salesman LineDetails] Field:CMP Sales Man Sr No, CMP Salesman NameField,CMP Salesman CommissionField [ Field :CMP Sales Man Sr No] Use : Short Name Field Width : 2 Set as : $$Line Skip : Yes Align : Centre [Field: CMP Salesman NameField] Use: Short Name Field Storage: SalesmanName Border: Thin Left [Field: CMP Salesman CommissionField] Use: Number Field Storage: Commission Border: Thin Left [Collection: MySalesmanCollection] Type: MyDBSalesman: Company Childof: ##SVCurrentCompany Format: $SalesmanName,10 Format :$Commission,12 Title: EXECUTIVE NAME [ System : Formula ] Ash2 : $SalesmanName= ##IsLedgerWise [#Part: EI BaseInfo] Option: EI Salesman: $$IsSales:##SVVoucherType Or $$IsSalesOrder:##SVVoucherType [!Part: EI Salesman] Add: Line: EI lnSalesman [Line: EI lnSalesman] Fields: Short Prompt, fldSalesman Local: Field: Short Prompt: Info: "Executive" [Field: fldSalesman] Use: Short Name Field Set as : $CMPSalesMan:Ledger:$LedgerNAme Storage: EI SalesmanName Width: 20 Table: MySalesmanCollection ;;MySalesMan ShowTable: Always ;;InvoiceOrderList [ Collection : MySalesMan ] Type: CMPSalesMan: Ledger Format : $CMPSalesMan Childof : $PartyLedgerName [Object: Invoice SalesManList] [System: UDF] EI SalesmanName: String: 1000 ;;==============================================================================================;; ;;===============Add Sales man in Ledger========================================================;; ;;==============================================================================================;; [ #Part : MST LED Details ] Add : Line : CMP EnableCST [ Line : CMP EnableCSt ] Field : Medium Prompt, CMP EnableCST Local : Field : Medium Prompt : Set as : "Detail's of Executive" Local : Field : Medium Prompt : Width : 22 Space Top : 1 Local : Field : Default : Inactive: NOT ($$IsBelongsTo:$$GroupSundryDebtors) [ Field : CMP EnableCST ] Use : Short Name Field Table : MySalesmanCollection, Not Applicable Show Table : Always Storage : CMPSalesMan FullWidth : Yes Style : Normal Inactive : NOT ($$IsBelongsTo:$$GroupSundryDebtors) [ System : UDF ] CMPSalesMan : String : 21 [ Report : Grouped Sales Man Report ] Use : DspTemplate Form : Grouped Sales Man Report Add : Variable : SMSalesMan [ Form : Grouped Sales Man Report ] Use : Dsp Template Height : 100 % Page Width : 100 % Page Part : SM PartyWise Titles , Grouped Sales Man Report [ Part : Grouped Sales Man Report ] Line : Grouped Sales Man Report Repeat : Grouped Sales Man Report : SM Collection CommonBorder : Yes Scroll : Vertical Local : Collection : SMPartyVouchers2 : Delete : Filter Local : Collection : SMPartyVouchers2 : Add : Filter : HasSameSalesMan1, IsSMSalesVoucher Local : Collection : SMPartyVouchers : Delete : Filter Local : Collection : SMPartyVouchers : Add : Filter : HasSameSalesMan1, IsSMSalesVoucher [ Line : Grouped Sales Man Report ] Field : Name Field Local : Field : Name Field :Add : Variable: SMSalesMan Local : Field : Name Field : Set as :"(" + $SalesmanName + ")" Local : Field : Name Field : Style : Small Bold Italic Local : Field : Name Field :Add : Variable: SMSalesMan Add : Explode: SM PartyWiseBody ;;;;;;;;;;;;;;Saled Man Ageging;;;;;;;;;;;;;;;;;;;; [ Report : Grouped Sales ManWise Report ] Family : $$Translate:"Outstandings" Title : $$LocaleString:"Ledger Outstandings" List Name : $$LocaleString:"Bill-wise Details" Variables : SV CurrentCompany, SVFromDate, SVToDate, SVSortMethod, LedgerName, SVBudget, SVVariance Variables : ExplodeFlag, IsForexReport Variable : DSPShowMonthly, DSPHasMultiLevel Variable : ShowDaysByBillDate, ShowContactDetails Variable : ShowBillRange, IsBillWiseReport, IsLedgerReport, IsCCReport, IsVchTypeReport, IsGrpReport Variable : DSPNotScaleable, DSPHasColumnTotal, DSPAgeByDueDate Variable : AgeFrom, AgeTo, ShowReminders, ShowForex Variable : IsMultiPage, InNewPages, ShowBillType, IsGrpBillReport Repeat : AgeFrom, AgeTo Form : Grouped Sales ManWise Report Add : Variable : SMSalesMan Local : Variable : LedgerName : Table : Ledger Outstandings Set : SV Sort Method : @@Default Set : DSPShowMonthly : No Set : ShowDaysByBillDate: No Set : IsBillWiseReport : Yes Set : IsLedgerReport : Yes Set : IsGrpBillReport : No Set : DSPHasMultiLevel : No Set : DSPNotScaleable : Yes Set : DSPHasColumnTotal : No Set : IsMultiPage : No Set : ShowContactDetails : No Filtered : Yes Set : ReportTitle : $$LocaleString:"Ledger Outstandings" Print Set : ReportTitle : #LedgerName Print Set : ReportSubTitle : $$LocaleString:"Bill-wise Details" Print : LEDBILL Print Configure Export : Yes PrintSet : PrintFileName : "LedBills" Variable : ShowInterest, InterestRecv, InterestPaya Set : ShowInterest : No Set : InterestRecv : No Set : InterestPaya : No [ Form : Grouped Sales ManWise Report ] Button : ExplodeFlag, F2ChangePeriod, ChangeCompany, ChangeItem, AgeWiseAnalysis, Contact Details BottomButton: Blank Button, RelReports, InvReports, AcctReports, ReportOperations, Report Config, FilterButton, ValueButton Button : PrintButton, ExportButton, MailButton, UploadButton Height : 100 % Page Width : 100 % Page Part : SalesManLed BillTitle Part, Grouped Sales ManWise Report [ Part : Grouped Sales ManWise Report ] Line : Grouped Sales ManWise Report Repeat : Grouped Sales ManWise Report : SM Collection CommonBorder : Yes Scroll : Vertical [ Line : Grouped Sales ManWise Report ] Field : Name Field , ClBalance1 Repeat : ClBalance1 Local : Field : Name Field :Add : Variable: SMSalesMan Local : Field : Name Field : Set as :"(" + $SalesmanName + ")" Local : Field : Name Field : Style : Small Bold Italic Local : Field : Name Field :Add : Variable: SMSalesMan Add : Explode: SalesManLed Bill Empty : $$NumItems:SalesManLedgerBills = 0 [ Field : ClBalance1 ] Use : Amount Field Set as : $$Total:ClBalance [ Part : SalesManLed Bill ] Line : SalesManLed BillDetail , AkalTotalLine Repeat : SalesManLed BillDetail : SalesManLedgerBills Scrolled : Vertical Total : ClBalance Page Break : BILL ClPageTotal, BILL OpPageTotal Option : LedBILL OnAccDetail : @@HasOnAccount [ Line : AkalTotalLine ] Use : SalesManLed BillDetail Fixed : Yes Delete : Empty Delete : NextPage Delete : Explode Local : Field : BILLRef: Set as : " Total :" Local : Field : ClBalance : Set as : $$Total:ClBalance Border : Totals [ Line : SalesManLed BillDetail ] Field : Name Field , ClBalance Local : Field : Default : Style : Small Bold Local : Field : Name Field : Add : Field : BILLRef , BILLDate , PtyNAme Local : Field : Name Field : Width : 120 mms Repeat : ClBalance Empty : (@@ShowForex AND $$IsBaseCurrency:$OpeningBalance AND $$IsBaseCurrency:$ClosingBalance) OR + (##ShowInterest AND $$IsEmpty:$Interest) Space Top : if $$IsSiblingExploded then @@ExplodedSpace else 0 Next Page : NOT $$DoExplosionsFit OR ($$LineNumber = $$LastLineNumber AND NOT $$IsNextSibling) ;; Add : Explode : BillVouchers [ Field : PtyNAme ] Set as : $Parent [ Field : ClBalance ] Use : Amount Field Width : 30 mms Set as : $ClosingBalance [ Collection : SalesManLedgerBills ] Type : Bills Filter : DueBillsFilter, AgeFilter, BillTypeFilter , HasSameSalesWiseMan Sort : @@Default : $Parent Sort : @@DateIncr : $Parent [ System : Formula ] HasSameSalesWiseMan : @@SalesMan = $$OwNer:$SalesmanName SalesMan : $$CollectionField:$EISalesmanName:1:LedgerEntries [Variable : SalesManName] Type : String [ Part : SalesManLed Bill Title Part ] Line : SalesManLed BillTitle Line [ Line : SalesManLed BillTitle Line ] Field : Name Field Local : Field : Default : Type : String Local : Field : Default : Style : Small Bold Local : Field : Name Field : Set as: $$LocaleString:"Executive Name" Local : Field : Name Field : Indent: 2 Add : Field : SalesManLed BillClbTitle Repeat : SalesManLed BillClbTitle Border : Thin Box [ Field : SalesManLed BillClbTitle ] Use : NAme Field Set as : if ($$NumSets = 1) OR ($$Column = 1) then $$StringWord:1:$$LocaleString:"Outstanding Amount" else @@AgeTitle Align : Centre Style : Small Bold Width : 30 mms Border : Thin Left Right This is the code for salesman but i am not getting the amount in the amount fields.
