Integration Manager: import to multiple companies?

[35mph]

We have a series of text files we want to import into a series of companies in Great Plains 8.0 using Integration Manager. Each text file corresponds to a company.

We have set up a batch file that automatically runs IM, and it works fine as long as we're logged into the company that we're importing into... but if we try to import into another company without being logged into that company, we get this message:

You have entered a corresponding Company ID that does not match any of the company IDs used on the distribution.

This message MAY be due to the fact that we have experiemented with the Intercompany ID field in IM to try to import in more than one company at a time...

I've seen reference to SQL Optimizer here... would that help us import into more than one company at a time?

 

[35mph]

Answered my own question... yes, we used SQL Optimizer, combined with a batch file that calls multiple integrations, and it works like a champ.