1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Filter not working......

Discussion in 'Free Source Codes' started by Jenny, Sep 17, 2018.

    
Tags:
  1. Jenny

    Jenny Active Member


    Code:
    
[Report: SmReport]
Use : DSP Template
Form : PQRReport
Title : "Quotation 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 Sea Green

;Delete : Bottom Buttons: DSPAutoColumns, RelReports,BudgetAnalysis, ReportConfig
Bottom Toolbar Buttons : BottomToolBarBtn1, BottomToolBarBtn6, BottomToolBarBtn7, BottomToolBarBtn8, 

BottomToolBarBtn9, BottomToolBarBtn10, BottomToolBarBtn11, BottomToolBarBtn12, 
Add: Button: Salesmanfilter

[Part: PQRReport]
Lines:PQRTitile,PQRBody
BottomLines : PQRBody Total
Repeat : PQRBody  :PQRSalesManVouchersColl
CommonBorder: Yes
Scroll : Vertical
Total  :PQRPartyAmount


[Line: PQRTitile]
Use:PQRBody
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:"Quot No."
Local : Field : PQRPartyName : Set as: $$LocaleString:"Party Name"
Local : Field : PQRPartySalesMan: Set as: $$LocaleString:"Contact Name"
Local : Field : PQRPartyVchType : Set as: $$LocaleString:"Vch Type" 
Local : Field : PQRPartyAmount : Set as: $$LocaleString:"Amount"
Border : Flush Totals

[Line: PQRBody]
Field:PQRSno, PQRPartyDate,PQRPartyVchNo,PQRPartyName,PQRPartySalesMan,PQRPartyVchType
RightField:PQRPartyAmount 
Border :Thin Bottom

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

[Field: PQRPartyDate]
Set as : $Date
Width : 10% Screen
Align : Right
;Style : Tiny
Border : Thin Left 

[Field: PQRPartyVchNo]
Set as : $VoucherNumber
Width : 10% Screen
Align : Center
;Style : Tiny
Border : Thin Left 

[Field: PQRPartyName]
Use : Name Field
Set as : $PartyLedgerName
Border : Thin Left 
Width : 20% Screen
Align : Left
;Style : Tiny
Variable: LedgerName
Display : Ledger Vouchers

[Field: PQRPartySalesMan]
Use :Name Field
Set as : $$String:$MMSalesmanName
Border : Thin Left 
Width : 20% Screen
Align : Left
;Style : Tiny
Key : Create SalesmanName

[Field: PQRPartyVchType]
Set as : $VoucherTypeName
Border : Thin Left 
Width : 15% Screen
Align : Left
;Style : Tiny

[Field: PQRPartyAmount]
Use : Amount Forex Field
Set as : $Amount 
Border : Thin Left
Width : 15% Screen
Align : Right
;Style : Tiny
Format : "No Zero,DrCr,Symbol," + ##ShowForex

[Line: PQRBody Total]
Use:PQRBody
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 : PQRPartyVchType : Set as: ""
Local : Field : PQRPartyAmount : Set as: $$Total:PQRPartyAmount
Border : Flush Totals

;============================== Filter ===================================

[Button:SalesmanFilter]
Key : Alt+S
Action : Execute : SalesmanFilter
Title : Contact 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 Contact Name: "

[Field:SalesmanFilter]
Table : ContactNameCollection,EndOfList
ShowTable : Always
Use : Name Field
Width : 20
Border : Thin Box
Variable : PQRPartySalesman
Modifies : PQRPartySalesman

;===========================================================================================

=====
;===================================== Collections 

=================================================

