Visual Integrator: Creating a job that imports invoices into AP Invoice Data Entry

Question

Hi all, 
 I hope everybody is doing well. I apologize in advance if I post this in the wrong section. 
 I recently discovered the Visual Integrator module for Sage 100 and have been trying to learn how to create a job that imports an Excel spreadsheet containing invoice information into AP Invoice Data Entry. I've followed multiple tutorials online but I seem to be running into the same error. I feel like I'm on the cusp of success but am just missing a minor detail or two. Perhaps somebody can spot the error I am making in the process. Here are some screenshots below to help illustrate my process below: 
 Excel Spreadsheet Template that I am attempting to import with Visual Integrator: 
 
 Data settings: 
 
 Results of job test:

Record Detail displaying error message for each line:

Please let me know if further clarification is needed for anything. I'd really appreciate some guidance on this matter. 
 
 Thank you!

BigLouie · Answer

A bit more. If you do not use divisions then in the import you must set Divisions as Assigned with a value of 00. In your case you are have the import job read the column and you have 01, 02, 03, 04 and 05 which are NOT valid in a setup not using divisions, hence your error message.

Kevin M · Answer

If your import job is set to a delimited file type as the source, be sure to Save As a CSV and use that as the source. XLS / XLSX files are not the same as CSV.

rclowe · Answer

Judging from the error message it appears you don't have the Option set in AP Options to use Divisions. Is that possible? Remember that VI is a system module so it will only be able to import into the company you are logged into. Maybe you set this job up for a different company in Sage?

CJElliott1994 · Answer

Hi! Good news is you almost have the puzzle solved, the below solution should fix the error you're getting (it will also correct the error related to VENDOR/INVOICE #: 
 - APDivisionNO you should not be replacing the value, this value should be defaulted to assign with value of 00. 
 - Column B , although you're assigning value of 00, you need to make sure you have the column populated with data or it will pull everything over a row. Replace all the division NO's you had to 00 (convert column to text). 
 Hope this helps! I highly suggest doing this in test company since you're importing to the GL!

Sage 100

Visual Integrator: Creating a job that imports invoices into AP Invoice Data Entry

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING