New Column in Invoice and Sales register

Dear Experts

I am a learner. After getting few reference tdl's from this site from experts,
I tried to make one change in invoice column for my requirement. I need a column in invoice "agreed rate" before the quantity column of sales/purchase invoice and the stored data
in that invoice to be shown in purchase/sales register. The tdl works in invoice portion but not in Purchase/sales register.
I would be thankful if you can able to view tdl and correct the error.. thanks

Code:

[#Line : EI Column One]
Add : Right Fields: Before : VCH QtyTitle : Aratea

[#Line : EI Inv Info] ;; Inventory Repeat Line - - With out Class
Add : Right Fields: Before : VCH BilledQty : arateb

[#Line : CI Inv Info] ;; Inventory Repeat Line - - With Class
Add : Right Fields: Before : VCH BilledQty : Arateb


[Field : Aratea]
Use : Name Field
Width : 10
Skip : Yes
Set As : "Agreed Rate"
Align: Centre
Invisible : NOT @@ISSale or Not @@ISPurchase
Style:Normal bold
Border: Thin Left : $$InPrintMode


[Field : Arateb]
Use : Name Field
Set as: $arateno
Storage: arateno

Scroll: Vertical
Width : 10
Align: Centre
Invisible : NOT @@ISSale or Not @@ISPurchase
Skip: No
Border: Thin Left : $$InPrintMode



[System:UDF]

arateno : string:1888


[#Part: CMP COLBasics]
    Add        : Line:AtEnd: JVVShow RefDate
   
    [Line    : JVVShow RefDate]
        Fields      : Medium Prompt,JVVShow RefDate 
        Local       : Field : Medium Prompt : Info      : $$LocaleString:"Show Agreed Rate ?"        ;;; String displayed Columnar Register Configuration

        [Field: JVVShow RefDate]
            Use     : Logical Field
            Modifies: ratecol 
           
[Variable: ratecol]

    Type        : Logical
    Persistent  : Yes
   
[System    : Variable]
    ratecol:""



[#Line    : DSP ColVchTitle]
   
    Add    : Fields    : After : DBC VchNo    : agreedrate
   
    Local    : Field    : Default : Style    : Small Italic
   
    Local    : Field    : agreedrate    : Set As    : "Agreed Rate"
   
[#Line    : DSP ColVchDetail]

    Add    : Field    : After    : DBC Qty: agreedrate
   
        [Field    : agreedrate]
           
            Use        : Name Field
            SetAs     : $arateno
            Width    : 13% Page
            Border    : Thin Left 
            Style    : Small
            Invisible   : NOT ##ratecol
           
       
       
[#Line    : DSP ColVchTotal]
    Add        : Field    : After    : DBC VchNo    : PreEmpty
    Local    : Field    : agreedrate    : Invisible    : Yes
   
    [Field    : PreEmpty]
        Use        : Name Field
        SetAs    : ""
        Width    : 13% Page
       
[#Collection    : Columnar Filtered Vouchers of Company]
    Fetch    : arateno
   
[#Collection: Columnar Vouchers of Ledgers]
    Fetch    : arateno

 

Dear Suresh,

Try This

[#Collection : Columnar Filtered Vouchers of Company]
Fetch : InventoryEntries. arateno

[#Collection: Columnar Vouchers of Ledgers]
Fetch : InventoryEntries. arateno

 

Thank you very much sir, it is working perfectly...

 

plz help me

not working Buyers name and address

 

Hi Sir, I have used your code and did some modification of UDF fields. Im unable to fetch the data. Please provide me corrected code.

[#Line : EI Column One]
Add : Right Fields: Before : VCH QtyTitle : Aratea

[#Line : EI Inv Info] ;; Inventory Repeat Line - - With out Class
Add : Right Fields: Before : VCH BilledQty : arateb

[#Line : CI Inv Info] ;; Inventory Repeat Line - - With Class
Add : Right Fields: Before : VCH BilledQty : Arateb


[Field : Aratea]
Use : Name Field
Width : 10
Skip : Yes
Set As : "Agreed Rate"
Align: Centre
Invisible : NOT @@ISSale or Not @@ISPurchase
Style:Normal bold
Border: Thin Left : $$InPrintMode


[Field : Arateb]
Use : Name Field
Set as: $arateno
Storage: arateno

Scroll: Vertical
Width : 10
Align: Centre
Invisible : NOT @@ISSale or Not @@ISPurchase
Skip: No
Border: Thin Left : $$InPrintMode



[System:UDF]

arateno : string:1888


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

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

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

[Variable: ratecol]

Type : Logical
Persistent : Yes

[System : Variable]
ratecol:""



[#Line : DSP ColVchTitle]

Add : Fields : After : DBC VchNo : agreedrate

Local : Field : Default : Style : Small Italic

Local : Field : agreedrate : Set As : "Agreed Rate"

[#Line : DSP ColVchDetail]

Add : Field : After : DBC Qty: agreedrate

[Field : agreedrate]

Use : Name Field
SetAs : $arateno
Width : 13% Page
Border : Thin Left
Style : Small
Invisible : NOT ##ratecol



[#Line : DSP ColVchTotal]
Add : Field : After : DBC VchNo : PreEmpty
Local : Field : agreedrate : Invisible : Yes

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

[#Collection : Columnar Filtered Vouchers of Company]
Fetch : InventoryEntries. arateno

[#Collection: Columnar Vouchers of Ledgers]
Fetch : InventoryEntries. arateno


Thanks,
Anbhu.

 

dear sir,
please what is code use for columnr sale register to show hsn code

 

https://tallysolutions.com/tallyweb/modules/sd/docmgmt/CMktPlaceHomepageWIC.php

Sir help me this add-on file download

 

Hello
Plz what is code use for sales invoice to show item alias