x Want to participate? Join the group to interact
Options
  • State Verified Answer
  • Replies 7 replies
  • Subscribers 108 subscribers
  • Views 726 views
  • Users 0 members are here
Browse Forums
Announcements
293
topics
370
replies
Business Object Interface
1k
topics
7k
replies
Core Financial Modules
2k
topics
8k
replies
Customization and Productivity
3k
topics
12k
replies
Distribution, Manufacturing, and Applications
2k
topics
7k
replies
General Discussion
1k
topics
3k
replies
Partner Cloud
45
topics
91
replies
Payroll, Time Tracking, and Job Cost
777
topics
1k
replies
Reporting and Analytics
962
topics
3k
replies
Sage CRM for Sage 100
164
topics
357
replies
Technical and Installation
2k
topics
9k
replies
Year-end Forum
89
topics
237
replies
alps_it

VI Help - Not returning any data

SOLVED
Posted By

We are trying to setup a VI export job to bring out 10 fields from the AP_PaymentHistoryWrk table.

We do see data in the AP Payment History report which uses this table so I'm not sure why the VI export is blank.

The job is setup as follows:

We have nothing configured on the Select or Sort screens.  I will eventually filter it down to only return the data for the past 14 days but first I need to figure out why it's not returning anything.

The resulting text file will be used to bring the details into another system for outside review.

Would someone be able to point me in the right direction?

Thanks!

  • +1
    verified answer

    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.,

  • 0 in reply to btmlinesoft

    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.

  • 0 in reply to alps_it

    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.

  • 0 in reply to btmlinesoft

    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.

  • 0 in reply to alps_it

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

  • 0

    You'd need a combination of AP_CheckHistoryHeader and AP_CheckHistoryDetail.

  • 0 in reply to alps_it

    Actually there is a way to export the works table.  First you preview the report. Leave it open. Then go to the Sage 100 folder on the server and find the MAS_XXX folder where XXX is the company code. Then go to the AP folder and look for the AP_PaymentHistoryWrkXXX????  which has the user code and the time stamp.  Rename the existing AP_PaymentHistoryWrk to .BACK and the rename the report with the user code and time stamp to take out all that. You can now pull the table with Excel.  When finished delete the file and rename the table taking out the .BACK

*Community Hub is the new name for Sage City