Skip to main content
Solved

importing data from external database into stock items screen

  • November 30, 2022
  • 1 reply
  • 119 views

Forum|alt.badge.img

Hi All,

I am looking to create an import scenario in Acumatica, all of our stock items and its details are present in quickbase. Can I create an import scenario so that Acumatica syncs with quickbase at regular intervals and updates/inserts new items produced in quickbase?

How can I achieve this integration without using CSV files?

 

Thanks

Best answer by Julia Lukina

Hello @atuljainajm, to reach this goal you can use Business Event Trigger by Schedule type (Create Schedule on Schedules tab) and which will run Import Scenario (Subscribers tab → Create Subscriber → Import Scenario). And it’s possible to Import by Scenario without using CSV files, for example, from MS SQL. More about Import Scenarios you can find in training I100 on the Acumatica Litmos portal (press Learn on the top of this page).

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

1 reply

Julia Lukina
Acumatica Employee
Forum|alt.badge.img+1
  • Acumatica Employee
  • 48 replies
  • Answer
  • December 2, 2022

Hello @atuljainajm, to reach this goal you can use Business Event Trigger by Schedule type (Create Schedule on Schedules tab) and which will run Import Scenario (Subscribers tab → Create Subscriber → Import Scenario). And it’s possible to Import by Scenario without using CSV files, for example, from MS SQL. More about Import Scenarios you can find in training I100 on the Acumatica Litmos portal (press Learn on the top of this page).


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