Item Code (Unused Field?)

(0) Share

Report

Posted on by kevbrunton

I see in the IV00101 table there is a field named ITEMCODE. This is listed in the various field listings as "Item Code". I can't find anywhere that this field is maintained on the Item Card or related screens.

I found a REALLY old post about Item Code having been added in GP 6.0 but it wasn't used and was for a future "international" requirement.

So two questions: Is this field really not used? If it is not being used, what would the potential danger be of using Modifier to add it to the item card and using it. We'd like to use it to store the UPC Code.

Thanks,

*This post is locked for comments

All responses (6)

Answers (0)

Mariano Gomez 26,225 on at

Like (0)

Report

RE: Item Code (Unused Field?)

Thank you Leslie for the shout out.

Although this is an orphan field I caution every one of you using this field to be cautious. If Microsoft decides to reuse this field or simply drop it from the data model you will lose your data. With that said, I have tons of examples on my blog as Leslie mentioned showing how to use VBA and even Visual Studio Tools to drive the user interface for fields that need to be stored with the standard GP data.
Suggested answer

L Vail 65,271 on at

Like (0)

Report

RE: Item Code (Unused Field?)

Since the Item Code field does not exist in the Item Quantities table, you'll need to use Modifier with VBA to open the IV00101 table and bring in the Item Code field. There are plenty of examples out there as to how to accomplish getting the attachment in VBA. I know Mariano Gomez has some good information on his blog.

Kind regards,

Leslie
Community Member on at

Like (0)

Report

RE: Item Code (Unused Field?)

I added the item code field to the Item Maintenance window. Do you know how I would now add to the Item Inquiry window?
MichaelC 1,763 on at

Like (0)

Report

RE: Item Code (Unused Field?)

I have used this field for other item data also. I stumbled on it a few years ago and realized it was an "orphan" field so I have been using it as a "user defined" field.
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Item Code (Unused Field?)

This field is no longer used, I have used it in few implementations to store additional item's details with no issues.
Suggested answer

soma 24,410 on at

Like (0)

Report

RE: Item Code (Unused Field?)

I think this field is no longer use in GP versions 8 to 2013. So, you can use this field to store the UPC code values. It won't make any issues.

Have a look on the below link.

community.dynamics.com/.../5320.aspx

Hope this helps!!!