Browse By Tags

  • How to find the name of the SQL view related to a lookup

    If you are interested in finding the name of the SQL view associated to a given lookup view screen, here are a couple of ways From System Manager , Maintenance , Maintain Lookups and click on the lookup flashlight. In the Lookup column, locate Vendor…
  • How to create a custom lookup in Sage 500 ERP

    This month we will look at how to create a customized lookup. The customized lookup will help your Sage 500 users streamline their searching when performing lookups. The following example is in the Maintain Vendors lookup used throughout various tasks…
  • Price Level Description on Price Level List Lookup

    We have some standard price level codes we use that are set up for each item, if you are a wholesaler you get X price, MSRP has its own price code, etc. The descriptions for these codes are universal, W always would be described as wholesaler for example…
  • VI Import Question

    I am currently new to VI and looking to see if there is a lookup function that would determine a value to be passed during the import based on a value found in the import file. As an example, the import file that has been provided includes an account…