Eror :- Purchase Turnover with Broker in tally Prime

Discussion in 'Free Source Codes' started by Ankur2904, Jun 5, 2021.

    
  1. Ankur2904

    Ankur2904 Member


    error in the below code
    working in Tally ERP 9 but not in Tally Prime

    and I also want to use it in Purchase and Sales voucher ??

    ;===============================================================
    ;======================= F11 Feature ===========================
    ;===============================================================

    [#Part: CMP TallyShopFeatures Left]
    Add : Line : At End : CMP EnableBrokerLine

    [Line:CMP EnableBrokerLine]
    Space Bottom : 1.5 mms
    Field : Long Prompt,CMP EnableBrokerLine
    Local : Field : Long Prompt : Set as : "Enable My Report...?:"

    [Field:CMP EnableBrokerLine]
    Use : Logical Field
    Storage : EnableBroker
    Set as : If $$IsEmpty:$$Value then "No" else $$Value
    Sub Form: CMP BrokerNameReport: $$Value = "Yes"

    [Report: CMP BrokerNameReport]
    Form : CMP BrokerNameForm
    Object : Company

    [Form: CMP BrokerNameForm]
    Part : CMPBrokerDetails
    Bottom Part:smsMark86
    width : 50 % Page
    Height: 50 % Page



    [Field:CMPName Field]
    Use : Name Field
    Skip : Yes
    Align : Center
    Border : Thin Bottom

    [Part:smsMark86]
    Line:smsMarkLn86

    [Line:smsMarkLn86]
    Field:smsMarkFld86

    [Field:smsMarkFld86]
    Use:Name Field
    Set as:"Visit: https://www.youtube.com"
    Full Width:Yes
    Align:Center
    Color:"Blue"
    Style:sms007
    Border:Thin Bottom
    Read Only:Yes
    Skip Forward:Yes

    [Style:sms007]
    Font:"Times New Roman"
    Height:12

    [Part:CMPBrokerDetails]
    Part : CMP BrokerNamePart
    Vertical : No
    Common Border : Yes

    [Part: CMP BrokerNamePart]
    Line : CMP BrokerNamePartTit,CMP BrokerName LineDetails
    Repeat : CMP BrokerName LineDetails: BrokerNameList
    BreakOn : $$IsEmpty:$BrokerNameList
    Height : 10
    Scroll : Vertical
    CommonBorder: Yes
    Space Left : 2 mms
    Space Right : 2 mms
    Border : Thin Right

    [Line:CMP BrokerNamePartTit]
    Field : CMPName Field
    Local : Field : CMPName Field : Set as : "Broker Name"

    [Line: CMP BrokerName LineDetails]
    Field : CMP BrokerNameList;,CMP TransportList,CMP SalesManList;,CMP Broker CommissionField

    [Field: CMP BrokerNameList]
    Use : Name Field
    Storage : BrokerNameList
    Style : Small Bold



    ;===============================================================
    ;======================= Add Fields ===========================
    ;===============================================================

    [#Part:DBLLINE Narration]
    Add : Line : Before : VCH NarrPrompt : VCHBrokerLine

    [Line:VCHBrokerLine]
    Invisible : NOT $EnableBroker:Company:##SVCurrentCompany OR NOT $$IsPurchase:##SVVoucherType
    Field : VCHBrokerNameTit,VCHBrokerName

    [Field:VCHBrokerNameTit]
    Use : Meduim Prompt
    Set as : "Broker Name :"
    Skip : Yes



    [Field:VCHBrokerName]
    Use : Name Field
    Storage : BrokerName
    Table : BrokerNameColl,EndofList
    Show Table : Always
    Key : CreateBroker



    [Key:CreateBroker]
    Key : Alt + C
    Action : Alter : CMP BrokerNameReport

    ;;=========================================================
    ;;================= Broker wise Report ==================
    ;;=========================================================
    [#Menu: Gateway of Tally]
    Add : Key Item : After : @@locSalesRegister : "My Purchase Report" : R : Display : BrokerReport
    ;Control : BrokerReport : $EnableBroker:Company:##SVCurrentCompany

    [Report:BrokerReport]
    Use : DSP Template
    Title : "Broker Report"
    Variable: SVFromDate, SVToDate
    Repeat : PartyName
    Form : BrokerReport
    Set : SVFromDate : $$MonthStart:##SVCurrentDate
    Set : SVToDate : $$MonthEnd:##SVCurrentDate
    Set : FilterBroker : ""


    [Form:BrokerReport]
    Button : PrintButton, ExportButton
    Button : ExplodeFlag,ChangePeriod,BtnBroker
    Bottom Toolbar Buttons : EnterToEdit, BottomToolBarBtn8
    Part : SMSTitle,SMSPeriod,SMSDetails
    Bottom Part:smsMark88
    Bottom Part :SMSTotals
    Width : 100% Page
    Space Left : 2 mms
    Space Right : 2 mms

    [Key: EnterToEdit]
    Key : Enter
    Title : $$LocaleString:"Explode"
    Type : BottomToolBarBtn2
    Action : Explode

    [Part:smsMark88]
    Line:smsMarkLn88

    [Line:smsMarkLn88]
    Field:smsMarkFld88

    [Field:smsMarkFld88]
    Use:Name Field
    Set as:"Visit: https://www.youtube.com"
    Full Width:Yes
    Align:Center
    Color:"Blue"
    Style:sms007
    Border:Thin Bottom
    Read Only:Yes
    Skip Forward:Yes

    [Part:SMSTitle]
    Line : SMSTitle
    Horizontal Align : Center

    [Part:SMSPeriod]
    Line : SMSPeriod

    [Line:SMSTitle]
    Field : Simple Field
    Local : Field : Simple Field : Style : Large Bold
    Local : Field : Simple Field : Info : "Purchase Report"
    Local : Field : Simple Field : Border: Thin Bottom
    Local : Field : Simple Field : Align : Center

    [Line:SMSPeriod]
    Right Field : Name Field
    Left Field : Short Prompt,GWLWBrokerFilter
    Local : Field : Name Field : Info : @@DSPDateStr
    Local : Field : Name Field : Width : 50
    Local : Field : Name Field : Align : Right
    Local : Field : Short Prompt : Set as: "Broker:"
    Local : Field : Short Prompt : Inactive: Not $EnableBroker:Company:##SVCurrentCompany


    [Field:GWLWBrokerFilter]
    Inactive : Not $EnableBroker:Company:##SVCurrentCompany
    Use : Simple Field
    Style : Normal Bold
    Set as : @VCHBrokerName
    Set Always : Yes
    VCHBrokerName : If $$IsEndOfList:##FilterBroker or ##FilterBroker="" Then "Show All" Else ##FilterBroker



    [Line:SMSHead]
    Use : SMSDetails
    Border : Column Titles
    Local : Field : Default : Type : String
    Local : Field : Default : Align : Center
    Local : Field : Default : Border : Thin Left
    Local : Field : Default : Style : Normal Bold
    Local : Field : SWSno : Set as : "Sno"
    Local : Field : SWSno : Border : Thin Left Right
    Local : Field : SMSPartyName : Set as : "Party Name"
    Local : Field : SMSPartyName : Align : Left
    Local : Field : SMSActulQty : Set as : "Actual Qty"
    Local : Field : SMSActulQty : Align : Left
    Local : Field : SMSBilledQty : Set as : "Billed Qty"
    Local : Field : SMSBilledQty : Align : Left
    Local : Field : SMSAmount : Set as : "Amount"
    Local : Field : SMSAmount : Border : Thin Left Right
    Space Top : 1.5 mms
    Space Bottom: 1.5 mms

    [Part:SMSDetails]
    Line : SMSHead,SMSDetails
    Repeat : SMSDetails:SMSPartyWise
    Scroll : Vertical
    Total : SMSActulQty,SMSBilledQty,SMSAmount
    Common Border : Yes

    [Line:SMSDetails]
    Field : SWSno,SMSPartyName
    Right Field : SMSActulQty,SMSBilledQty,SMSAmount
    Option : AlterOnEnter : $$IsVoucher
    Space Bottom: 0.5 mms
    Space Top : 0.5 mms
    Border : Thin Top
    Explode : SMSExplode : ($$KeyExplode OR ##ExplodeFlag)

    [Field:SMSDefault]
    Use : Name Field
    Style : Normal Bold

    [Field:SWSno]
    Use : SMSDefault
    Set as : $$Line
    Width : 1.5 cm
    Align : Center
    Border : Thin Left Right

    [Field:SMSPartyName]
    Use : SMSDefault
    Set as : $PartyName
    Width : 60
    Quick Search: Yes
    Space Left : 2 mms

    [Field:SMSActulQty]
    Use : Qty Field
    Type : Number
    Set as : $TotActQty;VoucherTypeName
    Width : 16
    Space Left : 2 mms
    Border : Thin Left Right

    [Field:SMSBilledQty]
    Use : SMSActulQty
    Set as : $TotBillQty
    Width : 16
    Space Left : 2 mms
    Border : Thin Right

    [Field:SMSAmount]
    Use : SMSDefault
    Set as : $TotAmount
    Type : Amount
    Width : @@AmountWidth
    Format : "No Zero, Symbol," + ##ShowForex
    Align : Right
    Key : Calculator
    Max : @@MaxNumberWidth
    Width : 16
    Space Right : 2 mms
    Border : Thin Right
    Tooltip : "Amount Without TAX"

    [Part:SMSTotals]
    Line : SMSTotal

    [Line:SMSTotal]
    Border : Totals
    Use : SMSDetails
    Local : Field : Default : Type : String
    Local : Field : Default : Align : Right
    Local : Field : Default : Style : Large Bold
    Local : Field : Default : Border : Thin Left
    Local : Field : SWSno : Set as : ""
    Local : Field : SMSPartyName : Set as : "Grand Total"
    Local : Field : SMSActulQty : Set as : $$Total:SMSActulQty
    Local : Field : SMSBilledQty : Set as : $$Total:SMSBilledQty
    Local : Field : SMSAmount : Set as : $$Total:SMSAmount
    Local : Field : SMSAmount : Border : Thin Left Right
    Local : Field : SMSAmount : Align : Right

    [Part:SMSExplode]
    Line : SMSExplode
    Repeat : SMSExplode:SMSPartyExplode
    Border : Thin Bottom

    [Line:SMSExplode]
    Use : SMSDetails
    Delete : Border
    Local : Field : SWSno : Set as : ""
    Local : Field : Default : Style : Normal Italic
    Local : Field : SMSPartyName : Set as : $ItemName
    Local : Field : SMSPartyName : Align : Right
    Local : Field : SMSActulQty : Type : Quantity
    Local : Field : SMSActulQty : Set as : $SubActQty
    Local : Field : SMSBilledQty : Type : Quantity
    Local : Field : SMSBilledQty : Set as : $SubBillQty
    Local : Field : SMSAmount : Set as : $SubAmount

    ;===============================================================
    ;======================= Add Filters ===========================
    ;===============================================================

    [Button:BtnBroker]
    Key : F5
    Action : Execute : BrokerReportWise
    Title : Report Filter
    Inactive: Not $EnableBroker:Company:##SVCurrentCompany

    [Report:BrokerReportWise]
    Form : BrokerReportWise

    [Form:BrokerReportWise]
    Part : BrokerReportWise
    Space Left : 2 mms
    Space Right : 2 mms

    [Part:BrokerReportWise]
    Line : BrokerReportWise

    [Line:BrokerReportWise]
    Field : Medium Prompt,BrokerReportWise
    Local : Field : Medium Prompt : Set as : "Select Broker Name:"
    Space Bottom : 2 mms

    [Field:BrokerReportWise]
    Table : BrokerNameColl,EndOfList
    ShowTable : Always
    Use : Name Field
    Width : 20
    Border : Thin Box
    Variable : FilterBroker
    Modifies : FilterBroker



    ;=============================================================
    ;================= System Functions =========================
    ;=============================================================

    [System:UDF]
    EnableBroker : Logical : 4566
    BrokerNameList : String : 4567
    TransportList : String : 4568
    SalesManList : String : 4569
    BrokerName : String : 4570
    TransportName : String : 4571
    SalesManName : String : 4572

    [System:Formula]
    SMSFilter : $BrokerName=@@BrokerWise AND $TransportName=@@TransportWise AND $SalesManName=@@SalesManWise
    BrokerWise : If $$IsEndOfList:##FilterBroker or ##FilterBroker="" Then $BrokerName Else ##FilterBroker
    TransportWise : If $$IsEndOfList:##FilterTransport or ##FilterTransport="" Then $TransportName Else ##FilterTransport
    SalesManWise : If $$IsEndOfList:##FilterSalesMan or ##FilterSalesMan="" Then $SalesManName Else ##FilterSalesMan
    SMSExplodeFilter: $PartyName=#SMSPartyName

    [Collection: SMS Voucher]
    Type : Vouchers : VoucherType
    Child of : $$VchTypePurchase
    Belongs to : Yes
    Fetch : Date,VoucherTypeName,PartyLedgerName,BasicPurchaseOrderNo,Amount,BrokerName,TransportName,SalesManName
    Filter : NOTIsOptionalVoucher,SMSFilter

    [Collection:SMSPartyWise]
    Source Collection : SMS Voucher
    Walk : Inventory Entries
    By : PartyName : $PartyLedgerName
    Aggr Compute: TotActQty : Sum : $ActualQty
    Aggr Compute: TotBillQty: Sum : $BilledQty
    Aggr Compute: TotAmount : Sum : $Amount
    Sort : Default : $PartyName

    [Collection:SMSPartyExplode]
    Source Collection : SMS Voucher
    Walk : Inventory Entries
    By : PartyName : $PartyLedgerName
    By : ItemName : $StockItemName
    Aggr Compute: SubActQty : Sum : $ActualQty
    Aggr Compute: SubBillQty: Sum : $BilledQty
    Aggr Compute: SubAmount : Sum : $Amount
    Filter : SMSExplodeFilter

    [Collection:BrokerNameColl]
    Type : BrokerNameList: Company
    Childof : ##SVCurrentCompany
    Format : $BrokerNameList,25
    Title : List of Brokers

    [Collection:TransportNameColl]
    Type : TransportList: Company
    Childof : ##SVCurrentCompany
    Format : $TransportList,25
    Title : List of Transports

    [Collection:SalesManNameColl]
    Type : SalesManList: Company
    Childof : ##SVCurrentCompany
    Format : $SalesManList,25
    Title : List of SalesMans

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

    [Variable:FilterBroker]
    Type : String

    [Variable:FilterTransport]
    Type : String

    [Variable:FilterSalesMan]
    Type : String

    [System:Variables]
    FilterBroker : ""
    FilterTransport : ""
    FilterSalesMan : ""
     

    Attached Files:



  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [#Part: CMP TallyShopFeatures Left] -- this does not exists in PRIME, so find the appropriate PART name for Prime and replace that.

    For Sales and Purchase...... in [Line:VCHBrokerLine] add your condition for SALES....Purchase is already existing.

    This Field - [Field:CMPName Field] already exists.....So find all instances of CMPName Field and rename it.
     


  3. N vinoth

    N vinoth Guest


    ;;------Tally Shop / Add-On-------
    [#Part: CMP TallyShop F11]

    Parts : CMP TallyShopFeatures Left
    Vertical : Yes
    Invisible : NOT ##SVTallyShop


    [#Part: CMP TallyShopFeatures Left]
    Add : Line : At End : CMP EnableBrokerLine

    [Line:CMP EnableBrokerLine]
    Space Bottom : 1.5 mms
    Field : Long Prompt,CMP EnableBrokerLine
    Local : Field : Long Prompt : Set as : "Enable My Report...?:"

    [Field:CMP EnableBrokerLine]
    Use : Logical Field
    Storage : EnableBroker
    Set as : If $$IsEmpty:$$Value then "No" else $$Value
    Sub Form: CMP BrokerNameReport: $$Value = "Yes"

    [Report: CMP BrokerNameReport]
    Form : CMP BrokerNameForm
    Object : Company

    [Form: CMP BrokerNameForm]
    Part : CMPBrokerDetails
    Bottom Part:smsMark86
    width : 50 % Page
    Height: 50 % Page



    [Field:CMPName Field1]
    Use : Name Field
    Skip : Yes
    Align : Center
    Border : Thin Bottom

    [Part:smsMark86]
    Line:smsMarkLn86

    [Line:smsMarkLn86]
    Field:smsMarkFld86

    [Field:smsMarkFld86]
    Use:Name Field
    Set as:"Visit: https://www.youtube.com"
    Full Width:Yes
    Align:Center
    Color:"Blue"
    Style:sms007
    Border:Thin Bottom
    Read Only:Yes
    Skip Forward:Yes

    [Style:sms007]
    Font:"Times New Roman"
    Height:12

    [Part:CMPBrokerDetails]
    Part : CMP BrokerNamePart
    Vertical : No
    Common Border : Yes

    [Part: CMP BrokerNamePart]
    Line : CMP BrokerNamePartTit,CMP BrokerName LineDetails
    Repeat : CMP BrokerName LineDetails: BrokerNameList
    BreakOn : $$IsEmpty:$BrokerNameList
    Height : 10
    Scroll : Vertical
    CommonBorder: Yes
    Space Left : 2 mms
    Space Right : 2 mms
    Border : Thin Right

    [Line:CMP BrokerNamePartTit]
    Field : CMPName Field1
    Local : Field : CMPName Field1 : Set as : "Broker Name"

    [Line: CMP BrokerName LineDetails]
    Field : CMP BrokerNameList;,CMP TransportList,CMP SalesManList;,CMP Broker CommissionField

    [Field: CMP BrokerNameList]
    Use : Name Field
    Storage : BrokerNameList
    Style : Small Bold



    ;===============================================================
    ;======================= Add Fields ===========================
    ;===============================================================

    [#Part:DBLLINE Narration]
    Add : Line : Before : VCH NarrPrompt : VCHBrokerLine

    [Line:VCHBrokerLine]
    Invisible : NOT $EnableBroker:Company:##SVCurrentCompany OR NOT $$IsPurchase:##SVVoucherType
    Field : VCHBrokerNameTit,VCHBrokerName

    [Field:VCHBrokerNameTit]
    Use : Meduim Prompt
    Set as : "Broker Name :"
    Skip : Yes



    [Field:VCHBrokerName]
    Use : Name Field
    Storage : BrokerName
    Table : BrokerNameColl,EndofList
    Show Table : Always
    Key : CreateBroker



    [Key:CreateBroker]
    Key : Alt + C
    Action : Alter : CMP BrokerNameReport

    ;;=========================================================
    ;;================= Broker wise Report ==================
    ;;=========================================================
    [#Menu: Gateway of Tally]
    Add : Key Item : After : @@locSalesRegister : "My Purchase Report" : R : Display : BrokerReport
    ;Control : BrokerReport : $EnableBroker:Company:##SVCurrentCompany

    [Report:BrokerReport]
    Use : DSP Template
    Title : "Broker Report"
    Variable: SVFromDate, SVToDate
    Repeat : PartyName
    Form : BrokerReport
    Set : SVFromDate : $$MonthStart:##SVCurrentDate
    Set : SVToDate : $$MonthEnd:##SVCurrentDate
    Set : FilterBroker : ""


    [Form:BrokerReport]
    Button : PrintButton, ExportButton
    Button : ExplodeFlag,ChangePeriod,BtnBroker
    Bottom Toolbar Buttons : EnterToEdit, BottomToolBarBtn8
    Part : SMSTitle,SMSPeriod,SMSDetails
    Bottom Part:smsMark88
    Bottom Part :SMSTotals
    Width : 100% Page
    Space Left : 2 mms
    Space Right : 2 mms

    [Key: EnterToEdit]
    Key : Enter
    Title : $$LocaleString:"Explode"
    Type : BottomToolBarBtn2
    Action : Explode

    [Part:smsMark88]
    Line:smsMarkLn88

    [Line:smsMarkLn88]
    Field:smsMarkFld88

    [Field:smsMarkFld88]
    Use:Name Field
    Set as:"Visit: https://www.youtube.com"
    Full Width:Yes
    Align:Center
    Color:"Blue"
    Style:sms007
    Border:Thin Bottom
    Read Only:Yes
    Skip Forward:Yes

    [Part:SMSTitle]
    Line : SMSTitle
    Horizontal Align : Center

    [Part:SMSPeriod]
    Line : SMSPeriod

    [Line:SMSTitle]
    Field : Simple Field
    Local : Field : Simple Field : Style : Large Bold
    Local : Field : Simple Field : Info : "Purchase Report"
    Local : Field : Simple Field : Border: Thin Bottom
    Local : Field : Simple Field : Align : Center

    [Line:SMSPeriod]
    Right Field : Name Field
    Left Field : Short Prompt,GWLWBrokerFilter
    Local : Field : Name Field : Info : @@DSPDateStr
    Local : Field : Name Field : Width : 50
    Local : Field : Name Field : Align : Right
    Local : Field : Short Prompt : Set as: "Broker:"
    Local : Field : Short Prompt : Inactive: Not $EnableBroker:Company:##SVCurrentCompany


    [Field:GWLWBrokerFilter]
    Inactive : Not $EnableBroker:Company:##SVCurrentCompany
    Use : Simple Field
    Style : Normal Bold
    Set as : @VCHBrokerName
    Set Always : Yes
    VCHBrokerName : If $$IsEndOfList:##FilterBroker or ##FilterBroker="" Then "Show All" Else ##FilterBroker



    [Line:SMSHead]
    Use : SMSDetails
    Border : Column Titles
    Local : Field : Default : Type : String
    Local : Field : Default : Align : Center
    Local : Field : Default : Border : Thin Left
    Local : Field : Default : Style : Normal Bold
    Local : Field : SWSno : Set as : "Sno"
    Local : Field : SWSno : Border : Thin Left Right
    Local : Field : SMSPartyName : Set as : "Party Name"
    Local : Field : SMSPartyName : Align : Left
    Local : Field : SMSActulQty : Set as : "Actual Qty"
    Local : Field : SMSActulQty : Align : Left
    Local : Field : SMSBilledQty : Set as : "Billed Qty"
    Local : Field : SMSBilledQty : Align : Left
    Local : Field : SMSAmount : Set as : "Amount"
    Local : Field : SMSAmount : Border : Thin Left Right
    Space Top : 1.5 mms
    Space Bottom: 1.5 mms

    [Part:SMSDetails]
    Line : SMSHead,SMSDetails
    Repeat : SMSDetails:SMSPartyWise
    Scroll : Vertical
    Total : SMSActulQty,SMSBilledQty,SMSAmount
    Common Border : Yes

    [Line:SMSDetails]
    Field : SWSno,SMSPartyName
    Right Field : SMSActulQty,SMSBilledQty,SMSAmount
    Option : AlterOnEnter : $$IsVoucher
    Space Bottom: 0.5 mms
    Space Top : 0.5 mms
    Border : Thin Top
    Explode : SMSExplode : ($$KeyExplode OR ##ExplodeFlag)

    [Field:SMSDefault]
    Use : Name Field
    Style : Normal Bold

    [Field:SWSno]
    Use : SMSDefault
    Set as : $$Line
    Width : 1.5 cm
    Align : Center
    Border : Thin Left Right

    [Field:SMSPartyName]
    Use : SMSDefault
    Set as : $PartyName
    Width : 60
    Quick Search: Yes
    Space Left : 2 mms

    [Field:SMSActulQty]
    Use : Qty Field
    Type : Number
    Set as : $TotActQty;VoucherTypeName
    Width : 16
    Space Left : 2 mms
    Border : Thin Left Right

    [Field:SMSBilledQty]
    Use : SMSActulQty
    Set as : $TotBillQty
    Width : 16
    Space Left : 2 mms
    Border : Thin Right

    [Field:SMSAmount]
    Use : SMSDefault
    Set as : $TotAmount
    Type : Amount
    Width : @@AmountWidth
    Format : "No Zero, Symbol," + ##ShowForex
    Align : Right
    Key : Calculator
    Max : @@MaxNumberWidth
    Width : 16
    Space Right : 2 mms
    Border : Thin Right
    Tooltip : "Amount Without TAX"

    [Part:SMSTotals]
    Line : SMSTotal

    [Line:SMSTotal]
    Border : Totals
    Use : SMSDetails
    Local : Field : Default : Type : String
    Local : Field : Default : Align : Right
    Local : Field : Default : Style : Large Bold
    Local : Field : Default : Border : Thin Left
    Local : Field : SWSno : Set as : ""
    Local : Field : SMSPartyName : Set as : "Grand Total"
    Local : Field : SMSActulQty : Set as : $$Total:SMSActulQty
    Local : Field : SMSBilledQty : Set as : $$Total:SMSBilledQty
    Local : Field : SMSAmount : Set as : $$Total:SMSAmount
    Local : Field : SMSAmount : Border : Thin Left Right
    Local : Field : SMSAmount : Align : Right

    [Part:SMSExplode]
    Line : SMSExplode
    Repeat : SMSExplode:SMSPartyExplode
    Border : Thin Bottom

    [Line:SMSExplode]
    Use : SMSDetails
    Delete : Border
    Local : Field : SWSno : Set as : ""
    Local : Field : Default : Style : Normal Italic
    Local : Field : SMSPartyName : Set as : $ItemName
    Local : Field : SMSPartyName : Align : Right
    Local : Field : SMSActulQty : Type : Quantity
    Local : Field : SMSActulQty : Set as : $SubActQty
    Local : Field : SMSBilledQty : Type : Quantity
    Local : Field : SMSBilledQty : Set as : $SubBillQty
    Local : Field : SMSAmount : Set as : $SubAmount

    ;===============================================================
    ;======================= Add Filters ===========================
    ;===============================================================

    [Button:BtnBroker]
    Key : F5
    Action : Execute : BrokerReportWise
    Title : Report Filter
    Inactive: Not $EnableBroker:Company:##SVCurrentCompany

    [Report:BrokerReportWise]
    Form : BrokerReportWise

    [Form:BrokerReportWise]
    Part : BrokerReportWise
    Space Left : 2 mms
    Space Right : 2 mms

    [Part:BrokerReportWise]
    Line : BrokerReportWise

    [Line:BrokerReportWise]
    Field : Medium Prompt,BrokerReportWise
    Local : Field : Medium Prompt : Set as : "Select Broker Name:"
    Space Bottom : 2 mms

    [Field:BrokerReportWise]
    Table : BrokerNameColl,EndOfList
    ShowTable : Always
    Use : Name Field
    Width : 20
    Border : Thin Box
    Variable : FilterBroker
    Modifies : FilterBroker



    ;=============================================================
    ;================= System Functions =========================
    ;=============================================================

    [System:UDF]
    EnableBroker : Logical : 4566
    BrokerNameList : String : 4567
    TransportList : String : 4568
    SalesManList : String : 4569
    BrokerName : String : 4570
    TransportName : String : 4571
    SalesManName : String : 4572

    [System:Formula]
    SMSFilter : $BrokerName=@@BrokerWise AND $TransportName=@@TransportWise AND $SalesManName=@@SalesManWise
    BrokerWise : If $$IsEndOfList:##FilterBroker or ##FilterBroker="" Then $BrokerName Else ##FilterBroker
    TransportWise : If $$IsEndOfList:##FilterTransport or ##FilterTransport="" Then $TransportName Else ##FilterTransport
    SalesManWise : If $$IsEndOfList:##FilterSalesMan or ##FilterSalesMan="" Then $SalesManName Else ##FilterSalesMan
    SMSExplodeFilter: $PartyName=#SMSPartyName

    [Collection: SMS Voucher]
    Type : Vouchers : VoucherType
    Child of : $$VchTypePurchase
    Belongs to : Yes
    Fetch : Date,VoucherTypeName,PartyLedgerName,BasicPurchaseOrderNo,Amount,BrokerName,TransportName,SalesManName
    Filter : NOTIsOptionalVoucher,SMSFilter

    [Collection:SMSPartyWise]
    Source Collection : SMS Voucher
    Walk : Inventory Entries
    By : PartyName : $PartyLedgerName
    Aggr Compute: TotActQty : Sum : $ActualQty
    Aggr Compute: TotBillQty: Sum : $BilledQty
    Aggr Compute: TotAmount : Sum : $Amount
    Sort : Default : $PartyName

    [Collection:SMSPartyExplode]
    Source Collection : SMS Voucher
    Walk : Inventory Entries
    By : PartyName : $PartyLedgerName
    By : ItemName : $StockItemName
    Aggr Compute: SubActQty : Sum : $ActualQty
    Aggr Compute: SubBillQty: Sum : $BilledQty
    Aggr Compute: SubAmount : Sum : $Amount
    Filter : SMSExplodeFilter

    [Collection:BrokerNameColl]
    Type : BrokerNameList: Company
    Childof : ##SVCurrentCompany
    Format : $BrokerNameList,25
    Title : List of Brokers

    [Collection:TransportNameColl]
    Type : TransportList: Company
    Childof : ##SVCurrentCompany
    Format : $TransportList,25
    Title : List of Transports

    [Collection:SalesManNameColl]
    Type : SalesManList: Company
    Childof : ##SVCurrentCompany
    Format : $SalesManList,25
    Title : List of SalesMans

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

    [Variable:FilterBroker]
    Type : String

    [Variable:FilterTransport]
    Type : String

    [Variable:FilterSalesMan]
    Type : String

    [System:Variables]
    FilterBroker : ""
    FilterTransport : ""
    FilterSalesMan : ""
     


  4. DIVYESH_9712

    DIVYESH_9712 New Member


    Dear Sir, How to open this option in tally prime ,please help
     

    Attached Files:



  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Make a proper query........give info on what report you are referring to.
     


  6. DIVYESH_9712

    DIVYESH_9712 New Member


    My query is in ledger voucher configration in tally prime.,this option not available in tally prime.
     

    Attached Files:



  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [#Part: LEDVCHCFG Common]
    Add : Line : After : LedShowForex : INCLOpening
     


  8. DIVYESH_9712

    DIVYESH_9712 New Member


    thank you sir, for your help
     


Share This Page