dear experts, i required to increase the table size of list of ledgers accounts. Please help me. [#Field:voucher register] WIDTH:45
Go and find the FIELD --- EI Consignee ......... In that there will be 2 tables.... based on condition........which is simple to understand.....and only one is applicable to you......... Ctrl+Click on the Table/Collection Name .......and so on try to find the BASE Table/Collection........ Refer to that Table using the modifier symbol and add the following line....... Delete : Format Add : Format : $$Name, 50 Now, how to find which the correct one is....... simple....in all the Table/Collection there will be a TITLE.....Temporary add some characters and if that appears in your screen, then it is the correct one.........
Dear Amit sir, thank u very much for answering and giving solution to the query . well explained with details. also u showed me the output screenshot. Great sir..
d Dear Bipin sir, u r in all places related to tdl class. even i too look your comments & post. example: macrolix, learwell, mothercare etc.. good going sir...
Go and find the FIELD --- EI Consignee ......... In that there will be 2 tables.... based on condition........which is simple to understand.....and only one is applicable to you......... Ctrl+Click on the Table/Collection Name .......and so on try to find the BASE Table/Collection........ Amit sir, nothing is happening when pressing ctrl+click while running tally in developer mode .
Ctrl+Click works in DEVELOPER....not Tally....... When you go in Developer and find the Field -- EI Consignee...and then follow rest of my instructions.
dear Amit sir, thanks for the code. but i am not able to learn myself. please help me me how did you find out the [#Collection: VLedTable] while searching Ei consignee. kindly guide me how to search the required table/collection...
Please read my previous comment...I have already guided you......... Look at the photo - you have attached .... there are 2 tables........ Ctrl+Click on that TABLE name will take you there..... Then examine that collection......find out what is the common thing they are USING....... Try it.......
[Collection: ServerSalesIncome Ledgers] Use : VLedTable Collection : Sales Support Ledgers, Sales Income Ledgers [Collection: ServerPurchaseExpense Ledgers] Use : VLedTable Collection : Purchase Support Ledgers, Purchase Expense Ledgers is this correct sir,
In above..... Notice........ Use : VledTable....... means all these collections are using a common Collection wherein all the fundamentals have been defined...... In above two collection, one is pertaining to Sales-related and other is Purchase-related. All of them use the common VLedTable.
PLEASE HELP WITH THIS COADING FOR TALLY PRIME [#Collection : VLedTable] Option : EnhancedNewVLedTable [!Collection : EnhancedNewVLedTable] Title : $$LocaleString:"LIST OF LEDGERS" Delete : Format Add : Format : $$Name,30 Add : Format : $Parent,22 Add : SubTitle : "LEDGER NAME", "GROUP NAME" [#Collection : List of Ledgers] Option : EnhancedNewListofledgers [!Collection : EnhancedNewListofledgers] Title : $$LocaleString:"LIST OF LEDGERS" Delete : Format Add : Format : $$Name,35 Add : Format : $Parent,22 ;Add : Format : $Description,15 Add : Format : $IncomeTaxNumber,10 ;Add : Format : $Closingbalance,9 Add : SubTitle : "LEDGER NAME","GROUP NAME","PAN" [#Collection : List of Groups] Option : EnhancedNewListofGroups [!Collection : EnhancedNewListofGroups] Title : $$LocaleString:"LIST OF GROUPS" Delete : Format Add : Format : $$Name,50 Add : SubTitle : "GROUP NAME" [#Collection : List of Stock groups] Option : EnhancedNewListStockgroups [!Collection : EnhancedNewListStockgroups] Title : $$LocaleString:"LIST OF STOCK GROUPS" Delete : Format Add : Format : $$Name,50 Add : SubTitle : "STOCK GROUP NAME" [#Collection : List of Stock Items] Option : EnhancedNewListStockItems [!Collection : EnhancedNewListStockItems] Title : $$LocaleString:"LIST OF STOCK ITEMS" Fetch:GSTIGSTRate Fetch:GSTHSNCode Fetch:mrprate,MRPDetails[Last].MRPRateDetails[Last].MRPRate Delete : Format Add : Format : $Name,35, ;Add : Format : $OnlyAlias,25, ;Add : Format : $Partno,10, ;Add : Format : $GSTIGSTRATE,8, ;Add : Format : $GSTHSNCode,8, ;Add : Format : $ClosingBalance,20, ;Add : Format : $MRPDetails[Last].MRPRateDetails[Last].MRPRate,12, ;Add : Format : $STANDARDCOST,15 Add : Subtitle : "Stock Item Name";,"Part No", "CL. QTY","MRP",;"Sale Price","GST %","HSN/SAC", [#Collection : List of Cost Centres] Option : EnhancedNewListcostcentres : @@IsMyLocalTDLModuleOn [!Collection : EnhancedNewListcostcentres] Title : $$LocaleString:"LIST OF COST CENTRES" Delete : Format Add : Format : $$Name,80 Add : SubTitle : "COST CENTRE NAME" [#Line : EI InvInfo] Local : Field : VCH Stockitem : Width: 30% Screen [#Field : Master Name Field] Option : EnhancedNewMasterName : @@IsMyLocalTDLModuleOn [!Field : EnhancedNewMasterName] Width : 20 Max : 20 [#Field : Item Name Field] Option : EnhancedNewItemName : @@IsMyLocalTDLModuleOn [!Field : EnhancedNewItemName] Width : 20 Max : 20 [#Field : Voucher Name Field] Option : EnhancedNewVoucherName : @@IsMyLocalTDLModuleOn [!Field : EnhancedNewVoucherName] Width : 20 Max : 20
Below increased the width of the Ledger Name, and added a column for the immediate Group but did Not add columns for Alias and Parent/primary Group to the list. Also, the list is not getting aligned to the right side of the screen at Full height. Code: [#Collection: VLedTable] ;Delete: Format ; worked without this ;Add: Format : $$Name, 50 Align : Right ;didn't work FullHeight : Yes ;didn't work Format : $$Name, 50 Add : Format: $Parent, 50 Fetch : Parent Add : Format: $GName, 50 Fetch : GName Title : $$LocaleString:"List of Ledger Accounts Its Me"
Collection VledTable is a generic Collection which is used by many Collections............ if the Parent Collection (which is calling this collection) has some parameters, then it will override the parameters set in the above collection. So for your query -- show by screenshot -- in which report????