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
Kinldy search forum before you post the query. Solution for this query is already posted. Please search.
Dear Suresh, Try This [#Collection : Columnar Filtered Vouchers of Company] Fetch : InventoryEntries. arateno [#Collection: Columnar Vouchers of Ledgers] Fetch : InventoryEntries. arateno
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.
https://tallysolutions.com/tallyweb/modules/sd/docmgmt/CMktPlaceHomepageWIC.php Sir help me this add-on file download