Sage 100

Working with a client on 2013 Advanced. There is an VI export job for the inventory items, for which there are 3,861 items. When the job is ran, and the CSV file opened in Excel there are only 3,819 records. The export is item code and item code description. Just trying to figure out where the other 42 records went?

Are they miscellaneous item codes? They all live in CI_Item now.

Wild Guess: Are you navigating to the right location/file?

Data is coming from ci_item. I didn't believe the client either so I ran the job and opened the job they were right.

Why are you going to the trouble of using VI for this? You can do a lookup in item maintenance or inquiry and export that list to Excel. At the very least you could do that to compare with the records you are getting from your VI export.

I changed the job to put quotes around strings and ran the export again. This time I got 3,848 records.

@gene - they had job already set up. This is what they were using to decide when to renumber their inventory items. No one ever bother to see if the record counts were the same or even cared.

Are there 3861 records exported successfully when viewing the job log?

Yes the log shows 3861 records exported. It appears that several records are in the same rows for some reason.

There are so many ways to get data out of Sage 100 that I don't see the value in VI export jobs anymore. A simple ODBC linl to CI_Item via Excel or Access will get you the results you need. You can secure the ODBC access through Sage 100 security. You can make updating the data in Excel as easy as clicking on the refresh buttonin Excel. I understand that they have ""always done it that way"" but that's not a very good reason to not show them a better way. Just my 2 cents. Let the chiding begin.

Shawn - That's exactly what I did for this data. I spent 1 hour trying to figure it out using VI then I went straight to the DSN route this morning.