Open Forum

TransDesc Field Length (GL Tran)

  • 1.  TransDesc Field Length (GL Tran)

    Posted Aug 13, 2019 06:25 PM
    Edited by Kalvin Luong Aug 13, 2019 06:28 PM
    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 Aug 14, 2019 05:30 AM
    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 Aug 14, 2019 08:44 AM
    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 Aug 14, 2019 09:13 AM
    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 Aug 14, 2019 11:43 AM
    This is great info.  Thank you all for your help!

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



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

    Posted Aug 15, 2019 12:21 PM
    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
    ------------------------------