Open Forum

TransDesc Field Length (GL Tran)

  • 1.  TransDesc Field Length (GL Tran)

    Posted 4 days ago
    Edited by Kalvin Luong 4 days ago
    Is there a way to increase the length of the TranDesc length from default 30 characters to 60 characters?

    ------------------------------
    Kalvin
    GMT Corporation
    Pasadena CA
    ------------------------------


  • 2.  RE: TransDesc Field Length (GL Tran)

    BRONZE CONTRIBUTOR
    Posted 4 days ago
    No, you cannot change the length or properties of any field in a Dynamics SL table.  It will cause errors because the table schema is embedded in the code of each SL screen and cannot be altered.

    ------------------------------
    Mark Ehleben
    President
    QBI Consulting, LLC
    Warminster PA
    ------------------------------



  • 3.  RE: TransDesc Field Length (GL Tran)

    TOP CONTRIBUTOR
    Posted 4 days ago
    Hi Kalvin,

    What I have done when I needed 60 characters is take a user field (I think user1 and user 2 are 30 characters) and add it next to the description field.  The user can then "finish" in that field.  I also added to the reports, QQ's, etc where I wanted it so they print next to each other.  It gives you 60 characters but in 2 fields.

    This is assuming you aren't heavily customized and the fields are available.

    Hope this helps.

    Thanks,
    Michael

    ------------------------------
    Michael O'Neill
    Director of Finance
    Eastex Telephone Cooperative
    Henderson TX
    ------------------------------



  • 4.  RE: TransDesc Field Length (GL Tran)

    GOLD CONTRIBUTOR
    Posted 4 days ago
    Consider using the (transaction-level) notes capability. Clicking on the "Post-It" icon for a selected transaction line allows you to enter a lot more than just 60 characters. If you use XLstatements for GL reporting, these notes will show up as Excel comments. If not, you will need to enable printing the notes on relevant reports.



    ------------------------------
    Jonathan Van Houtte
    Architect
    XLstatements, LLC
    Clifton Park NY
    ------------------------------



  • 5.  RE: TransDesc Field Length (GL Tran)

    Posted 4 days ago
    This is great info.  Thank you all for your help!

    ------------------------------
    Kalvin
    GMT Corporation
    Pasadena CA
    ------------------------------



  • 6.  RE: TransDesc Field Length (GL Tran)

    Posted 2 days ago
    Hi Kalvin.  Another thing we do is just move to the next detail row in the grid and enter the same acct/sub.  Don't enter any debit or credit amount and just use the description field as more space for your comment.  You can add as many "description" rows as you need to have meaningful descriptions.  On most reports and things, the rows will line up and look like a big block of text. You can do this in Voucher and Adjustment as well.

    ------------------------------
    Timothy Malia
    Partner
    T&T Data Solutions L.L.C.
    HILLSBOROUGH NC
    ------------------------------