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?
Best answer by darylbowman
View original
