Visual Integrator Export Automation

Posted By ssafm over 4 years ago

I would like to automate some Visual Integrator Exports. However, I need to use the Select Tab to make sure each time the export runs the correct records are selected.

I found the following formula helpful on the Sage Knowledgebase...and it works based on date. The formula below grabs the prior day's "stuff:"

EVS("DTE(JUL(day)-1)")

In my case however, I want to select based on month. In other words, on May 1st I would like to have my export grab all of April's "stuff." I have tried the following with no luck:

EVS("DTE(JUL(month)-1)")

EVS("DTE(JUL(mnth)-1)")

EVS("DTE(JUL(mth)-1)")

Anyone know how to grab a month's worth of data?

Thanks!

Top Replies

0 BigLouie over 4 years ago

It would be my suggestion to PULL the data using Access. Easier to schedule and you have more control and more options.
Cancel
Vote Up +3 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Kevin M over 4 years ago in reply to BigLouie

I agree with BigLouie. It is easier to pull the data using something like Access, Sage Alerts, Visual Cut... because VI exports are not very user friendly to work with.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Kentaro over 4 years ago in reply to BigLouie

I completely agree with BigLouie. If you have an access to the server and Task Scheduler, a script to execute an Update/Insert statement in ACCESS, EXCEL, or anything that can connect to a data source and accept API call could do this much easier than Visual Integrator. I've used SQL server express with Sage as a linked server, and called an upsert stored procedure from user defined script to have a copy of some sage tables available in real-time before also.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Visual Integrator Export Automation

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING