Friday, August 01, 2008

Error when using ProTools Item Combiner

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.

8 comments:

Anonymous said...

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]

Anonymous said...

...please where can I buy a unicorn?

Anonymous said...

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]

Anonymous said...

[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]

Anonymous said...

[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]

Anonymous said...

[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]

Anonymous said...

[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]

Anonymous said...

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