Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Update a UDF Field with Visual Integrator based on Customer Number
In Access, link externally to the Mas200 AR1_CustomerMaster table. Create a query with your table and the AR1_CustomerMaster table with a link between the two Customer Numbers. the fields in the Query would be Division,CustomerNumber & AccountNumber In VI, use this query as the input table...- TomAlford
- Post #4
- Forum: Sage 100 ERP (fka Mas90/Mas200)
-
Update a UDF Field with Visual Integrator based on Customer Number
If you have your access table linked to AR1 as an equal join, VI will import only matched numbers and write the UDF record. The UDF fields are on the end of the AR1 file so you import the Division,Customer and UDF fields from the query.- TomAlford
- Post #2
- Forum: Sage 100 ERP (fka Mas90/Mas200)
-
Visual Integrator - Executing job from external application
Here is the method I use to run VI externally from the desktop: Target: C:\Ma90W\MAS90\HOME\PVXWIN32.EXE ..\LAUNCHER\SOTA.INI ..\SOA\MAS90 -ARG VIWI00 W 0 DIRECT AUTO XXX Start In: C:\Ma90W\MAS90\HOME VIWI00 - Visual Integrator identifier XXX - Company Code in Mas90 Note: If there are spaces...- TomAlford
- Post #3
- Forum: Sage 100 ERP (fka Mas90/Mas200)
