Skip to main content

Notifications

Microsoft Dynamics GP forum
Answered

Increase ITEM character length

Posted on by 385

Dear Community,

Can someone guide me if there is an option to increase the character length up-to 100 of Item number field in inventory module.

Any help would be appreciated.

Thanks.

Categories:
  • Jozy Profile Picture
    Jozy 385 on at
    RE: Increase ITEM character length

    Thank you David we will definitely try this.

  • Verified answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,831 Moderator on at
    RE: Increase ITEM character length

    Hi Jozy

    You could code an additional field for storing a longer number very easily using GP Power Tools and Modifier.

    Note that there is a limit of 80 characters for string calculated fields in the report writer, there is a way around this be splitting your 100 characters into two calculated fields.

    See this example which is actually on the Item Maintenance window.

    https://winthropdc.wordpress.com/2020/01/31/gppt-beginners-guide-to-adding-custom-fields-introduction/

    More info on the portal http://WinthropDC.com/GPPT

    You can install and activate a free 30 day trial period.

    Regards

    David

  • Jozy Profile Picture
    Jozy 385 on at
    RE: Increase ITEM character length

    Hi, Derek Albaugh

    Hope you are fine.

    Thank you for your suggestion I Personally exactly thinking the same thing you told. Let me discuss this with my team.

  • Verified answer
    RE: Increase ITEM character length

    The first issue you're going to run into is that the ITEMNMBR column/field in the IV00101 table only allows 30 characters, as does IV00102 and I'd imagine pretty much every table with this column in it.

    We don't recommend modifying the GP tables at all, because that's cause errors with upgrades of Dynamics GP and such.

    Depending on how you are going to use it, you may be able to use a custom table with an Item Number field in it that allows 100 characters, then tie it to the ITEMNMBR value in the IV00101 table or something along those lines.

    At that point, you could add a field to a form or report allowing for this 100 character Item Number and use it that way.

    I'd imagine a few more in the Community here may have some other options.......

    Thanks

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

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans