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 CIOs, Program leads, solution architects and administrators.
Subscribe to:
Post Comments (Atom)
Digital Transformation unleashed
You're the CIO/CDO sitting in your weekly update executive meeting with the CEO, CFO, COO, and others. You start the meeting with the pr...
-
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...
-
Did you hear about the latest trend in databases? If not then you should read this article about NoSQL or "not only SQL". NoSQL...
-
This month Microsoft announced the availability of Dynamics GP 2013 demo which you can download here . Most of the improvements were geare...
8 comments:
Bonjour, ddelprado.blogspot.com!
[url=http://meds.fora.pl/ ] viagra [/url] [url=http://medsonline.fora.pl/ ]Acheter viagra [/url] [url=http://onlinefarmacia.fora.pl/ ]Acheter viagra [/url] [url=http://masar.fora.pl/ ]Acheter viagra online[/url] [url=http://med.fora.pl/ ]Acheter viagra online[/url]
...please where can I buy a unicorn?
no veo su lГіgica http://nuevascarreras.com/tag/cialis-online/ cialis 20 mg generico Autorevole risposta, divertimento ... cialis precio venezuela ixnbssfqgg [url=http://www.mister-wong.es/user/COMPRARCIALIS/comprar-viagra/]viagra cialis[/url]
[url=http://certifiedpharmacy.co.uk/catalogue/h.htm][img]http://onlinemedistore.com/1.jpg[/img][/url]
pharmacy mur assesements http://certifiedpharmacy.co.uk/products/evecare.htm pharmacy testim [url=http://certifiedpharmacy.co.uk/products/dilantin.htm]average salary pharmacy technician by hour[/url]
canda pharmacy http://certifiedpharmacy.co.uk/categories/weight-loss.htm chel pharmacy [url=http://certifiedpharmacy.co.uk/products/xplode--stamina--energy-and-sex-enhancer-.htm]xplode stamina energy and sex enhancer [/url]
frys pharmacy in tucson http://certifiedpharmacy.co.uk/products/plavix.htm lowens pharmacy [url=http://certifiedpharmacy.co.uk/products/accutane.htm]kansas university pharmacy[/url]
cvs pharmacy extra care card http://certifiedpharmacy.co.uk/products/flagyl-er.htm compounding pharmacy melbourne [url=http://certifiedpharmacy.co.uk/products/nexium.htm]nexium[/url]
[url=http://englandpharmacy.co.uk/products/erythromycin.htm][img]http://onlinemedistore.com/6.jpg[/img][/url]
board of pharmacy ohio technician continuing education http://englandpharmacy.co.uk/products/crestor.htm pharmacy propecia [url=http://englandpharmacy.co.uk/products/diamox.htm]pharmacy technician practice test[/url]
soul pattinson pharmacy http://englandpharmacy.co.uk/products/noroxin.htm arial pharmacy [url=http://englandpharmacy.co.uk/categories/stop-smoking.htm]stop smoking[/url]
pharmacy in canada http://englandpharmacy.co.uk/products/celexa.htm pharmacy inspection sheets [url=http://englandpharmacy.co.uk/products/ed-discount-pack-3.htm]evansville pharmacy[/url]
pseudoephedrine restrictions at pharmacys due to meth labs http://englandpharmacy.co.uk/products/zelnorm.htm green pharmacy [url=http://englandpharmacy.co.uk/products/intagra.htm]intagra[/url]
[url=http://englandpharmacy.co.uk/categories/gastrointestinal.htm][img]http://onlinemedistore.com/2.jpg[/img][/url]
how to become a certified pharmacy tech http://englandpharmacy.co.uk/products/prednisone.htm pharmacy drug trend [url=http://englandpharmacy.co.uk/products/bactrim.htm]toledo pharmacy mix up wrong medication[/url]
board of pharmacy oregon http://englandpharmacy.co.uk/catalogue/t.htm irvington pharmacy nj [url=http://englandpharmacy.co.uk/products/starlix.htm]starlix[/url]
pharmacy no prescription norvasc http://englandpharmacy.co.uk/products/metformin.htm pharmacy today [url=http://englandpharmacy.co.uk/catalogue/e.htm]winning essay writing pharmacy[/url]
medicine shoppe pharmacy franchises http://englandpharmacy.co.uk/products/dulcolax.htm open pharmacy [url=http://englandpharmacy.co.uk/products/pletal.htm]pletal[/url]
[url=http://fdaapproved.co.uk/products/intagra.htm][img]http://onlinemedistore.com/6.jpg[/img][/url]
pharmacy shooting http://fdaapproved.co.uk/products/diclofenac.htm pharmacy jacket with snaps across shoulder [url=http://fdaapproved.co.uk/products/zyprexa.htm]botts pharmacy wa[/url]
cvs pharmacy roswell road georgia http://fdaapproved.co.uk/products/kamasutra-intensity-condoms.htm frontier pharmacy in boca ratan florida [url=http://fdaapproved.co.uk/products/fosamax.htm]fosamax[/url]
naturopathic pharmacy http://fdaapproved.co.uk/products/lioresal.htm pharmacy price checker [url=http://fdaapproved.co.uk/products/lanoxin.htm]silagra pharmacy penegra cumwithuscom[/url]
castcutters pharmacy http://fdaapproved.co.uk/products/glucotrol-xl.htm no prescription online pharmacy [url=http://fdaapproved.co.uk/products/nizoral.htm]nizoral[/url]
interracial post member links dating romantic cards adults sex dating in bangalore
free teen dating tips http://freeinternetdating.info/matchmaking/dating-matchmaking-single-meet-personals-love moline il gay online dating
university of minnesota mankato dating techniques local dating sites free southwest va my lord dating
Post a Comment