Skip to main content
Question

Vendor Price Worksheet - alternate ID

  • June 15, 2026
  • 1 reply
  • 3 views

When I load a vendor price worksheet using Excel, it is not checking the Vendor / Alternate ID combination.  It is matching it with any alternate ID, even if not from the vendor I specified.

 

Does anyone know of a workaround for that or if it is on the docket to be fixed?

1 reply

Forum|alt.badge.img+1
  • Semi-Pro II
  • June 15, 2026

When I load a vendor price worksheet using Excel, it is not checking the Vendor / Alternate ID combination.  It is matching it with any alternate ID, even if not from the vendor I specified.

 

Does anyone know of a workaround for that or if it is on the docket to be fixed?

Hi Tina
I don’t think this is supported by Acumatica.
If you just indicate the Vendor and normal Inventory ID though, it would pull in the Alternate ID.

If you only receive the Alternate ID, I would try opening up a Product idea first, and then also consider writing an Import scenario instead as the Alternate ID should be available through that.

I know it is counterintuitive as the Upload function is existing, yet as the Alternate ID is not really treated as a primary key, you will run into issues just using the Upload functionality rather than the import scenario.