Sage 100

I need to import into GL transaction entry for 8 companies. I have one source file that can specify the Sage Company ID. I know I can use a select statement to filter just the transactions I need for each company, but I'm looking for ideas to eliminate changing companies and running the import eight times. Could I chain imports in a batch file? Any ideas are appreciated.

You could create a batch file that would do it. 8 lines in the file, all reference the same job and file, but changing the company code

You could use a bat file with 8 command lines, each line specifying a unique company code. Posdibly use a pause statement between each command line.

Can certainly write a batch file but something in ancient memory warns me of stranded pvxwin files. Should I be worried?

Or maybe it was VI jobs that never complete.

I think v4.4 had that but we are doing VI imports in v4.5, 2013 and 2014 and the all work well (advanced and premium)

To prevent hung pvxwin32 or ""stranded"" sessions you could pause the command line using the timeout command. For example, if during testing the job for company abc takes 30 seconds to complete, add ""timeout /t 30"" (without the quotes) after the vi command line. This will allow the each instance of vi to complete before starting the next instance.

Thanks guys. This is great news.

Take a look at this thread from a little ways back: https://90minds-com.socialcast.com/messages/5525265