I successfully created a data provider for an external SQL database and can retrieve data using an import scenario. However, I’m struggling to build a Generic Inquiry (GI) that combines data from both the external database and Acumatica tables.
My goal is to create a GI that pulls accounts on hold from our external production management system and compares them to the same account numbers in Acumatica. This would help our accounting team identify which accounts need to be placed on hold in Acumatica—an initial step toward future automation.
Given that import scenarios can access external data, I would expect this to be a straightforward task. Any guidance on how to achieve this would be greatly appreciated.
Thanks in advance!
