Work Order VI Import - Validate Routing Number

SOLVED

Sage Erp 100 2014

Does anyone know how a VI job for work order can validate that the Routing number being imported already exists in the Routing Maintenance file and fails if it does not exist?

Thank you in advance.

  • 0
    verified answer

    It should do that automatically.  I didn't have time to create a complete VI job.  I only created an import job that had work order number and routing number and did a 'Test'.  When the routing number in my import file was not on file, the log file correctly showed "FAILED".