help on retrieving Sales Man Name

Discussion in 'Tally Developer' started by Johar, Jun 2, 2021.

    
  1. Johar

    Johar Member


    In my custom report cam unable to get salesman name, can you please help me out.

    [Collection: SD Report Items]

    Source Collection : SD Report
    Walk : Inventory Entries
    By : VNo : $VoucherNumber
    By : StockItem : $StockItemName
    Compute : ptyname : $PartyName
    Aggr Compute : BQty : Sum: $BilledQty
    Compute : Disc : $Discount
    Aggr Compute : Value : Sum: $Amount
    Compute : Date : $Date
    Compute : SMName : $VCHsalesman


    [Collection: SD Report]

    Type : Vouchers : VoucherType
    Child Of : $$VchTypeSales
    Belongs To : Yes
    Fetch : InventoryEntries.*,VoucherNumber,VCHsalesman
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Where are you inputting the SALESMAN value/udf ???? And in which Report??
     


  3. Johar

    Johar Member


    I am creating in Sales Voucher, then I wanted salesman name in my custom report but I am unable to get that name, Plz help..
     


  4. Johar

    Johar Member


    [Line: EI Salesman Det]
    Field : Medium Prompt, EI Salesman Det
    Local : Field : Medium Prompt : Set as : "Salesman Name : "

    [Field: EI Salesman Det]
    Use : Short Name Field
    Table : CMP Salesman, Not Applicable
    Show Table : Always
    Storage : VCHSalesman

    [System: UDF]
    VCHSalesman : String : 9010
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    My Friend....better if you post a screenshot with the placement of your FIELD....

    In your collection you are walking... Inventory Entries............ is it within the Sub-Object collection Inventory Entries ???

    Try..... $LedgerEntries.VchSalesman ...........

    Also try to objectify your UDF in [#Object : voucher]
     


  6. balajimg

    balajimg Active Member


    in collection you have written
    Compute : SMName : $VCHsalesman

    where it is walking over "inventory entries"
    but i understand that sales man is above inventory entries
    so write it like this
    Compute : SMName : $$Owner:$VCHsalesman
     


  7. Johar

    Johar Member


    Thankyou Amit Sir & Balajimg Sir, my problem got solved ....
     


Share This Page