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.
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
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.
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
Thank you David we will definitely try this.
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.
Martin Dráb 683 Most Valuable Professional
André Arnaud de Cal... 563 Super User 2025 Season 2
Sohaib Cheema 398 User Group Leader
