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.
Thank you David we will definitely try this.
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
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,522 Super User 2024 Season 2
Martin Dráb 228,441 Most Valuable Professional
nmaenpaa 101,148