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?
Best answer by krausef77
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.
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.
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.
What is a ‘Product idea’?
And as I’m trying to make this easy and user friendly for many end users, having an if then else procedure is not ideal. Thanks.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
