Create a CSV file from two tables

Question

Does anyone have any suggestions on how to create one .csv file from two tables? I need to access fields from both the SO_SalesOrder_Header and the SO_SalesOrder_Detail tables. I tried VI but it only accesses one table. Is there a way to access more than one table? We are trying to automatically create a .csv file using Sales Order fields that we then upload to ProntoForms. thanks!

rclowe · Accepted Answer

Hey MK Thrasher, 
 VI actually uses both tables if you begin the export with the Details table (opposite of how you would do an import). The Header tables are available if you create a VI job starting with the Details table. 
 You could use Big Louie's method, which is using a form of MS Query, or you could use Excel to create a file which you should then be able to save as a CSV. You would have to construct a query, preferably using the Detail table as primary, link in the Header table and voila! 
 Hope this helps, 
 rclowe

Sage 100

Create a CSV file from two tables

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING