Skip to main content

Hi all,

I have been trying to update the vendor item number on the vendor details tab on the stock item profile, specifically I would like to add a vendor item ID. However, because there is a vendor there, it gives me an error saying “An attempt was made to add a duplicate entry.”. I have followed a few other discussions on here (I linked the discussion that seemed to be most similar to my scenario), but I still cant get the vendor details to update. Here is a screenshot of my map -

Any help would be greatly appreciated! Thank you.

 

Hi @aidenwills15 

Please make following change on your import scenario and try again. 

Hope this helps.

Regards,


@vkumar Thank you! That was the solution - out of curiosity, why can’t that line be marked as active while the other line can?


Hi @aidenwills15 

You are most welcome :)

The <Line Number>  -1 basically inserts a line on specific section. @@VendorID line basically locates the required vendor detail you wanted to update. There was no need to insert a line in your case after locating required Vendor on Vendor detail tab. Hence, I suggested to uncheck ‘Active’ for the second <Line Number> .

Regards,


So I’m attempting to perform the exact same update as is depicted here...here is my import scenario:

I’ve confirmed that each of the first five items I’m trying to update currently have one vendor record on the Vendor tab.

The result gives the “An attempt was made to add a duplicate entry” error message. We are working in 2023 R1.


Hi @rwhetsell77 ,

Here is the map I ended up using. Try it out and let me know if it works out for you.

Thanks!


Hi @rwhetsell77 ,

Here is the map I ended up using. Try it out and let me know if it works out for you.

Thanks!

Other than the inactive line my import scenario is identical. I’ve tried that exact structure as I found the same community post from the past on this and couldn’t get it to work.

I finally decided it’s easier to delete the vendor record and reimport.


Reply