[Collection: PQRSalesManVouchersColl]
Type : Voucher
Fetch : Date, VoucherNumber, VoucherTypeName,LedgerName,PartyLedgerName,MMSalesmanName, 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 $$IsCreditNote:$VoucherTypeName
SalesManWise : $MMSalesmanName=@@SAlesManEOL
SalesManFull : $MMSalesmanName=$MMSalesmanName
SAlesManEOL : if $$IsEndOfList:##SalesManName then $MMSalesmanName Else ##SalesManName
SalesManFilter : if ##SalesManChqVar="Filter" Then @@SalesManWise Else @@SalesManFull
    filter.jpg
     
    Last edited: Sep 18, 2018
    Jenny, Sep 17, 2018
    #1


  2. drive

    drive Active Member


    Try This
    [System: Formula]
    SalesManFilter : $VCHSalesmanName = ##SalesManName Or $$IsSysName:##SalesManName
     
    drive, Sep 18, 2018
    #2


  3. Jenny

    Jenny Active Member


    Its not working...
    Its not working .. i use in report which field showing in salesman =
    Set as : $$String:$MMSalesmanName
     
    Jenny, Sep 18, 2018
    #3


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [Button : SalesmanFilter]
    Title : "Contact Name"
    Key : Alt+S
    Action : Modify Variables : SalesManChqVar

    Use this only.........

    COMMENT OUT the following........
    /*
    [Button:SalesmanFilter]
    Key : Alt+S
    Action : Execute : SalesmanFilter
    Title : Contact 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 Contact Name: "

    [Field:SalesmanFilter]
    Table : ContactNameCollection,EndOfList
    ShowTable : Always
    Use : Name Field
    Width : 20
    Border : Thin Box
    Variable : PQRPartySalesman
    Modifies : PQRPartySalesman
    */
     
    Amit Kamdar, Sep 18, 2018
    #4


  5. drive

    drive Active Member


    [Report: SmReport]
    Use : DSP Template
    Form : PQRReport
    Title : "Quotation Report"
    Set : SVFromDate : $$MonthStart:##SVCurrentDate
    Set : SVToDate : $$MonthEnd:##SVCurrentDate
    Variable : vSalesManName : String
    Set : vSalesManName : ""

    [Form: PQRReport]
    Use : DSP Template
    Parts : PQRReport
    Height : 100% screen
    Width : 100% screen
    Delete : Buttons: ExplodeFlag
    Background: @@SV_RELEASEDLEAFGREEN_PL; Very Light Sea Green
    Bottom Toolbar Buttons : BottomToolBarBtn1, BottomToolBarBtn6, BottomToolBarBtn7, BottomToolBarBtn8, BottomToolBarBtn9, BottomToolBarBtn10, BottomToolBarBtn11, BottomToolBarBtn12,
    Add: Button: Salesmanfilter

    [Part: PQRReport]
    Lines:pQRTitile,PQRBody
    BottomLines : PQRBody Total
    Repeat : PQRBody :pQRSalesManVouchersColl
    CommonBorder: Yes
    Scroll : Vertical
    Total :pQRPartyAmount

    [Line: PQRTitile]
    Use:pQRBody
    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:"Quot No."
    Local : Field : PQRPartyName : Set as: $$LocaleString:"Party Name"
    Local : Field : PQRPartySalesMan: Set as: $$LocaleString:"Contact Name"
    Local : Field : PQRPartyVchType : Set as: $$LocaleString:"Vch Type"
    Local : Field : PQRPartyAmount : Set as: $$LocaleString:"Amount"
    Border : Flush Totals

    [Line: PQRBody]
    Field:pQRSno, PQRPartyDate,PQRPartyVchNo,PQRPartyName,PQRPartySalesMan,PQRPartyVchType
    RightField:pQRPartyAmount
    Border :Thin Bottom

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

    [Field: PQRPartyDate]
    Set as : $Date
    Width : 10% Screen
    Align : Right
    ;Style : Tiny
    Border : Thin Left

    [Field: PQRPartyVchNo]
    Set as : $VoucherNumber
    Width : 10% Screen
    Align : Center
    ;Style : Tiny
    Border : Thin Left

    [Field: PQRPartyName]
    Use : Name Field
    Set as : $PartyLedgerName
    Border : Thin Left
    Width : 20% Screen
    Align : Left
    ;Style : Tiny
    Variable: LedgerName
    Display : Ledger Vouchers

    [Field: PQRPartySalesMan]
    Use :Name Field
    Set as : $$String:$MMSalesmanName
    Border : Thin Left
    Width : 20% Screen
    Align : Left
    ;Style : Tiny
    ;Key : Create SalesmanName

    [Field: PQRPartyVchType]
    Set as : $VoucherTypeName
    Border : Thin Left
    Width : 15% Screen
    Align : Left
    ;Style : Tiny

    [Field: PQRPartyAmount]
    Use : Amount Forex Field
    Set as : $Amount
    Border : Thin Left
    Width : 15% Screen
    Align : Right
    ;Style : Tiny
    Format : "No Zero,DrCr,Symbol," + ##ShowForex

    [Line: PQRBody Total]
    Use:pQRBody
    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 : PQRPartyVchType : Set as: ""
    Local : Field : PQRPartyAmount : Set as: $$Total:pQRPartyAmount
    Border : Flush Totals

    ;============================== Filter ===================================

    [Button:SalesmanFilter]
    Key : Alt+S
    Action : Alter: SalesmanFilter
    Title : Contact Name

    [Report:SalesmanFilter]
    Form : SalesmanFilter
    [Form:SalesmanFilter]
    Part : SalesmanFilter
    No Confirmation : Yes

    [Part:SalesmanFilter]
    Line : SalesmanFilter

    [Line:SalesmanFilter]
    Field : Medium Prompt,SalesmanFilter
    Local : Field : Medium Prompt : Set as : "Select Contact Name: "

    [Field:SalesmanFilter]
    Table : ContactNameCollection,EndOfList
    ShowTable : Always
    Use : Name Field
    Width : 20
    Border : Thin Box
    Variable : vSalesManName
    Modifies : vSalesManName
    ; Variable : PQRPartySalesman
    ; Modifies : PQRPartySalesman

    ;[Collection: ContactNameCollection]
    ; ListName : "Raju"

    ;===================================== Collections ===================================

    [Collection: PQRSalesManVouchersColl]
    Type : Voucher
    Fetch : Date, VoucherNumber, VoucherTypeName,LedgerName,PartyLedgerName,VCHSalesmanName, LedgerEntries.*
    Filter : PQRSaleManVouchers , SalesManFilter


    [System:UDF]
    EnableSalesman : Logical : 1000
    Commission : Number : 1001

    [Variable:vSalesManName]
    Type : String

    ;[Variable:SalesManChqVar]
    ;Type : String

    [System:Variable]
    vSalesManName : ""
    ;SalesManChqVar : ""

    [System: Formula]
    PQRSaleManVouchers: $$IsSales:$VoucherTypeName OR $$IsCreditNote:$VoucherTypeName
    SalesManFilter : $VCHSalesmanName = ##vSalesManName Or $$IsSysName:##vSalesManName
     
    drive, Sep 18, 2018
    #5
    Jenny likes this.


  6. Jenny

    Jenny Active Member


    Untitled.jpg
    Thank you very much...its working.........and one thing after filter i showing that voucher press enter its showing all voucher; i want to only see that voucher which i have filtered
     
    Last edited: Sep 19, 2018
    Jenny, Sep 19, 2018
    #6


  7. drive

    drive Active Member


    ; Remove This Variable in Field & Display Option
    [Field: PQRPartyName]
    Variable: LedgerName
    Display : Ledger Vouchers



    Add : Option In Body Line
    [Line: PQRBody]
    Option : AlterVchOnEnter : Yes
     
    drive, Sep 19, 2018
    #7


  8. Jenny

    Jenny Active Member


    After changes its not working...its only showing entry voucher... Untitled1.jpg
     
    Last edited: Sep 19, 2018
    Jenny, Sep 19, 2018
    #8


  9. drive

    drive Active Member


    Simple
    Add : Field In Body Line
    [Line: PQRBody]
    DSP VchMasterIDNo
     
    drive, Sep 19, 2018
    #9
    Jenny likes this.


  10. Jenny

    Jenny Active Member


    One more Query....please solve this....Value not fetch.....
    Code:
    [Report: SmReport]
