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.
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.
** Please, if this answers your question, mark it as 'Answered' so others experiencing the same will know it resolved your issue. **
Frank E. Hamelly, MCP-GP, MCP-AX, MCITP, MCT, MVP
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!!!
Note: Please mark it as verified, if this answer your question. Because this will helps to some others who experience the same.
Somakarpagamoorthy K | Microsoft Dynamics GP Consultant | Dynamics Thoughts
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.
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.
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.
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.
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.
No customization installed. Ran query for Item #'s. Item# DASH-CA-050-BLK is not available.
Have you try to run the SQL Profiler to trace the log?
Please follow below link to trace SQL log while entering Item Number.
Do you know which Product Name that I should look under? There is a lot in the Trigger List Report that I ran.
Find Item number field from the file.
Can you attach the file?
What happens if you enter a new item number - don't tab off of the field, and then hit the Copy button at the top of the window? See if you can copy the data from your similar item.
Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITSASCI, Inc. * PO Box 600965 * Dallas, TX 75360 * 972-814-8550 * email@example.com