please required to increase the table size

Discussion in 'Free Source Codes' started by panam, May 19, 2021.

    
  1. panam

    panam Member


    dear experts,
    i required to increase the table size of list of ledgers accounts.
    Please help me.

    [#Field:voucher register]
    WIDTH:45
     

    Attached Files:



  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    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.........
     
    naren1234 and panam like this.


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Here I've added characters QQQ to find out the correct Collection.

    Capture.PNG
     
    panam likes this.


  4. Bipin Damania

    Bipin Damania Active Member


    Very well explained Amitji...
     
    panam and Amit Kamdar like this.


  5. panam

    panam Member


    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..
     


  6. panam

    panam Member


    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...
     


  7. panam

    panam Member


    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 .
     


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    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.
     
    panam likes this.


  9. panam

    panam Member


    ok sir. thank u
     


  10. panam

    panam Member


    Dear Amit sir, i am not getting. please help me.
     

    Attached Files:

    • 1.png
      1.png
      File size:
      138.7 KB
      Views:
      86


  11. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [#Collection: VLedTable]
    Delete : Format
    Add : Format : $$Name, 50
     
    naren1234 and panam like this.


  12. panam

    panam Member


    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...
     


  13. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    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.......
     
    naren1234 and panam like this.


  14. panam

    panam Member


    ok sir, i will check.
    thank u sir.
     


  15. panam

    panam Member


    [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,
     
    naren1234 likes this.


  16. panam

    panam Member


    New

    dear sir,
    i tried for display/account/ledger table
    also added gstin in table
    3.jpg 2.jpg
     


  17. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    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.
     
    naren1234 likes this.


  18. Amit Kamdar

    Amit Kamdar Administrator Staff Member

    panam likes this.


  19. panam

    panam Member


    Thank you.
    with your kind help and support i learnt the tdl sir.
     


  20. Hardik_9623

    Hardik_9623 New Member


    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
     


  21. naren1234

    naren1234 Member


    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"
     
    Last edited: Oct 13, 2022


  22. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    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????
     
    panam likes this.


Share This Page