More Field in Single Line

Discussion in 'Requests' started by rony, Feb 29, 2016.

    
  1. rony

    rony Member


    I have created TDL for Salesman field in invoice but it comes in 2 lines. I want in single line like :
    Salesman Name : ------ Comm% : -------- Amount : ------
    and it has been credit in concern salesman account directly from invoice Please Help and guide. My code
    ;---------------add salesman details in invoice-------------;


    [#Part: EI BaseInfo]

    Option: EI Salesman1: $$IsSales:##SVVoucherType

    [!Part: EI Salesman1]

    Add: Line: EI lnSalesman1 , EI Comm1

    [Line: EI lnSalesman1]

    Fields: Short Prompt,fldSalesman1

    Local: Field: Short Prompt: Info: 'Salesman Name'
    Local : Field : fldSalesman1 : Preprinted: Yes

    [Line : EI Comm1]
    Add: Field: EI Comm1
    Add: Field: EI Comm2

    [Field : EI Comm1]

    Use : Short Prompt
    Info:"Comm %"
    Width :10
    Preprinted: Yes

    [Field: fldSalesman1]

    Use: Short Name Field
    Storage: EI SalesmanName
    Width: 20
    Table: MySalesmanCollection,endoflist
    ShowTable: Always


    [Field: EI Comm2]
    Use: Name Field
    Storage: EI commission1
    Width: 10
    Table: MycommCollection, endoflist
    ShowTable: Always


    [System: UDF]
    EI SalesmanName1: String: 1100

    [System: UDF]
    EI commission1 : string: 1200


    ;----------End salesman name-------
     


  2. admin

    admin Administrator Staff Member


    chaNge code line this:

    [#Part: EI BaseInfo]

    Option: EI Salesman1: $$IsSales:##SVVoucherType

    [!Part: EI Salesman1]

    Add: Line: EI lnSalesman1

    [Line: EI lnSalesman1]

    Fields: Short Prompt,fldSalesman1
    Field: EI Comm1,EI Comm2

    Local: Field: Short Prompt: Info: 'Salesman Name'
    Local : Field : fldSalesman1 : Preprinted: Yes
     


  3. rony

    rony Member


    Thank U Very very much. But how to credit same comm directly from invoice. Please Help.
    I have created 'salesman' group as indirect exp and the salesman account under the same group but invoice ledger entry for comm is not coming.
     


  4. rony

    rony Member


    Dear Sir ,
    I am adding Old balance and current bill in invoice and code are given below but in that
    1 ) old balance amount is coming but colour in dr amount red and in cr amount green is not changing even though i insert condition .
    2) In currunt invoice field g. total amount is not coming, I tried $$amount but that is net amount and not the g. total .
    Pl help in this problem
    Regards.

    [Field : Name Field1]
    Use : ShortPrompt
    Set As : "OLD BALANCE"
    PrePrinted : Yes
    Width : 25% Page
    Style : Normal
    Print FG : Blue
    Colour : Blue

    [Field : Name]
    Use : Amount Forex Field
    set as : $ClosingBalance:Ledger:$PartyLedgerName - $Amount
    Preprinted : Yes
    Width : 15% Page
    Style : NormalBold
    Print FG : Red
    Colour : IF $ClosingBalance Dr then Red else Green
    Format : "Symbol,DrCr"

    [Line: Billamt]

    Fields:Billamt1
    Spce Top : 0.50

    [Field: Billamt1]
    Field : Short Prompt, Amount Field
    Local : Field : Short Prompt : Info :$$LocaleString:"BILL AMOUNT"
    Local : Field : Short Prompt : Width : 21.5
    Local : Field : Amount Field : Set as : #EXRPNVINVTotal
    Local : Field : Amount Field : Format : "Symbol,DrCr"
     


  5. rony

    rony Member


    Is there any one to help please.
     


Share This Page