A WRK table?  A WRK table is a temporary table used when generating the actual report.  And when it is used, the actual table populated is something like AP_InvoiceHistoryWrkJAS021507991840.M4T.  Bottom line, the VI will never work.  I would suggest you pull from the actual history tables or even use an Excel query to pull the data.,

Thank you, I didn't realize WRK meant it was a temporary table.  Unfortunately Excel or ODBC aren't an option at this point since we need to be able to automate exporting the data to bring in to another system which only supports text imports - or at least it's beyond our in-house skill set.  is the data stored in another table that I could export it from?  I couldn't see one that had all of the fields in the Sage docs and I'm new to VI so I'm not sure how (or if you can) combine data from different tables.

AT this point, I recommend getting your reseller involved to assist.  What you are trying to do is not unusual so your reseller probably has done it for someone else.  We use Access to extract data into the desired file type, we use Sage Alerts and Workflows.  There are other tools as well.

We unfortunately don't have a reseller.  I appreciate the info and advice, I'll keep playing with it and see what I can come up with.  Thank you.

We unfortunately don't have a reseller.  I appreciate the info and advice, I'll keep playing with it and see what I can come up with.  Thank you.

Sage Software can point you toward the name and contact of your reseller or record.  Every Sage 100 sold is aligned to a reseller.