Use : DSP Template
Form : PQRReport
Title : "Quotation Report"
Set : SVFromDate : $$MonthStart:##SVCurrentDate
Set : SVToDate : $$MonthEnd:##SVCurrentDate
Variable : vSalesManName : String
Variables : ExplodeFlag, IsForexReport
Variable : DSPShowMonthly, DSPHasMultiLevel
Variable : IsMultiPage, InNewPages, ShowBillType, IsGrpBillReport
Set : vSalesManName : ""

[Form: PQRReport]
Use : DSP Template
Parts : PQRReport
Height : 100% screen
Width : 100% screen
Delete : Buttons: ExplodeFlag
Background: @@SV_RELEASEDLEAFGREEN_PL; Very Light Sea Green
Bottom Toolbar Buttons : BottomToolBarBtn1, BottomToolBarBtn6, BottomToolBarBtn7, BottomToolBarBtn8,

BottomToolBarBtn9, BottomToolBarBtn10, BottomToolBarBtn11, BottomToolBarBtn12,
Add: Button: Salesmanfilter

[Part: PQRReport]
Lines:PQRTitile,PQRBody
BottomLines : PQRBody Total
Repeat : PQRBody  :pQRSalesManVouchersColl
Scroll : Vertical
Total  :PQRPartyAmount

