Remove duplicate Name

Discussion in 'Requests' started by Vikram Bhat, Jun 28, 2019.

         
  1. Vikram Bhat

    Vikram Bhat Member


    Dear experts
    In my party report
    Xyz party. 1000
    ABC party. 2000
    Xyz party 2000
    Xyz party. 1000
    ABC party 2300

    But I want report
    Xyz party 4000
    ABC party 4300

    Please help on this

    upload_2019-6-28_8-26-43.jpeg
     
    Last edited: Jun 28, 2019


  2. balajimg

    balajimg Member


    in collection use
    By : LedName : $LedgerName

    Aggr compute : Amt : Sum : $Amount
     


  3. Vikram Bhat

    Vikram Bhat Member


    Not Working
    [Report: My SalesmansSummary]

    Title : "SalesManwise Productive Call Report"
    Variable : SVFromDate , SVToDate
    Set : SVFromDate : $$MonthStart:##SVCurrentDate
    Set : SVToDate : $$MonthEnd:##SVCurrentDate

    [Form :My SalesManSSummary]
    Part : MySMANsReportTitle,My SalesmansSummaryTL,My SalesMansSummary
    Page Break : DSP ClPageBreak, SmansOpPageBreak
    Synchronize : Yes
    Height : 100% Page
    Width : 100% Page
    Space Top : If $$InPrintMode Then 0.2 Else 0 inches
    Space Bottom : If $$InPrintMode Then 0.25 Else 0 inches
    Space Left : If $$InPrintMode Then 0.25 Else 0 inches
    Space Right : If $$InPrintMode Then 0.25 Else 0 inches
    Button : F2Change Period,SMSRouteFilter,ExplodeFlag
    Bottom Buttons : BlankButton, InvReports, AcctReports, Report Operations, DYBKConfigure, FilterButton, ValueButton
    Bottom Toolbar Buttons : BottomToolBarBtn1, BottomToolBarBtn6, BottomToolBarBtn7, BottomToolBarBtn8, BottomToolBarBtn9, BottomToolBarBtn10, BottomToolBarBtn11, BottomToolBarBtn12
    Buttons : PrintButton, ExportButton, UploadButton, MailButton
    Background : White

    [Part:MySMANsReportTitle]
    Line:MySMANsReportTitle

    [Line:MySMANsReportTitle]
    Field :Name Field
    Right Field : Simple Field
    Local : Field : Name Field : Set as : " SalesManwise Productive Call Report "
    Local : Field : Simple Field : Info : $$String:##SVFromDate + " to " + $$String:##SVToDate
    Local : Field : Simple Field : Align : Right
    Local : Field : Default : Color : White
    Local : Field : Default : Style : Large Bold
    Local : Field : Default : Background : Dark Green
    Local : Field : Default : Full Width : Yes
    Local : Field : Default : Border : Double Bottom

    [Part : SmansOpPageBreak]
    Parts : My SalesMANsSummaryTL
    Vertical: Yes

    [Part : My SalesMANsSummaryTL]
    Line : My SalesMANsSummaryTL

    [Line : My SalesMANsSummaryTL]
    Use : My SalesMANsSummary
    Local : Field : Default : Type : string
    Local : Field : Default : Align: Center
    Local : Field : My SalesmansSno : Set As : "S.No"
    Local : Field : My Salesmansoutlet : Set As : "Outlet Name"
    Local : Field : MySalesmansAmount : Set As : "Amount"
    Local : Field : My Salesmansroute: Set As : "Route"
    Local : Field : Default : Style : Small Bold
    Border : Thin Top Bottom

    [Part :My SalesMANsSummary]
    Lines : My SalesMANsSummary
    BottomLines : My SalesMANsSummaryTotal
    Repeat : My SalesMansSummary :MySalesmansSummaryCollection
    Total : MySalesmansAmount
    Scroll : Vertical
    CommonBorder : Yes

    [Line :My SalesMansSummary]
    Field : My SalesmansSno
    Right Field :My Salesmansoutlet,MySalesmanAmount,My Salesmansroute
    Border : Thin bottom

    [Field:My SalesmansSno]
    Set as : $$ZeroFill:$$Line:2+"."
    Width : 5% Screen
    Align : Center
    Border : Thin Left
    Style : Small Bold

    [Field: My Salesmansoutlet]
    Use : Name Field
    Set As : $SMLedgerName
    Align : Left
    Width : 75% Screen
    Border : Thin Left
    Style : Small Bold
    Quick Search: Yes

    [Field: MySalesmansAmount]
    Use : Amount Forex Field
    Set as : $Amt
    Format : "No Zero,Symbol,"
    Align : Right
    Border : Thin Left Right
    Width : 15% Screen
    Style : Small Bold

    [Field: My Salesmansroute]
    Use : Name Field
    Set as : $AreaStore:Ledger:$Ledgername
    Width : 15% Screen
    Align : Right
    Border : Thin Left
    Style : Small Bold

    [Line : My SalesMANsSummaryTotal]
    Use : My SalesMANsSummary
    Local : Field :My SalesmansSno : Set As : ""
    Local : Field : My Salesmansoutlet : Set As : "Total"
    Local : Field : My Salesmansoutlet : Align : Centre
    Local : Field : MySalesmanAmount : Set As : $$Total:MySalesmansAmount
    Local : Field : My Salesmansroute: Set As :""
    Local : Field : Default : Style : Small Bold
    Border: Thin Top Bottom

    [Collection : MySalesmansSummaryCollection]
    Title : "SalesManwise Productive Call"
    Type : Vouchers : Voucher Type
    Child Of: $$VchTypeSales
    Belongs To: Yes
    Fetch : PartyLedgerName,LedgerEntries.*
    Filter : IsSameSAManSMVchr
    Filter : SMSRouteFilter

    [Collection : MyCollection]
    Source Collection : MySalesmansSummaryCollection
    Walk : Inventory Entries
    By : SMLedgerName : $PartyLedgerName
    Sort :SMLedgerName : $PartyLedgerName
    Aggr compute : Amt : Sum : $Amount
    Keep Source : ().

    [System: Formulae]
    IsSameSAManSMVchr : $EISMan:Ledger:$Ledgername = ##SManSMTrigger

    [Variable: SMLedgerName]
    Type : String
    Repeat : ##DSPRepeatCollection

    [System: Variables]
    SMLedgerName : ""
     
    Last edited: Jun 29, 2019


Share This Page