If you're interested, what I did some years ago was create Perform Logic to parse out the Failed and Passed with Invalid Fields records from the VI Job Log and write it as a friendly text file. Then either I email the log as an attachment to a UDT email distribution list OR let you sweep the file with Visual CUT or similar to email it yourself. 

If interested I'll privately send you a sample. I could adapt it to export to a table instead so you can do your own reporting. 

Also BTW, I have Slade's old Perform Logic that  BigLouie mentioned. It's for legacy module imports only and like both of you suspected it is like VI-1001 where the record data from the Job Log is translated to a single field and you get the blow by blow detail for each record.

Hello Alnoor, if the sample Perform Logic to parse out the Failed and Passed with Invalid Fields records from a VI job log is still available I'd sure be interested in it.  My client is importing AP invoice transactions and wanted to have some visibility to any errors that didn't make it into the AP batch.  The client is currently on Sage 100 v2018.  Thank you.

Hi Alnoor,

I second what Paul says here. I'm setting up a VI job to run twice a day, with the intention of increasing the frequency as they get more and more invoices and orders. They also are on 2018, but Premium. We are about to move them to 2021 Premium.

Thanks

Hi Alnoor,

I second what Paul says here. I'm setting up a VI job to run twice a day, with the intention of increasing the frequency as they get more and more invoices and orders. They also are on 2018, but Premium. We are about to move them to 2021 Premium.

Thanks