Dear All, i am creating new TDL for fetching sales and purchase voucher details., but the problem is i can't display item description in my field., here i attached my screen for your reference., please anyone get idea for this share with me., and here is my TDL [#Menu:GatewayofTally] Add:Item:Voucher Listisplay:Voucher List [Report:Voucher List] Form:Voucher Form Title:"Voucher List" [Form:Voucher Form] UseSP Template Parts:Voucher Part Button:Invoice Btn Width:100% Screen Height:100% Screen Background:Grey [Part:Voucher Part] Lines:Voucher Title,Voucher Line Repeat:Voucher Line:Voucher Details Common Border:Yes Scroll:Vertical [Line:Voucher Title] Use:Voucher Line Local:Fieldefault:Type:String Local:Fieldefault:Align:Center Local:Fieldefault:Style:Normal Bold Local:Field:Voucher Date:Set as:"Date" Local:Field:Invoice No:Set as:"Invoice No" Local:Field:Bill No:Set as:"Bill No" Local:Field:Voucher Party:Set as:"Customer/Buyer" Local:Field:Item:Set as:"Item Name" Local:Fieldescription:Set as:"Desc" Local:Field:Voucher Type:Set as:"Voucher Type" Local:Field:Voucher No:Set as:"V.No" Local:Field:Amount:Set as:"Amount" Border:Thin Top Bottom [Line:Voucher Line] Fields:Voucher Date, Invoice No, Bill No, Voucher Party,Item,Description, Voucher Type, Voucher No, Amount Option:AlterOnEnter [Field :Voucher Date] Use : Short Date Field Set As : $Date Border:Thin Right Width:10 Alter:Voucher Align:Center [Field:Invoice No] Use:Name Field Set as:$Reference Border:Thin Right [Field:Bill No] Use:Name Field Set as:$Narration Border:Thin Right [Field : Voucher Party] Use : NAme Field Set As : $PArtyLedgerName Border:Thin Right [Field:Item] Use:Name Field Set as:$StockItemName Border:Thin Right [Fieldescription] Use:Name Field Set as:$Description Border:Thin Right [Field : Voucher No] Use : NAme Field Set As : $VoucherNumber Border:Thin Right Align:Center Width:10 [Field :Voucher Type] Use : Name Field Set As : $VoucherTypeName Border:Thin Right [Field : Amount] Use : Amount Field Set As :$Amount Format : "CRDR" [Button:Invoice Btn] Key:Alt+I Action:Execute:Invoice Rpt Title:Find Invoice [Report:Invoice Rpt] Form:Invoice Frm Title:Find Invoice Filter:$Reference [Form:Invoice Frm] Part:Invoice Prt Add : On : Form Accept : yes : Action:Alter:Voucher [Part:Invoice Prt] Line:Invoice Ln [Line:Invoice Ln] Field:Medium Prompt, Invoice Fld Local:Field:Medium Prompt:Set as:"Select Invoice No" Option: AlterOnEnter : $$IsVoucher [Field:Invoice Fld] Table:Invoice Col Show Table:Always Use:Name Field Width:50 Border:Thin Box Alter:Voucher Option: AlterOnEnter : $$IsVoucher [Collection:Invoice Col] Type:Vouchers Belongs To:Yes Format:$Reference Option:AlterOnEnter [Collection:Voucher Details] Collection:cre col, deb col [Collection:cre col] Type : Vouchers Belongs To:Yes Fetch : Date,Amount,Reference,UserDescription,VoucherTypeName,PArtyLedgerName,VoucherNumber,StockItemName,Narration,Description [Collection: deb col] Type : Description : StockItem Child of : #VCHStockItem [System: UDF] Description : String : 20001
;;------------------------ Give Like this [Field : Description] Use:Name Field Set as : $Description:StockItem:$StockItemName Border:Thin Right
Mr Lokesh is right and one more suggestion that you need to add filter of Sales & Purchase vouchers bcoz its showing all and also period as by default it is showing of the whole year. For Eg .: [System: Formula] OnlySalesPurchase : $$IsSales:$VoucherTypeName OR $$IsCreditNote:$VoucherTypeName OR $$IsPurchase:$VoucherTypeName OR $$IsDebitNote:$VoucherTypeName add the above filter in your collections and secondly add Variables as follows :- Variable : SVFromDate,SVToDate Set : SVFromDate : $$MonthStart:##SVFromdate Set : SVToDate : $$MonthEnd:##SVFromdate
if i entered default description for an item in stock creation it'll work fine., but in voucher i entered that description manually., so that only it will not display., is there any solution for this?
Try This [Line:Voucher Line] Fields:Voucher Date, Invoice No, Bill No, Voucher Party,Item,Description, Voucher Type, Voucher No, Amount Option:AlterOnEnter Explode : MYDesc [Part : MyDesc] Line : MyDesc Repeat MyDesc : UserDescription [Line : mydesc] Field : mydesc [Field : mydesc] Use : Name field set as : $BasicUserDescription
Try This [Field escription] Set as : $$CollectionField:$BasicDesc:1:InventoryEntries Add this Line in your tdl and [#Object : InventoryEntry] BasicDesc : $$CollectionField:$BasicUserDescription:1:BasicUserDescription
[Field escription] Set as : $$CollectionField:$BasicDesc:1:InventoryEntries Add this Line in your tdl and [#Object : InventoryEntry] BasicDesc : $$CollectionField:$BasicUserDescription:1:BasicUserDescription This Code is Working Fine on Tally Erp 9 4.9
This code is not working in 4.91.. Please tell how to add new column of Item Description in Columnar Sales Register.
Set AS : $$FullList:BasicUserDescription:$BasicUserDescription and [Collection:cre col] Type : Vouchers Belongs To:Yes Fetch : Date,Amount,Reference,UserDescription,VoucherTypeName,PArtyLedgerName,VoucherNumber,StockItemName,Narration,Description Fetch : BasicUserDescription.*
Hi to all, so nice to see the participation and enthusiasm of all in coming up with solution to make the final product an excellent one. This is a proof of 'Distributed Family' and I specially thank, as one among you, for the display of encouragement to the new comers as well as seasoned members that they are not alone when it come to assistance and refinement of Tally. Bye
Dear All can it possible ,when purchase any Item and wrote in (description) , then if i sales the same item show description table in sales voucher please help sir
do this , its working proper [Fieldescription] Use:Name Field Set as:$BasicDesc Border:Thin Right [#Object : voucher] BasicDesc : $inventoryentries[1].basicuserdescription[1].BasicUserDescription
Now try to fetch all items with all descriptions of each item. its not so dificult if try well with oassociation logic