Solved

Update Vendor details on Stock Item profile not working

  • 22 March 2023
  • 6 replies
  • 188 views
A
Rank
Userlevel 3
Badge

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.

 

icon

Best answer by vkumar 22 March 2023, 03:21

View original

6 replies

V
Rank
Userlevel 7
Badge +11

Hi @aidenwills15 

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

Hope this helps.

Regards,

VijayKumarU
A
Rank
Userlevel 3
Badge

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

V
Rank
Userlevel 7
Badge +11

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,

VijayKumarU
rwhetsell77
Rank
Userlevel 3
Badge

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.

Regards, Robert Whetsell
A
Rank
Userlevel 3
Badge

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
Rank
Userlevel 3
Badge

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.

Regards, Robert Whetsell

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved