Validating an External List of Parts in the Product File

If you have a list of part numbers and you want to make sure they are all setup in your product file then you can use the ‘/VP’ option within Product Stock Inquiry to validate each number. The external file should contain the manufacturer and part number and be csv (comma separated value). If you’re part numbers are all the same manufacturer then you can leave the manufacturer out of the external csv file.

While in Product Stock Inquiry and at the part number prompt type ‘/VP’ <enter>.

Enter the filename containing the part numbers to be validated. By default, the feature will display any part numbers NOT found/validated. Add a ‘/F’ to the filename to display ONLY those part numbers FOUND. Add a ‘/B’ to display all parts numbers .

Enter the column number where the program can find the manufacturer code of each part number. If you’re file only has part numbers AND they are all the same manufacturer then you can enter a ‘fixed’ value (example – BS/F = BS fixed).

Enter the column number where the program can find each part number.

The following display is the default, showing ONLY those part numbers NOT found/validated.

The following display is the ‘/F’ option, showing ONLY those part numbers found/validated.

The following display is the ‘/B’ option, showing ALL part numbers.

Several options are available when the popup displays. For example, ‘//P’ prints the data (filename POPUP.LST) in the popup AND creates a csv file (filename POPUP_LST.CSV) of the data in the popup.

This entry was posted in Uncategorized. Bookmark the permalink.