Increase ITEM character length

(0) Share

Report

Posted on by Jozy

393

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:

Microsoft Dynamics GP

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Derek Albaugh Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Jozy 393 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

David Musgrave MVP ... 14,137 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Jozy 393 on at

Like (0)

Report
Copy link

Link copied!

Thank you David we will definitely try this.

Was this reply helpful? Yes No