Skip to main content

We are creating an automated process for importing BOMs into Acumatica. The data for these BOMs sit in SQL and we are creating an SQL view for all recently uploaded or modified BOMs.

Our goal is to create an automated schedule that imports these BOMs daily.

I will be creating a business event and schedule, but once I get to create the subscribers I’m seeing that the screen associated with the Business Event becomes the data provider of the import scenario. My data provider for the import scenario needs to be the SQL provider.

Is there any way to use an automation schedule to trigger an SQL import using SQL provider? Will I need to create a custom GI for the SQL data which then would flow as the data provider of the import scenario?

Rather than using a Business Event, I believe you simply want to build an Import Scenario and then schedule it to run periodically from the Process Import Scenarios screen (SM206035). Just make sure when building the schedule to include a filter on the name of the Import Scenario you wish to run. I’ve already accidentally processed all Import Scenarios trying to set one up.

Reply


Terms & ConditionsCookie settings