You can run a query in the UGA Financial Management System to locate a supplier address using either the supplier name or the supplier DBA name.
Tutorial Resources
Supplier Does Business As (DBA) Name List
In this article, you will learn the steps to run the UGA_AP_SUPPLIER_ADDRESS query to search for the address of a supplier in the UGA Financial Management System.
First, log into the Financial Management System.
From the UGA Financials page, click the Query Viewer tile.
The Query Viewer page is displayed.
Enter the first part of the query name into the Search field. Enter " UGA_AP_SUPPLIER ".
Click the Search button.
The search results are displayed.
Click the HTML link next to the UGA_AP_SUPPLIER_ADDRESS query.
Note : You can choose the method through which you want to display the query results. HTML will display the results on the same page. Excel will generate and display the results in an Excel file. XML works the same as Excel, except it generates the information as an XML file.
The UGA_AP_SUPPLIER_ADDRESS query page is displayed. On this page, you will enter the supplier information as search criteria.
Enter the supplier's name into the Supplier Name field.
Example shown here: " PRINT ".
With the appropriate information entered, click the View Results button.
The query results are displayed. Data includes Supplier/Vendor number, supplier name, and supplier address information.
If you believe the supplier you are looking for goes by a different name, enter the appropriate information into the Additional - DBA name field.
Click the View Results button.
The query results are displayed. If the desired supplier is still not displayed, adjust your search criteria.
If you are still unable to locate your supplier, contact the Project Coordinator in your unit or contact the OneSource Service Desk.