Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Voyager to Alma Migration Query: Identify Vendors with no currently attached POs or Invoices

    Created By: Laura Guy
    Created on: 7/09/2020



    When migrating from Voyager to Alma, you may wish to identify and delete Vendors that have no Purchase Orders or Invoices.

    This query, which you can run in Voyager's Prepackaged Access Reports, will display such Vendors.  It also shows vendors that DO have purchase order or invoice activity.  So you get a two-fer with this query.

    SELECT VENDOR.VENDOR_NAME, VENDOR.VENDOR_CODE, VENDOR_TYPES.VENDOR_TYPE_DESC, Vendor_Usage_POcount_sq.CountOfPO_ID AS poCount, Vendor_Usage_POcount_sq.MaxOfPO_STATUS_DATE AS lastPOstatus, Vendor_Usage_InvCount_sq.CountOfINVOICE_ID AS invoiceCount, Vendor_Usage_InvCount_sq.MaxOfINVOICE_STATUS_DATE AS lastInvoiceStatus
    FROM ((VENDOR INNER JOIN VENDOR_TYPES ON VENDOR.VENDOR_TYPE = VENDOR_TYPES.VENDOR_TYPE) LEFT JOIN Vendor_Usage_InvCount_sq ON VENDOR.VENDOR_ID = Vendor_Usage_InvCount_sq.VENDOR_ID) LEFT JOIN Vendor_Usage_POcount_sq ON VENDOR.VENDOR_ID = Vendor_Usage_POcount_sq.VENDOR_ID
    ORDER BY VENDOR.VENDOR_NAME;

    If you need assistance in running custom SQL queries in Prepackaged Access Reports, consult the Voyager Customer Listserv.