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.
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.
More info on the portal http://WinthropDC.com/GPPT
You can install and activate a free 30 day trial period.
Regards
David
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
#1
André Arnaud de Cal...
291,419
Super User 2024 Season 2
#2
Martin Dráb
230,492
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
