Need Help to Fetch Broker Name from Sales Order in Sales Invoice

Discussion in 'Tally Developer' started by Anshul Garg, Sep 29, 2019.

    
  1. Anshul Garg

    Anshul Garg Member


    i am working on Broker Module where Broker is added in the Sales Order. And When we are doing sales of that order no Broker name should come. Please Review my code. I am unable to fetch that broker name . All the files of code is attached



    [#Field: VCHBATCH BilledQty]


    Background:red
    Color:blue

    [#Line: STKVCH Batch2]
    ;Right Fields: VCHBATCH Godown, VCHBATCH Name,+
    ; VCHBATCH ActualQty, VCHBATCH BilledQty,VCHBATCH ClosureInv,VCHBatch PreClsBalance, VCHBATCH Closure, VCH OrderClosureDate, VCH RateIncl, VCHBATCH Rate, VCHBATCH RateUnits, VCHBATCH ItemRate, VCHBATCH Discount, VCHBATCH ItemDiscount, VCHBATCH Value, VCHBATCH AddlValue
    Add:Right Field:After:VCHBATCH BilledQty:VCHBroker


    [Field:VCHBroker]
    Use : Name Field
    Width : 15
    Set always : Yes
    Set as:$SalesOrderBroker

    [system : Formula]
    Rightreference:$Reference=$OrderNo

    [collection : asssalesordersrc]
    Type : vouchers : vouchertype
    child of : $$vchtypesalesorder
    Belongs to : yes
    ;Fetch : voucherNumber, Date, Reference, inventoryentries,SalesOrderBroker, accountingentries
    Filter : Rightreference
     

    Attached Files:



  2. Anshul Garg

    Anshul Garg Member


    PLease help me . Anyone please help
     


  3. velan

    velan New Member


    try this
    [Field:VCHBroker]
    Use : Name Field
    Width : 15
    Set always : Yes
    Set as:$SalesOrderBroker:Ledger:$PartyLederName
     


Share This Page