Skip to main content
Solved

Bulk Upload Stock Items in 2020 R1


Hi!  I would like to upload in bulk a list of Stock Items from multiple Vendors so we can easily create POs and our buyers do not have to individually add these stock items.  I’ve tried using the import function in Vendor Price Worksheets and Vendor Inventory with no success.  I’m trying again in the Import Scenarios option, but I keep getting stuck on the Provider field.  What option should I be using?  

 

Best answer by harshita53

Hello @mariaanderson ,
For using the Import Scenarios, users are required to first create the data provider - as from which type of file is the data to be uploaded - whether it is from excel or csv etc. And then for mapping the fields we would be using Import Scenarios (SM206025) screen. The below link might be helpful to you.

Data Provider : https://help.acumatica.com/(W(1))/Help?ScreenId=ShowWiki&pageid=32b4f7df-08bf-4148-829e-3e08f4d945f6


Import Scenario : https://help.acumatica.com/(W(1))/Help?ScreenId=ShowWiki&pageid=d79ea7dd-d6d6-4646-b206-14df4c56aea7

 

Import by Scenario : https://help.acumatica.com/(W(1))/Help?ScreenId=ShowWiki&pageid=1deb1206-416a-4d8c-ac0d-09056aa65f0d

 

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

2 replies

Forum|alt.badge.img
  • Varsity I
  • 24 replies
  • Answer
  • June 26, 2023

Hello @mariaanderson ,
For using the Import Scenarios, users are required to first create the data provider - as from which type of file is the data to be uploaded - whether it is from excel or csv etc. And then for mapping the fields we would be using Import Scenarios (SM206025) screen. The below link might be helpful to you.

Data Provider : https://help.acumatica.com/(W(1))/Help?ScreenId=ShowWiki&pageid=32b4f7df-08bf-4148-829e-3e08f4d945f6


Import Scenario : https://help.acumatica.com/(W(1))/Help?ScreenId=ShowWiki&pageid=d79ea7dd-d6d6-4646-b206-14df4c56aea7

 

Import by Scenario : https://help.acumatica.com/(W(1))/Help?ScreenId=ShowWiki&pageid=1deb1206-416a-4d8c-ac0d-09056aa65f0d

 


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3132 replies
  • June 26, 2023

Hello,

Based on your # of posts, you might be a beginner.  Welcome to Acumatica Community!

In addition to the Help links posted by Harshita, please watch Import Scenario videos on YouTube and/or look for training videos on Acumatica Open University. These videos will help you to quickly understand the import scenarios processes and screens.

Good luck!

Laura


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