Add Buyer Name & Buyer address in Sales Columnar report.

Discussion in 'Requests' started by gaurav.ldh, Apr 26, 2016.

    
  1. gaurav.ldh

    gaurav.ldh New Member


    dear sir,

    i have seen that there are very expert in tally, i need actual buyer name and address in tally sales columnar report.
    can you help me to add this column.

    i have created a tdl for buyer name and address. but i am unable to add these feilds in sale report.

    plz help

    thanks in advance.
     


  2. admin

    admin Administrator Staff Member



  3. gaurav.ldh

    gaurav.ldh New Member


    Respected Sir,

    I have tried a lot, but the code given in that specific post is dead, that does not work. it's giving error, plz check and make it correct, so that i can furthre change it according to my needs.
     


  4. ldharjani

    ldharjani New Member


    [#Part: CMP COLBasics]
    Add : Line:AtEnd: JVVShow RefDate

    [Line : JVVShow RefDate]
    Fields : Medium Prompt,JVVShow RefDate
    Local : Field : Medium Prompt : Info : $$LocaleString:"Show DespatchThru ?" ;;; String displayed Columnar Register Configuration

    [Field: JVVShow RefDate]
    Use : Logical Field
    Modifies: TDLeXpertsShowDespatchThru

    [Variable: TDLeXpertsShowDespatchThru]

    Type : Logical
    Persistent : Yes

    [System : Variable]
    TDLeXpertsShowDespatchThru:""


    [#Line : DSP ColVchTitle]


    Add : Fields : After : DBC VchNo : TDLeXperts DespatchThru

    Local : Field : Default : Style : Small Italic

    Local : Field : TDLeXperts DespatchThru : Set As : "DespatchThru"

    [#Line : DSP ColVchDetail]

    Add : Field : After : DBC VchNo: TDLeXperts DespatchThru

    [Field : TDLeXperts DespatchThru]

    Use : Name Field
    SetAs :$BasicShippedBy; $TDLeXpertsVCHDespatchThru
    Width : 13% Page
    Border : Thin Left
    Style : Small
    Invisible : NOT ##TDLeXpertsShowDespatchThru


    [#Line : DSP ColVchTotal]
    Add : Field : After : DBC VchNo : TDLeXperts SalesEmpty
    Local : Field : TDLeXperts DespatchThru : Invisible : Yes

    [Field : TDLeXperts SalesEmpty]
    Use : Name Field
    SetAs : ""
    Width : 13% Page

    [#Collection : Columnar Filtered Vouchers of Company]
    Fetch : TDLeXpertsVCHDespatchThru

    [#Collection: Columnar Vouchers of Ledgers]
    Fetch : TDLeXpertsVCHDespatchThru
     


  5. NAGARAJKMAR SUBRAMANIAN

    NAGARAJKMAR SUBRAMANIAN Active Member


    ;;;;;;;;; Code to Display Buyername & Address in Columnar Sales Register;;;;;;;;;;;;;;
    ;;;-----------------------------------------------------------------------------------;;;;;;;;;;;;;;;;;;;;;


    [#Line: DSP ColVchDetail]
    Add : Explode : BuyeraddressPart : $$KeyExplode OR ##ExplodeFlag

    [Part : buyer AddressPart]
    Line : BuyeraddressLine
    Repeat : Buyeraddressline : MyBuyeraddressColl

    [Line : BuyerAddressLine]
    Field : BuyerAddressFld

    [Field : BuyerAddressFld]
    Set as : $Address
    Space Left : 8

    [Collection : Buyeraddresscoll]
    Type : Ledger
    Filter : ChkPartyName
    Fetch : Name

    [Collection : MyBuyerAddresscoll]
    Source Collection : BuyerAddresscoll
    Walk : Address
    By : Address : $Address

    [System : Formula]
    Chkpartyname : $Name = #DBCParty
     


  6. Rajsrisrimal

    Rajsrisrimal Member


    Sir how to show actual Qty in columnar register
     


  7. surehs

    surehs New Member


    Hi, Gaurav,
    i am not a developer but m looking for the same addon, can you please share a working one with me on hiranisur@gmail.com
     


Share This Page