How to link tables in Visual Integrator
Description
Cause
Resolution
  • Open Visual Integrator, Main, Export Job Maintenance
  • Open or Create Export Job
  • Click Link button on Configuration tab
  • All Key Fields of Link Table Name must exist in Primary Table Name to create a proper link
    • Key fields can be determined by examining File Layouts under Resources on the Sage 100 Desktop
  • Enter a Sequence Number
    • 00 can be used if table is not already linked
  • Create an expression using all Key fields of Link Table Name separated by +
    • Example: ARDivisionNo+CustomerNo
Steps to duplicate
Related Solutions