Skip to main content
Question

Changing default vendors on a stock item using an import scenario 2025R2

  • May 12, 2026
  • 5 replies
  • 45 views
C
Freshman I

Vendor already exists on the items and we are looking to change the vendor to the default (already marked default on a different vendor) using an import scenario. Searched and tried several different options. Was getting the purchasing unit error, added that and then getting a duplication error. Tried a manual scenario and still no luck. Hoping someone has a GI written for this same scenario. Thank you!

5 replies

mohammadnawaz51
Varsity I
Forum|alt.badge.img+7

​@chrissic 

Did you check this.

https://community.acumatica.com/import-and-export-scenarios-117/adding-default-to-vendor-on-stock-items-with-multiple-vendor-options-using-import-scenario-10218

https://globalpayex.com/resources/blogs/the-complete-guide-to-ar-and-ap-automation-in-acumatica/
    C
    Freshman I
    • chrissic
    • Author
    • Freshman I
    • May 12, 2026

    ​@mohammadnawaz51 Yes I did review that, thank you for sharing with me. I tried it and it still was not working properly. I do see the training guide in that string though and will check that out. 

     

    mohammadnawaz51
    Varsity I
    Forum|alt.badge.img+7

    ​@chrissic Do you have an Import scenario built? if yes please share I can check and get back to you!

    https://globalpayex.com/resources/blogs/the-complete-guide-to-ar-and-ap-automation-in-acumatica/
      Chris Hackett
      Community Manager
      Forum|alt.badge.img
      • Chris Hackett
      • Acumatica Community Manager
      • August 26, 2026

      Hi ​@chrissic were you able to find a solution? Thank you!

      Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
      Naveen Boga
      Captain II
      Forum|alt.badge.img+20
      • Naveen Boga
      • Captain II
      • August 27, 2026

      ​@chrissic  If the vendor already exists on the Stock Item and you are trying to change the default vendor to another vendor using an Import Scenario, I would recommend updating the existing vendor record rather than trying to add a new vendor record.

      The Purchasing UOM needs to be included when updating the vendor, and the duplication error may indicate that the import is attempting to insert a new vendor record instead of updating the existing one.

      I would first verify that the import scenario is using the correct Inventory ID + Vendor ID as the key fields and that the Default flag is being updated on the existing vendor record.

      If you can share the Import Scenario mapping and the exact duplication error, I can take a closer look and suggest the correct mapping.

      Naveen B - Acumatica MVP 🏆 | Acumatica Developer 🚀 ⏩ https://www.linkedin.com/in/naveenb-acumatica-mvp/
        Terms & ConditionsAccessibility statement
        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