Question: I am merging one item code to another. The item validates. I run the merge
and get an error "Cannot insert duplicate key row in object 'IV10201' with
unique index 'AK3IV10201'."
If it's merging one code into another table, how could it possibly have key
violation since it's changing the code?
The same error is happening on every item I try.
Answer(from my friend Richard Whaley):
This is one of the headaches of combining items.
The IV10201 table is the purchase receipts. So, if Item A had a receipt and
Item B had a receipt, you are also combining the receipt list. This should
work EXCEPT...
The AK3IV10201 index is a unique index, meaning there can only be ONE entry
in the index with the same item number, receipt number, and receipt type.
So, if item A had a receipt #5 via PO and item B had are receipt #5 via PO,
you get this error.
How to fix it? you need to purge receiving history, something you might not
want to do.
This blog was created to help Program leads, solution architects and administrators of different enterprise solutions including ERP, CRM, SCM, WMS, PLM, Business Intelligence and many more.
Subscribe to:
Posts (Atom)
e-Commerce discount types
In the world of retail today every retailer is trying to find ways and be creative to attract online customers. To attract your attention an...
-
The first time that you log in to Microsoft Dynamics GP 9.0, you can select to have default information that is specific to your job display...
-
I've filled out the survey and chose the functionalities I think would benefit a lot of industries. Below is a summary of the survey I s...
-
This month Microsoft announced the availability of Dynamics GP 2013 demo which you can download here . Most of the improvements were geare...