Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Any person or company that sells goods or services to your entity?????

Fields on the vendor Record

...

Vendor Number - stores the number assigned to each vendor. Vendor numbers must be numeric and can contain up to six digits. The vendor number will be automatically assigned to (using highest vendor # on file in USASDAT/USACON) to the next available number on file unless you override the auto assign by entering a desired vendor number. Vendor numbers 900000-999999 are reserved for memo vendors and tracked seperately in USASDAT/USACON on the highest memo vendor # on file field. Only memo checks may be written to a vendor with a vendor number between 900000-999999. No printed check form is generated.

Status - signifies if the vendor is an active or inactive vendor. If the Inactive status is selected, it will disallow requisitions and purchase orders any transaction from being processed against this vendor. The default status is Active.

...

Postal Code - is the zip or postal code for the vendor. If the country field is blank or a variant of U.S.A., then the cost must be a correctly formatted U.S. zip code (5 digits plus optional 4-digits). Oth-erwiseOtherwise, it can be a postal code for any country.

...

1099 Type: If the vendor is not a 1099 vendor, the default type of non-1099 should be used. If the vendor is a 1099 vendor, click on the down arrow next the 1099 Type field to select from the following 1099 types:

Non-Employee Compensation

...

ID# - is the vendor's Federal IRS identification number or social security number.

Tip

The ID# will display ********* for any read-only or requisition-only users.

Override - If it's set to "Yes", the vendor should have a 1099 reported regardless of the Calendar Year-to-date amount. The default option is set to "No."

...

Multi-Vendor Flag- if set to "Y" means that it does not represent a real vendor, but is meant to be used for Multi-Vendor/Blanket Purchase Orders. The default option is set to "No."

...

Note

A vendor must always be a multi-vendor (or not multi-vendor). The system will not allow a user to change classifications once used

...

 

Child Support Flag - ndicates indicates if an outstanding child support order has been received for the vendor. If set to "Y", a warning indicating child support may need to be withheld will be displayed when pro-cessing processing purchase orders as well as invoices.

...

New Hire Flag - is used for vendors that need to be reported to the Ohio Department of Job and Fam-ily Family Services. The "non-reportable" setting is the default setting. "Reported" indicates the vendor has been reported. "Reportable" indicates the vendor needs to be included in "New HIre" reporting.

...

User Code 1 and User Code 2 - are optional 2 character fields for the district's own use.

...

Create Vendor


  1. From the Core menu select 'Vendor'
  2. Click on 'Create' (hyperlink)
  3. Enter in desired information into the vendor
  4. this is what is the minimal requirement
    1. Vendor #
    2. Vendor Name
  5. Click on Save (hyperlink) to post the vendor to the system, click on Cancel to not post the vendor and return to the Vendor Query.

Query

...

Vendor

The Vendor Query allows the user to search for vendors that have been posted to the USAS system. It is necessary to first query a vendor in order to do any of the following:

  • View the details of an existing vendor
  • Make modifications to an existing vendor
  • Delete an existing vendor
Info

There is an indication above the query, indicating which fields work with wildcards

To search for a vendor, select the Query option. The following options are available:

  • Search - you are able to search by "name" or by the "sounds like" options. If you know the name you can enter it. If you are unsure, choose the "sounds like option" and type in what the vendor name sounds like, and this option will pull all vendors that sound the same. You may use asterisks '' as a wildcard to find vendors containing a value. For example, enter '*office' in Search would select re-cords with 'office' anywhere in the vendor name.
  • Starting/Ending Vendor # - enter beginning and/or ending vendor number to select a range of vendors
  • Address - enter the vendor street address to select vendors by vendor address. You may use asterisks '' as a wildcard to find vendors containing a specific street address value. For example, enter '*main' in Address would select vendors with 'main' anywhere in the street address
  • City - enter the vendor city to select vendors by city. You may use asterisks '' as a wildcard to find vendors containing a specific city. For example, enter '*Sampleville' in City would select vendors in the city of Sampleville.
  • State - enter the State to select vendors by a specific State. The state field will only accept the two-characters code for the state (i.e. OH for "Ohio")
  • Zip - enter the Zip code to select vendors by a specific Zip Code.
  • Phone - enter a Phone Number to select a vendor by phone number.
  • Category - enter the 2-character Category code to select vendors by a specific Category.
  • Starting/Ending Last Activity Date -enter beginning and/or ending last activity date to select a range of vendors within the LAD range.
  • Starting/Ending Fiscal YTD Total - enter the beginning and/or ending Fiscal YTD total dollar amount to select vendors within that range
  • Starting/Ending YTD Total - enter the beginning and/or ending calendar YTD total dollar amount to select vendors within that range
  • Status - to select vendors by Active, Inactive status or Both
  • Maximum Vendors Displayed - you have the option of displaying up to 250 vendors per query. The default number returned is 50.

Image Removed

Tip

Vendor Query also has an expand/collapse button in the upper right hand corner. If the query screen is taking up to much space you can collapse the query by clicking on the collapse button.

Image Removed
Once the vendors have been queried, it will display the list of the vendors queried with other summary type information as shown below:

  • Number - displays the vendor number used in creating the vendor. Click on the vendor number to view the details of the vendor, as well as to modify or delete the vendor.
  • Name - displays the vendor name used in creating the vendor. You may also click on the vendor name to view the details of the vendor, as well as to modify or delete the vendor.
  • Phone - displays the phone number entered when creating the vendor.
  • Address - displays the vendor street address entered when creating the vendor. You may also click on the vendor address to view the details of the vendor, as well as to modify or delete the vendor.
  • City - displays the city entered when creating the vendor.
  • State - displays the abbreviated state code entered when creating the vendor.
  • Zip - displays up to the 9 digit zip code entered when creating the vendor.

Modifying Vendors

Vendors Please refer to Query for more information on how to query a record.
 

Edit Vendor

Vendors that have been previously posted to USAS may be modified through be edited through the USASWEB applica-tion. In order to modify a vendor, it must first be queried by selecting the "Query" option under the main Vendor menu. Please refer to the "Query Vendors" section for help on selecting vendors to be queried. Once the vendors has been queried, it is selected by clicking on the vendor number, name or address.
Image Removed

Click on the Modify button located under the Vendor Details menu. Once you have selected to modify, you may modify all of the fields except for the vendor number. Once you make the changes to the vendor, click on Accept to accept and post the changes made or click on Cancel to leave the vendor as is.

Deleting a Vendor

The Delete function may be used to delete a vendor.application.  Only fields that are allowed to be edited will be displayed

 Please refer to Navigation for information on how to 'Edit' a record

Delete Vendor

Warning

It is not recommended to delete old vendors since this might destroy an audit trail. If the vendor number is re-used, reports from prior fiscal years will not match current vendor information. We recommend changing the status from "active" to "inactive" instead.If you choose to delete vendors, it's important that you run the DELVEN program prior to deleting a vendor. The DELVEN program will list the vendors that have no activity against them.

In order to delete a vendor, the vendor must be queried using the "Query" option located under the main Vendors menu. Please refer to the "Query Vendors" section for help on selecting vendors to be queried. Once the vendor has been queried, it is selected by clicking on the vendor number, name or address. The vendor details will be displayed in your browser. Click on Delete to delete the vendor.
A pop-up window will be displayed confirming that you want to delete the vendor. Click on OK to delete the Delete function may be used to delete a vendor.