Custom report based on VI job logs?

Posted By Kevin M over 7 years ago

I'm trying to set up a report for an alert, after running an automated VI import. The customer (v2014 Premium) wants to know if there are any failed / invalid records. I know the data is available, because the UI can produce reports based on job results, but I can't find a way to build a custom report for this. It seems the logs are in ProvideX files, even though the customer is Premium, with no ODBC exposure... \MAS90\VI\VIWI##.m4t (and not VI_JobLog.M4T as I originally suspected).

I know I can query SY_ActivityLog for some basic header information, but I believe that only shows failed lines, not lines imported with invalid fields (which are an important consideration for such an alert).

I see DSD has an old enhancement for moving the data from ProvideX to a text file, but I'm hoping for something more report-friendly.

I've looked briefly into this before, but we really need something this time. Does anybody have a solution? (And why is this data still in ProvideX, when the system is Premium?!?).

0 BigLouie over 7 years ago

Why indeed. I remember that the Obe Wan of MAS90, Slade once had a perform logic job that translated the VI job file to a text file. Not sure if anyone has that code or if it can be updated. Maybe some of the old hands might have something otherwise DSD is it.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Kevin M over 7 years ago in reply to BigLouie

That sounds similar to how the DSD enhancement (VI-1001) is described.

I'm sensing a potential "quick win" fix for there to be proper VI job logging (available for custom reports) in a future release.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mhainesalt over 6 years ago

Is there anything new on this issue?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Kevin M over 5 years ago in reply to mhainesalt

I wish there was!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Alnoor over 5 years ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Paul Smith - Bretthauer over 2 years ago in reply to Alnoor

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rclowe over 2 years ago in reply to Paul Smith - Bretthauer

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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Custom report based on VI job logs?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING