Skip to main content
Solved

Update Vendor details on Stock Item profile not working


Forum|alt.badge.img

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.

 

Best answer by vkumar

Hi @aidenwills15 

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

Hope this helps.

Regards,

View original
Did this topic help you find an answer to your question?

6 replies

Forum|alt.badge.img+12
  • Acumatica Support Team
  • 871 replies
  • Answer
  • March 22, 2023

Hi @aidenwills15 

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

Hope this helps.

Regards,


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 25 replies
  • March 22, 2023

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


Forum|alt.badge.img+12
  • Acumatica Support Team
  • 871 replies
  • March 22, 2023

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,


rwhetsell77
Freshman II
Forum|alt.badge.img
  • Freshman II
  • 39 replies
  • October 28, 2023

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.


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 25 replies
  • October 28, 2023

Hi @rwhetsell77 ,

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

Thanks!


rwhetsell77
Freshman II
Forum|alt.badge.img
  • Freshman II
  • 39 replies
  • October 29, 2023
aidenwills15 wrote:

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings