Greetings,

A quick review of that line of code indicates an issue issue opening or accessing the Excel file.  What is the path to the Excel file in the V/I Job and does Excel running on the client workstation that is executing the V/I job have access to that file location?

If you need further assistance, please open a case with Sage 100 Customer Support.

Thanks,

Kent

Make sure the file is not open in Excel when you run the import.  VI need the file to not be locked, which Excel does when it has a file open.

CSV is more reliable than XLS in my experience.

Try the instructions on the link below.  I don't think you need the header invoice amount, as this field is populated based on the line item amounts.

support.na.sage.com/.../viewdocument.do

awesome - this worked perfectly!!!   thanks!