Salesman in Invoice

Discussion in 'Tally Developer' started by Kuber Mohindru, Dec 1, 2013.

    

  1. Dear Experts

    it got this code which adds salesman to the sales voucher. My problem is that I want to print the selected salesman in voucher to the Invoice print.


    ;; PRODUCT: Salesman TCP
    ;; PRODUCT-ID: 41b792af-aae9-4b29-963f-74c03d97410c

    [System: UDF]
    MyDBSalesman: Aggregate: 2
    SalesmanName: String: 1000
    Commission: Number: 1001

    [#Part: CMP AccFeat Left]
    Add: Line: CMP EnableSalesmanTable

    [Line: CMP EnableSalesmanTable]
    Field: Medium Prompt, CMP EnableSalesmanTable
    Local: Field: Medium Prompt: Info: "Enable Salesman ? "
    ;;Does not work in Tally ERP 9
    ;;Invisible: NOT $$MODAdvInventory or NOT $IsInvoicingOn
    Space Top: 1

    [Field: CMP EnableSalesmanTable]
    Use: Logical Field
    Storage: EnableSalesman
    Set as: If $$IsEmpty:$$Value then "No" else $$Value
    Sub Form: CMP SalesmanReport: $$Value = "Yes"

    [System: UDF]
    EnableSalesman: Logical: 1000

    [Report: CMP SalesmanReport]
    Form: CMP SalesmanForm

    [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: Long Prompt
    Local: Field: Long Prompt: Style: Small Bold
    Local: Field: Long Prompt: Info: "Salesman / Commission"

    [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 Salesman NameField,CMP Salesman CommissionField

    [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
    Title: Salesman

    [#Part: EI BaseInfo]
    Option: EI Salesman: $$IsSales:##SVVoucherType

    [!Part: EI Salesman]
    Add: Line: EI lnSalesman

    [Line: EI lnSalesman]
    Fields: Short Prompt, fldSalesman
    Local: Field: Short Prompt: Info: 'Salesman Name: '

    [Field: fldSalesman]
    Use: Short Name Field
    Storage: EI SalesmanName
    Width: 20
    Table: MySalesmanCollection
    ShowTable: Always

    [System: UDF]
    EI SalesmanName: String: 1100
     
    Arif Ali likes this.



  2. Can please somebody help me with it
     


  3. sayed

    sayed Member


    how i can use it
     


  4. Yogender

    Yogender Member


    check this file
     

    Attached Files:



  5. sayed

    sayed Member


    when i can see report salesman
     


  6. sayed

    sayed Member


    sir i have problem we are tally egypt
    i want in sales or purchases when i Choose ledger cash Auto is selected One of godown
    That's where we have more than changer and more than godown and each changer can use one godown in sales or purchases
    can u help me in this code
     


  7. sayed

    sayed Member


    my problem when i can salesman report
     


  8. Yogender

    Yogender Member


    send me full code
     


  9. sayed

    sayed Member


    ;; PRODUCT: Salesman TCP
    ;; PRODUCT-ID: 41b792af-aae9-4b29-963f-74c03d97410c

    [System: UDF]
    MyDBSalesman: Aggregate: 2
    SalesmanName: String: 1000
    Commission: Number: 1001

    [#Part: CMP AccFeat Left]
    Add: Line: CMP EnableSalesmanTable

    [Line: CMP EnableSalesmanTable]
    Field: Medium Prompt, CMP EnableSalesmanTable
    Local: Field: Medium Prompt: Info: "Enable Salesman ? "
    ;;Does not work in Tally ERP 9
    ;;Invisible: NOT $$MODAdvInventory or NOT $IsInvoicingOn
    Space Top: 1

    [Field: CMP EnableSalesmanTable]
    Use: Logical Field
    Storage: EnableSalesman
    Set as: If $$IsEmpty:$$Value then "No" else $$Value
    Sub Form: CMP SalesmanReport: $$Value = "Yes"

    [System: UDF]
    EnableSalesman: Logical: 1000

    [Report: CMP SalesmanReport]
    Form: CMP SalesmanForm

    [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: Long Prompt
    Local: Field: Long Prompt: Style: Small Bold
    Local: Field: Long Prompt: Info: "Salesman / Commission"

    [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 Salesman NameField,CMP Salesman CommissionField

    [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
    Title: Salesman

    [#Part: EI BaseInfo]
    Option: EI Salesman: $$IsSales:##SVVoucherType

    [!Part: EI Salesman]
    Add: Line: EI lnSalesman

    [Line: EI lnSalesman]
    Fields: Short Prompt, fldSalesman
    Local: Field: Short Prompt: Info: 'Salesman Name: '

    [Field: fldSalesman]
    Use: Short Name Field
    Storage: EI SalesmanName
    Width: 20
    Table: MySalesmanCollection
    ShowTable: Always

    [System: UDF]
    EI SalesmanName: String: 1100​
     


  10. sayed

    sayed Member


    i cant display any report pls tell me where is reports to Salesman and Commission
     


  11. nagaraju

    nagaraju New Member


    salesmen is not showing in the invocie
     


  12. Yogender

    Yogender Member


    you have to create tdl for this report
     


  13. sayed

    sayed Member



  14. Yogender

    Yogender Member


    make your own u r a developer
     



  15. Dear,
    1- see my given code, it will add sales man and mobile no in F11 form
    2- in voucher screen it shows table and also see in print format it prints

    i have not done anything to get report as salesmanwise sales
    i think we must # collection of vouchers , and add fetch : sales man name
    then by our own coding new collection and sort by salesman

    if u got it pl reply
    regards
    mithari
    9325509009
     

    Attached Files:

    • new.txt
      File size:
      11.2 KB
      Views:
      365


  16. nagaraju

    nagaraju New Member


    sir salesmen is comming but sales invocie is printing in pre printed format
     



  17. dear,
    the code is sample
    it was developed for one client for preprinted format
    if you want to use same code of slesman for your plain or default format then please do-
    1- delete unusable code of preprinted format and keep only sales man code then
    2-# your compreesive invoice , and alter / add any part in your invoice and add the salesman line which i added on sales voucher form ( in code0
    thats it.
    as a developer you have to do changes as u want
    regards
    mithari
     


  18. rony

    rony Member


    Dears,
    Thanks the forum so many TDL experts and members are sharing salesman Tdls, But salesman comm is not posting in the salesman account, I tried so much but allocation, No. Can any one help,
    Thanks
     


  19. Vivek Mehta

    Vivek Mehta New Member



    Can i get salesmanwise sales & outstanding report txt or TDL code?
     


Share This Page