[Line: PQRTitile]
Use:PQRBody
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:"Quot No."
Local : Field : PQRPartyName : Set as: $$LocaleString:"Party Name"
Local : Field : PQRPartySalesMan: Set as: $$LocaleString:"Contact Name"
Local : Field : PQRPartyVchType : Set as: $$LocaleString:"Vch Type"
Local : Field : PQRPartyAmount : Set as: $$LocaleString:"Amount"
Border : Flush Totals

[Line: PQRBody]
Field:PQRSno, PQRPartyDate,PQRPartyVchNo,PQRPartyName,PQRPartySalesMan,PQRPartyVchType,DSP

VchMasterIDNo
RightField:PQRPartyAmount
Option : AlterVchOnEnter : Yes
Explode : MyExplodPart : ($$KeyExplode OR ##ExplodeFlag)

[Part : MyExplodPart]
    Lines        : JlLedger Bills Title, JlLedger Bills,ZJlEmptyLine
    Repeat        : JlLedger Bills : Ledger Bills
    Scroll        : Vertical
    Vertical    : Yes

[Line : ZJlEmptyLine]
Fields : Info Field
Local : Field : Info Field : Info : ""

[Line : JlLedger Bills Title]
    Line : JlLedger Bills Title1
[Line : JlLedger Bills Title1]

LeftFields : JLITEMTitle, JLQTYTitle, JLRATETitle, JLAmountTitle
Border    : Column Titles

Local : Field : JLITEMTitle  : Info : "JOB NAME"+$$NewLine
Local : Field : JLITEMTitle: Line  : 0
Local : Field : JLQTYTitle  : Info : "QTY"+$$NewLine
Local : Field : JLQTYTitle: Line  : 0
Local : Field : JLRATETitle  : Info : "RATE"+$$NewLine
Local : Field : JLRATETitle: Line  : 0
Local : Field : JLAmountTitle  : Info : "AMOUNT"+$$NewLine
Local : Field : JLAmountTitle: Line  : 0

[Field : JLITEMTitle]
Use: Short Name Field
Set as: "JOB NAME"
Style: Small bold
FullWidth : Yes
Align: Left
Border     : Thin Left
BackGround : Leaf Green

[Field : JLQTYTitle]
Use: Short Name Field
Set as: "QTY"
Style: Small bold
Width: 10
Align: Left
Border     : Thin Left
BackGround : Leaf Green

[Field : JLRATETitle]
Use: Short Name Field
Set as: "RATE"
Style: Small bold
Width: 10
Align: Left
Border     : Thin Left
BackGround : Leaf Green

[Field : JLAmountTitle]
Use: Short Name Field
Set as: "AMOUNT"
Style: Small bold
Width: 12
Align: Left
Border     : Thin Left
BackGround : Leaf Green

[Line : JlLedger Bills]       
LeftFields: JLITEM, JLQTY, JLRATE, JLAmount

[Field : JLITEM]
Use: Short Name Field
Set as: $StockItemName
Style: Small
FullWidth : Yes
Align: Left

[Field : JLQTY]
Use: Short Name Field
Set as:$BilledQty
Style: Small
Width: 10
Align: Left

[Field : JLRATE]
Use : Rate Price Field
Set as: $Rate
Style: Small
Width: 10
Align: Left

[Field : JLAmount]
Use : AmountField
Set as:$Amount
Style: Small
Width: 12
Align: Left


[Field:PQRSno]
Set as : $$Line
Width : 1.5 cm
Align : Center


[Field: PQRPartyDate]
Set as : $Date
Width : 10% Screen
Align : Right
;Style : Tiny


[Field: PQRPartyVchNo]
Set as : $VoucherNumber
Width : 10% Screen
Align : Center
;Style : Tiny


[Field: PQRPartyName]
Use : Name Field
Set as : $PartyLedgerName

Width : 20% Screen
Align : Left
;Style : Tiny


[Field: PQRPartySalesMan]
Use :Name Field
Set as : $$String:$MMSalesmanName

Width : 20% Screen
Align : Left
;Style : Tiny
;Key : Create SalesmanName

[Field: PQRPartyVchType]
Set as : $VoucherTypeName

Width : 15% Screen
Align : Left
;Style : Tiny

[Field: PQRPartyAmount]
Use : Amount Forex Field
Set as : $Amount

Width : 15% Screen
Align : Right
;Style : Tiny
Format : "No Zero,DrCr,Symbol," + ##ShowForex

[Line: PQRBody Total]
Use:PQRBody
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 : PQRPartyVchType : Set as: ""
Local : Field : PQRPartyAmount : Set as: $$Total:PQRPartyAmount
Border : Flush Totals

;============================== Filter ===================================

[Button:SalesmanFilter]
Key : Alt+S
Action : Alter: SalesmanFilter
Title : Contact Name

[Report:SalesmanFilter]
Form : SalesmanFilter

[Form:SalesmanFilter]
Part : SalesmanFilter
No Confirmation : Yes

[Part:SalesmanFilter]
Line : SalesmanFilter

[Line:SalesmanFilter]
Field : Medium Prompt,SalesmanFilter
Option : alter on enter
Local : Field : Medium Prompt : Set as : "Select Contact Name: "

[Field:SalesmanFilter]
Table : ContactNameCollection,EndOfList
ShowTable : Always
Use : Name Field
Width : 20
Border : Thin Box
Variable : vSalesManName
Modifies : vSalesManName
; Variable : PQRPartySalesman
; Modifies : PQRPartySalesman

;[Collection: ContactNameCollection]
; ListName : ""

;===================================== Collections ===================================

[Collection: PQRSalesManVouchersColl]
Type : Voucher
Fetch : Date, VoucherNumber, VoucherTypeName,LedgerName,PartyLedgerName,MMSalesmanName, LedgerEntries.*
Filter : PQRSaleManVouchers , SalesManFilter


[System:UDF]
EnableSalesman : Logical : 1000
Commission : Number : 1001

[Variable:vSalesManName]
Type : String

;[Variable:SalesManChqVar]
;Type : String

[System:Variable]
vSalesManName : ""
;SalesManChqVar : ""

[System: Formula]
PQRSaleManVouchers: $$IsSales:$VoucherTypeName OR $$IsCreditNote:$VoucherTypeName
SalesManFilter : $MMSalesmanName = ##vSalesManName Or $$IsSysName:##vSalesManName
    Untitled.jpg
     
    Jenny, Sep 20, 2018
    #10


  11. sivam

    sivam Active Member


    [Part : MyExplodPart]
    Lines : JlLedger Bills Title, JlLedger Bills,ZJlEmptyLine
    Repeat : JlLedger Bills : Inventory Entries
    Scroll : Vertical
    Vertical : Yes

    [Collection: PQRSalesManVouchersColl]
    Type : Voucher
    Fetch : Date, VoucherNumber, VoucherTypeName,LedgerName,PartyLedgerName,MMSalesmanName, LedgerEntries.*, InventoryEntries.*
    Filter : PQRSaleManVouchers , SalesManFilter
     
    sivam, Sep 21, 2018
    #11
    vinoth and Jenny like this.


  12. Jenny

    Jenny Active Member


    Untitled.jpg
    Thanx suppose i want to with Description also...what can i do?
     
    Jenny, Sep 21, 2018
    #12


  13. sivam

    sivam Active Member


    Add One more Explode in JlLedger Bills line and Repeat with BasicUserDescription
     
    sivam, Sep 21, 2018
    #13
    vinoth and Jenny like this.


  14. Jenny

    Jenny Active Member


    I create but its not showing......
    [Line : JlLedger Bills]
    LeftFields: JLITEM, JLQTY, JLRATE, JLAmount
    Explode : DESCExplod

    [Part : DESCExplod]
    Lines : JLDescription
    Repeat : JLDescription : BasicUserDescription
    Scroll : Vertical
    Vertical : Yes

    [Field : JLDescription]
    Use: Short Name Field
    Set as: $BasicUserDescription
     
    Jenny, Sep 21, 2018
    #14


  15. sivam

    sivam Active Member


    [Collection: PQRSalesManVouchersColl]
    Type : Voucher
    Fetch : Date, VoucherNumber, VoucherTypeName,LedgerName,PartyLedgerName,MMSalesmanName, LedgerEntries.*, InventoryEntries.*, InventoryEntries.BasicUserDescription.*
    Filter : PQRSaleManVouchers , SalesManFilter
     
    sivam, Sep 21, 2018
    #15
    vinoth and Jaya like this.


  16. Jenny

    Jenny Active Member


    Not showing
     
    Jenny, Sep 21, 2018
    #16


Share This Page