Sage 100

Has anyone successfully created a Visual Integrator export that automatically pulls either today's date, or yesterday's date?  I have an export that needs to run on a nightly schedule.

------------------------------
Susan Pawlowic
consultant
RKL eSolutions, LLC
------------------------------

Is Today's Date supposed to be on every record OR just the last one OR just the beginning one? All is possible with minor Perform Logic. But if you want to avoid that and assuming it should be on every record, here is 1 way. I believe a TEMP field cannot be exported as a column so what you export instead is an unused standard field or a string UDF that's long enough then set the Operation = Calculated then set Calc Expression =

DTE(0:"MM-DD-YYYY")

That gets you Today's Date. Change the date format as needed

------------------------------
Alnoor Cassim

Accounting Systems, Inc. (ASI)
Email: alnoor@asifocus.com
Orange County, CA
------------------------------

If your goal is to select records where a data field is equal to the current or prior date, then it is possible, the easiest way i've been able to do this is to set up your export like you normally would and on the select tab, add the date field you want to filter by. On the field's property dialog, set relation to Equal and leave the fields beneath it blank but check the User Input option.
Create a file somewhere either in MAS90\CM\Script or MAS90\VI to hold the following perform logic. Comment out the lines as needed.

! Prefix a line with ! to comment it out.
OPTION1$=DTE(0:"%Y%Mz%Dz") ! Use this for the current day's date.
! OPTION1$=DTE(JUL(DTE(0))-1:"%Y%Mz%Dz") ! Use this for the prior day's date.

Add perform logic on the "On Execution" type and use a relative path to point to the file you created to hold the perform logic.

For each "User Input" you enable on the select tab, the export program will populate an OPTIONx$ variable where "x" represents the sequence and you can set the values of these variables in the "On Execution" perform type.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

If they have Sage Alerts, this would be another tool they could use to export the data.

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 03-25-2020 16:19
From: David Speck II
Subject: Visual Integrator Export by Automatic Date

If your goal is to select records where a data field is equal to the current or prior date, then it is possible, the easiest way i've been able to do this is to set up your export like you normally would and on the select tab, add the date field you want to filter by. On the field's property dialog, set relation to Equal and leave the fields beneath it blank but check the User Input option.
Create a file somewhere either in MAS90\CM\Script or MAS90\VI to hold the following perform logic. Comment out the lines as needed.

! Prefix a line with ! to comment it out.OPTION1$=DTE(0:"%Y%Mz%Dz") ! Use this for the current day's date.! OPTION1$=DTE(JUL(DTE(0))-1:"%Y%Mz%Dz") ! Use this for the prior day's date.

Add perform logic on the "On Execution" type and use a relative path to point to the file you created to hold the perform logic.

For each "User Input" you enable on the select tab, the export program will populate an OPTIONx$ variable where "x" represents the sequence and you can set the values of these variables in the "On Execution" perform type.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------