SETTING UP NEW ITEM NUMBERS

(0) Share

Report

Posted on by Community Member

I am trying to set up a new item number which is similar to an existing item number. After entering the new item number, I then move to the item description field, but it automatically changes the item number and all it's corresponding fields to the similar item number. I do not want the similar item number.

What am I doing wrong? Or does GP not allow any similar item numbers to be entered?

I would appreciate anyone's feedback on this. Thank you.

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (0)

Frank Hamelly | MVP... 46,619 Super User 2025 Season 2 on at

Like (0)

Report

RE: SETTING UP NEW ITEM NUMBERS

You must be entering the existing item number, which is causing the existing description and other details to default in. All item numbers are unique in GP. You could use the existing item number and add a space to the end of it and GP would recognize it as a new number.

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

RE: SETTING UP NEW ITEM NUMBERS

GP not allow to enter/use more than one similar item numbers. Item Numbers are unique fields in GP. Better you can add some post-fix to the item number fields like ITEM001, ITEM002,etc.,

Note: You can create multiple items with different item numbers along with same Descriptions or Generic Descriptions.

Hope this helps!!!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: SETTING UP NEW ITEM NUMBERS

The New Item # I am trying to enter is DASH-CA-050-BLK, but the system keeps bringing up existing item # AF-DASH-CA-050. There is a difference in these 2 numbers.

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,619 Super User 2025 Season 2 on at

Like (0)

Report

RE: SETTING UP NEW ITEM NUMBERS

Do you have Rockton SmartFill installed? It may be auto-filling the item number field when you start typing your new number. If so, type over the auto-filled number with your new number before tabbing out of the item number field.

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

RE: SETTING UP NEW ITEM NUMBERS

Do you have installed any customization with belongs to Item Maintenance window?

Also run the below query against company database to check whether the both item numbers available or not.

SELECT * FROM IV00101 WHERE ITEMNMBR IN ('DASH-CA-050-BLK','AF-DASH-CA-050')

Your reply is much appreciated.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: SETTING UP NEW ITEM NUMBERS

We do not have Rockton Smartfill installed. The existing item number does not appear until after I tab out of the item number field and it does not let me go back to the item number field to type over the existing item number.

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

RE: SETTING UP NEW ITEM NUMBERS

Go to Customization Status window(Tools-->Customize-->Customization Status), and click print button to print the Trigger List report to check whether the Item Number has any triggers.

Also try to run the SQL Profiler to trace the log.

Hope this helps!!!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: SETTING UP NEW ITEM NUMBERS

No customization installed. Ran query for Item #'s. Item# DASH-CA-050-BLK is not available.

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

RE: SETTING UP NEW ITEM NUMBERS

Have you try to run the SQL Profiler to trace the log?

Please follow below link to trace SQL log while entering Item Number.

msdn.microsoft.com/.../ms173799.aspx

Hope this helps!!!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: SETTING UP NEW ITEM NUMBERS

Do you know which Product Name that I should look under? There is a lot in the Trigger List Report that I ran.

Was this reply helpful? Yes No