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.
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".
*Community Hub is the new name for Sage City