Error adding item to PO25.6

 2 Replies
 0 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
Bev Edwards
Veteran Member Send Private Message
Posts: 366
Veteran Member

When trying to add an item to PO25.6, getting error: Cannot create vendor item; manufacturer info on another vendor item.

I have run an Access query on both the POITEMVEN and POVENAGMTLN  tables, (wild card on front/back of the vendor item), but not getting any results. I cant figure out where this vendor item exists.

 

See attached screen shot.

Attachments
Michelle Wetzel
Veteran Member Send Private Message
Posts: 183
Veteran Member
Bev,

Run a query against the POitemven using mfg number to see what else is setup with that manufacturer number. My query has:

Procurement Group
Item
Ven-Item
Manuf-Nbr
Vendor

My criteria is the Manuf-Nbr of the item I just tried and failed on PO25.6. Once you find it, you'll need to delete the entry on PO25.6 and re-add it (change does not work).

Michelle
Michelle Wetzel
Veteran Member Send Private Message
Posts: 183
Veteran Member

Here's my dme query file if it helps.

 

Attachments