Notifications
Announcements
No record found.
Dynamics GP 2015 - GL account Description - Longer than 50 Characters?
Is there any way to store and display more than 50 characters on GL account descriptions?
Thanks
Gale
*This post is locked for comments
Hi Gale,
Unfortunately I don't believe there is a way to store or display more than 50 characters for the account description using the standard GP Account Maintenance window. Although it appears that the underlying database field could technically accommodate a longer value, the field on the Account Maintenance window is fixed at 50.
It may be possible to customize the window to allow for a longer description length, but that would probably be of limited value, as inquiry windows, scrolling windows, and reports will all likely truncate the description at 50.
You could potentially add a custom field for a longer Description value, but that custom a field would then have to be added to any other window or report where you need to see the longer description.
So unfortunately I'm not aware of a good solution. A third party product might be another possibility, but those would have limitations as well.
Hi,
The underlying database table will allow for 51 characters without increasing the storage size. To access that extra character you would need to change the keyable length of the STR50 Data Type. Not worth the effort for a single character. Also, the STR50 Data Type is used in dozens of fields.
Do you need to have the entire description in a single field?
Kind regards,
Leslie
If you need this functionality would look at Extender, but this won't report on Management Reporter, but can use in Smartlist with SmartlistBuilder and Reports by linking.
Mick
Hello Gale,
I would have to agree with the other Reponses.
Overall, there is no great way to add a longer GL account Description, as the field in SQL only has 1 more character. As Steve pointed out, almost every other report or field in GP/MR would truncate this field even if you did have a good way to change the field on this one window.
I would recommend looking into 3rd parties that would allow for a longer field, unless you have expensing modifying this information yourself.
Please let me know if you have any additional questions on this.
Justin Sutton
------------------------------------------------------------------------------------
Microsoft Dynamics GP Support
**This posting is provided 'AS IS' with no warranties and confers no rights.**
I am also facing the same issue .. How can I make my description visible in one single field ?
Any option?
Thank you.
How many characters do you need? If you only want to change the display on the Account Maintenance window, you could use a Modified window and the DUOS table (SY90000) to store the value. The DUOS table's Property Value field is 133 characters. I'd use the Account Index as the Object ID. You could store the entire description in the DUOS table, but only the first 50 characters would show up in the GL related tables. You would modify the window and include a user-defined string field on the window with the appropriate keyable length. You would hide the existing description field and put your new field it its place. You would need to use VBA to connect to the database and write the value of the new field to the DUOS table Property Value field, write the first 50 characters to the GL Master and I suppose you could add 20 characters to each of the user defined fields.
Why do you need such a long account description? I know somebody suggested Extender, which is a good option. If you are trying to search for multiple things in the GL account description, you might think about using the user-defined fields to add the additional search data and then get Rockton Software's SmartFill product and tell it to search on the description AND the user defined fields when you enter a string in the description field.
80 Character, Can I use "RW_ParseString" function in the calculation field?
If yes, can you give me the syntax of the same
Or
suggest any easy method since I am a new user.
The RW_ParseString function will not help you here. That is used when you are trying to break up a long field into smaller chunks. You are wanting to increase the length of the field. I'm back at my earlier response to use the DUOS table to store the entire field. What windows/reports do you need this entire field to display/print to? If we know why you needed such a long field, we might be able to provide a work around.
I want to display the complete account description in Purchase -> Payable Transaction Entry Report before posting (MC PM Transaction Posting Journal Report). Now it is displaying only 32 character. Because I want print my full account description instead of half.
Is there a way to pull the character lengths available for each of the cards - ie Customer, Vendor set up?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1
