116
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
I can extend the GL Account Description with a simple customization. The first 50 characters will appear in the GL table and the remaining characters stored in the DUOS (Dynamic User Object Store) SY90000 table.
As for Resource info, you should try the Resource Information and Resource Finder windows in GP Power Tools, it is resource descriptions on steroids. Way more powerful than what GP offers.
Install the free trial to have a look.
David
Tools->Resources Descriptions->Tables will give you the table list per module and then if you drill down there is a print button you can send to the screen or file.
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.
Thanks
Hi,
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.
Leslie
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.
Kind regards,
Leslie
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.**
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
