Display Buyer Name and Buyer Address in Columnar Sales Register

Discussion in 'Free Source Codes' started by mehul2cyahoo, Jul 2, 2021.

    
  1. mehul2cyahoo

    mehul2cyahoo New Member


    Only Blank values in Sales Register, Can anyone guide how to get Buyer name and address in below code?

    [#Line : DSP ColVchTitle]
    Add : Fields : After : DBC VCHType : EI PartyMailingName
    Add : Fields : After : DBC VchNo : EI PartyAddress
    Local : Field : Default : Style : Small Italic
    Local : Field : EI PartyMailingName : Set As : "Buyer Name"
    Local : Field : EI PartyAddress : Set As : "Buyer Address"
    [#Line : DSP ColVchDetail]
    Add : Field : After : DBC VCHType: EI PartyMailingName
    Add : Field : After : DBC VchNo: EI PartyAddress
     


  2. Bipin Damania

    Bipin Damania Active Member


    Already there in Default Tally Columnar Report...

    You have added Line ... Where is Field...?
     


  3. Neeru

    Neeru Active Member


    collection in missing, use collection for fatch value in sales reg.
     


  4. mehul2cyahoo

    mehul2cyahoo New Member


    thanks for pointing in right direction, have added filed in above code as below

    Code:
    [Field    :  PartyName]
                Use        : Name Field
                SetAs     : $PartyName
                Width    : 13% Page
                Border    : Thin Left 
                Style    : Small
               
    [Field    :  PartyAddress]
                Use        : Name Field
                SetAs     : $PartyAddress
                Width    : 13% Page
                Border    : Thin Left 
                Style    : Small
     


  5. mehul2cyahoo

    mehul2cyahoo New Member


    Thank you, have added collection in above code as below

    Code:
    [#Collection    : Columnar Filtered Vouchers of Company]
        Fetch    : PartyName
        Fetch    : PartyAddress
    
    [#Collection: Columnar Vouchers of Ledgers]
        Fetch    : PartyName
        Fetch    : PartyAddress
    
     
    Neeru likes this.


  6. mehul2cyahoo

    mehul2cyahoo New Member


    Now the code is working as below:-
    Code:
    [#Line : DSP ColVchTitle]
    Add : Fields : After : DBC VCHType : PartyName
    Add : Fields : After : PartyName : PartyAddress
    Local : Field : PartyName : Set As : "Buyer Name"
    Local : Field : PartyAddress : Set As : "Buyer Address"
    
    [#Line : DSP ColVchDetail]
    Add : Field : After : DBC VCHType: PartyName
    Add : Field : After : PartyName: PartyAddress
    
    
    [Field    :  PartyName]
                Use        : Name Field
                SetAs     : $PartyName
                Width    : 13% Page
                Border    : Thin Left 
                Style    : Small
               
    [Field    :  PartyAddress]
                Use        : Name Field
                SetAs     : $PartyAddress
                Width    : 13% Page
                Border    : Thin Left 
                Style    : Small
    
    [#Collection    : Columnar Filtered Vouchers of Company]
        Fetch    : PartyName
        Fetch    : PartyAddress
    
    [#Collection: Columnar Vouchers of Ledgers]
        Fetch    : PartyName
        Fetch    : PartyAddress
    
     


Share This Page