web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Increasing a field Size
Microsoft Dynamics GP (Archived)

Increasing a field Size

(0) ShareShare
ReportReport
Posted on by Charles Siele 525

Hi Guys,

Kindly asking for your suggestions on this;how to increase a field size. E.g

Transactions>Financials>General.......i want to increase the field size of REFERENCE and Description fields.They both have a limit of 30 characters.

Anyone with suggestions would be highly appreciated.

Regards,

Charles Ssiele

 

*This post is locked for comments

I have the same question (0)
  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 14,069 Most Valuable Professional on at
    Re: Increasing a field Size

    Hi Charles

    Here is your answer

    http://blogs.msdn.com/b/developingfordynamicsgp/archive/2008/07/24/modifier-extending-the-length-of-a-field.aspx

    David

    David Musgrave [MSFT]
    Escalation Engineer - Microsoft Dynamics GP
    Microsoft Dynamics Support - Asia Pacific

    Microsoft Dynamics (formerly Microsoft Business Solutions)
    http://www.microsoft.com/Dynamics

    mailto:David dot Musgrave at microsoft dot com
    http://blogs.msdn.com/DevelopingForDynamicsGP

    Any views contained within are my personal views and not necessarily Microsoft policy.
    This posting is provided "AS IS" with no warranties, and confers no rights. 
     

  • Charles Siele Profile Picture
    Charles Siele 525 on at
    Re: Re: Increasing a field Size

    Hi David,

    Did exactly that but still the size field remaind 30 charcters. Any further suggestions where i might be missing?

    Regards

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 14,069 Most Valuable Professional on at
    Re: Re: Re: Increasing a field Size

    Hi Charles

    If you are using the package from my example on the blog, you will need to change security to use the modified version of the window.

    Note we are not actually changing the field size, but replacing the field with a larger local field and using the DUOS to store the longer string.  We also update as the original field with the first 30 characters so that it has as much of the string as will fit.

    Please check that you have updated security to use the modified windows and reports.

    Thanks

    David

    David Musgrave [MSFT]
    Escalation Engineer - Microsoft Dynamics GP
    Microsoft Dynamics Support - Asia Pacific

    Microsoft Dynamics (formerly Microsoft Business Solutions)
    http://www.microsoft.com/Dynamics

    mailto:David dot Musgrave at microsoft dot com
    http://blogs.msdn.com/DevelopingForDynamicsGP

    Any views contained within are my personal views and not necessarily Microsoft policy.
    This posting is provided "AS IS" with no warranties, and confers no rights. 

  • Charles Siele Profile Picture
    Charles Siele 525 on at
    Re: Re: Re: Re: Increasing a field Size

    Am accesing modified reports and windows but still can't change the field size.

    More suggestions please

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 14,069 Most Valuable Professional on at
    Re: Re: Re: Re: Re: Increasing a field Size

    Hi Charles

    The example only increases the size of the Reference field in the header.

    To increase the size of the field on scrolling window is more complex as the key field (sequence number) is not populated until the line is saved.

    You would need to incorporate the technique in the follow post to allow the Scrolling window field to be chaged using a similar method as used in the header.

    http://blogs.msdn.com/b/developingfordynamicsgp/archive/2010/06/09/adding-extender-windows-to-gl-transaction-entry-lines.aspx

    David

    David Musgrave [MSFT]
    Escalation Engineer - Microsoft Dynamics GP
    Microsoft Dynamics Support - Asia Pacific

    Microsoft Dynamics (formerly Microsoft Business Solutions)
    http://www.microsoft.com/Dynamics

    mailto:David dot Musgrave at microsoft dot com
    http://blogs.msdn.com/DevelopingForDynamicsGP

    Any views contained within are my personal views and not necessarily Microsoft policy.
    This posting is provided "AS IS" with no warranties, and confers no rights. 

  • Charles Siele Profile Picture
    Charles Siele 525 on at
    Re: Re: Re: Re: Re: Re: Increasing a field Size

     Hi Dave,

    Wow, the scrip worked for me. Thanks fro the guidance.

    Regards,

    Charles

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 14,069 Most Valuable Professional on at
    Re: Re: Re: Re: Re: Re: Re: Increasing a field Size

    Awesome, thanks for the update.

    Why don't post a comment on the blog.... :-)

    David

  • Corrie Olson Profile Picture
    Corrie Olson 95 on at
    Re: Re: Re: Re: Re: Re: Re: Increasing a field Size

    Can you do this without owning Modifier?

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 14,069 Most Valuable Professional on at
    Re: Re: Re: Re: Re: Re: Re: Increasing a field Size

    Hi Corrie

    You would need to have the Customization Site License registered to use a package created by someone else, usually your partner.

    If you don't have either, then Extender or a custom Dexterity app would be needed. Note that Dexterity can only make the change in the original window if the window is part of the core Dynamics.dic dictionary.

    David

  • Community Member Profile Picture
    Community Member on at
    Re: Increasing a field Size

    Dave,

    On the link to the zip file to test this out, it references up to GP10, could I try that in GP 2010 R2 also?

    Thank you.

    Diana

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.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans