Please find the import scenario to update multiple Purchase orders from excel providers.
Attaching sample file for reference
Thanks
Hi @manikantad18 . By saying “to update POs”, does that mean they already have to be created in Acumatica? Im looking for a solution to import new POs.
Please find the import scenario to update multiple Purchase orders from excel providers.
Attaching sample file for reference
Thanks
Hi @manikantad18 . By saying “to update POs”, does that mean they already have to be created in Acumatica? Im looking for a solution to import new POs.
Have you tried the Import scenario shared by Me?
The import scenario shared will help to create new PO
Please find the import scenario to update multiple Purchase orders from excel providers.
Attaching sample file for reference
Thanks
Hi @manikantad18 . By saying “to update POs”, does that mean they already have to be created in Acumatica? Im looking for a solution to import new POs.
Have you tried the Import scenario shared by Me?
The import scenario shared will help to create new PO
Please find the import scenario to update multiple Purchase orders from excel providers.
Attaching sample file for reference
Thanks
@manikantad18 I think thats exactly what I need. I was not able to do the import yet, as Im getting 5 errors for missing some fields. Would you be able to help me out? I added the required fields on the data provider and edited the import scenario, but still getting the same errors. thx
@dpruckusImport POs → Import scenario is also available in the 22 R1 version.
As you are getting the 5 errors with your import scenario, can you please share your XML format of the import scenario here? so that we can check from our end and let you if found anything related to the errors.
Please find the import scenario to update multiple Purchase orders from excel providers.
Attaching sample file for reference
Thanks
@manikantad18 I think thats exactly what I need. I was not able to do the import yet, as Im getting 5 errors for missing some fields. Would you be able to help me out? I added the required fields on the data provider and edited the import scenario, but still getting the same errors. thx
Hi @dpruckus Please share the Import scenario file after editing as @Naveen Boga requested.
Please find the import scenario to update multiple Purchase orders from excel providers.
Attaching sample file for reference
Thanks
@manikantad18 I think thats exactly what I need. I was not able to do the import yet, as Im getting 5 errors for missing some fields. Would you be able to help me out? I added the required fields on the data provider and edited the import scenario, but still getting the same errors. thx
Hi @dpruckus Please share the Import scenario file after editing as @Naveen Boga requested.
Thanks
@manikantad18 I was able to fix your solution. It was missing 5 mandatory fields to create POs. Works fine now! thanks.
Please find the import scenario to update multiple Purchase orders from excel providers.
Attaching sample file for reference
Thanks
Just a quick thank you for this. I was able to take the XML, edit it slightly and now have it working for my purpose. This should save us about 4hrs per week when I get my team fully up to speed on creating the orders from excel.