Sage 100

VI exports all blank records. Client is on 4.4 PU9. Have created several export jobs, all very simple, like: customer number, customer name, price level from AR_Cust or Item code, item description, std price from CI_Item. Exports are from invoice history header and detail, sales order history header and detail, item warehouse, item history tracking, ALL jobs produce a csv file with only commas. The file contains the correct number of records, but no data. Does not matter what source file is used. Does the same thing on a different company on the client system. Does the same thing as ascii or delimited. Exported the jobs and imported to a test system in our office and the VI jobs were corrupted. After re-selecting the fields that were originally on the VI job they work fine in our office. Any ideas?

ODBC secruity????

V/I doesn't use ODBC does it?????

Seems like this might be a dictionary problem. How does one rebuild the VI dictionaries?

To re-compile Data Dictionaries: File>Run: svcmpl Does the same thing happen from another workstation / server? Another MAS user logon? What about a legacy module (e.g., Payroll, Job Cost)? What happens if you try a basic Crystal Report with Customer data?

Crystal is working fine. The issue occurs only when exporting records with VI. I will try to re-complie the dictionaries. Thanks.

After re-compiling the data dictionaries I still have the same problem. Still getting blank records on all the VI jobs.

What happens if you recreate the job on their system? Or create a job from the same source with just a few fields?

@RobertWood the imports are very basic already. Have created and recreated with same results. We copied their MAS system to our server and will do some more testing. Very weird!

Reinstall and Migrate works. Can anyone think of an easier solution?