Skip to main content
Solved

Importing Purchase Orders


dpruckus
Freshman I
Forum|alt.badge.img

Is it possible to import multiple Purchase Orders from Excel? Cant seem to find this option.

 

Thanks.

Best answer by Manikanta Dhulipudi

Hello @dpruckus 

Please find the import scenario to update multiple Purchase orders from excel providers.

Attaching sample file for reference

Thanks

View original
Did this topic help you find an answer to your question?

13 replies

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

Hello @dpruckus 

Please find the import scenario to update multiple Purchase orders from excel providers.

Attaching sample file for reference

Thanks


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • November 23, 2022

Hi @dpruckus  In addition to Mani’s comment, a few import scenarios are already providing the Acumatica by default.

You can always refer to these import scenarios for reference.

 


dpruckus
Freshman I
Forum|alt.badge.img
  • Author
  • Freshman I
  • 34 replies
  • November 23, 2022
Naveen Boga wrote:

Hi @dpruckus  In addition to Mani’s comment, a few import scenarios are already providing the Acumatica by default.

You can always refer to these import scenarios for reference.

 

 

Hi Naveen, unfortunately I am not able to find POs import scenario.. Am I in the wrong spot?

 

 

 


dpruckus
Freshman I
Forum|alt.badge.img
  • Author
  • Freshman I
  • 34 replies
  • November 23, 2022
manikantad18 wrote:

Hello @dpruckus 

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.


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13
dpruckus wrote:
manikantad18 wrote:

Hello @dpruckus 

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


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • November 23, 2022

@dpruckus  In which version of Acumatica you are currently working on this?


dpruckus
Freshman I
Forum|alt.badge.img
  • Author
  • Freshman I
  • 34 replies
  • November 23, 2022
Naveen Boga wrote:

@dpruckus  In which version of Acumatica you are currently working on this?

 

2022 R1 Build 22.113.0040


dpruckus
Freshman I
Forum|alt.badge.img
  • Author
  • Freshman I
  • 34 replies
  • November 23, 2022
manikantad18 wrote:
dpruckus wrote:
manikantad18 wrote:

Hello @dpruckus 

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

 

Not yet, i though i might ask first. thanks


dpruckus
Freshman I
Forum|alt.badge.img
  • Author
  • Freshman I
  • 34 replies
  • November 23, 2022
manikantad18 wrote:

Hello @dpruckus 

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


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • November 24, 2022

@dpruckus Import 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 screenshots for reference.

 

Export XML format of the import scenario

 

 


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13
dpruckus wrote:
manikantad18 wrote:

Hello @dpruckus 

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


dpruckus
Freshman I
Forum|alt.badge.img
  • Author
  • Freshman I
  • 34 replies
  • November 24, 2022
manikantad18 wrote:
dpruckus wrote:
manikantad18 wrote:

Hello @dpruckus 

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.


Forum|alt.badge.img
  • Jr Varsity III
  • 37 replies
  • March 16, 2023
Naveen Boga wrote:

Hi @dpruckus  In addition to Mani’s comment, a few import scenarios are already providing the Acumatica by default.

You can always refer to these import scenarios for reference.

 

We seem to be missing this import scenario.  Is there someplace that I can download them?

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings