Can i import a Sales Order through Visual Integrator by description rather than alias or item number?

Question

Can i import a Sales Order through Visual Integrator by description rather than alias or item number? How would this be done?

David Speck · Accepted Answer

Something else I have found is VI Imports do not properly handle escaped double quotes in delimited files. For example, if you export from excel to a CSV and a cell contains one double quote, excel escapes the double quote with an additional double quote. This causes the VI import to see two double quotes. Off the top of my head, I cannot remember whether or not VI import properly reads an escaped comma enclosed in double quotes but this is an additional reason the description is not recommended for this since descriptions tend to have commas, single quotes, double quotes, and even carriage returns and line feeds. You can attempt to handle these kind of exceptions either in the Alias item number or script but you have to be cautious and I would suggest testing in a test company copied from your production company to make sure you get the results you are expecting.

David Speck · Answer

There is a BOI (Business Object Interface) course on Sage U. This should give you a good foundation if you really want to get into scripting for Sage 100. 
 Most scripts are using VBScript. Perform Logic is typically done in ProvideX. 
 I have several posts on here with tips and there is also a document floating around on this forum and i think it still has a KB entry. It contains a lot of good information on basic methods, properties, and object handles. 
 You can also search on YouTube for some videos related to scripting for Sage 100 and Custom Office within Sage 100. I think Alnoor has a few good ones.

Sage 100

Can i import a Sales Order through Visual Integrator by description rather than alias or item number?

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING