Office vendor numbers fields are useful for including additional identifying information about your vendors. Larger companies often require multiple office vendor number fields because they have multiple AP centers using different AP systems, such as Oracle and SAP. Also, some companies need multiple office vendor numbers fields if they require confirmation of a vendor number and some other data (such as a vendor's zip code). To accommodate this, Tracker lets you create unlimited office vendor number fields for the company's law firms.
There are four major steps to setting up office vendor numbers in Tracker:
Create and name the office vendor number fields.
Configure the AP routes to require office vendor numbers to ensure that the office vendor number information is included for every invoice that is assigned to that AP route. For example, you would want to require the "SAP Vendor Number 1" Office Vendor Number for the "SAP" AP Route.
Set the values for the office vendor number fields for your individual vendors. You can complete this step for each vendor or by using the Bulk Update feature.
Configure the Invoice Spreadsheet format to include the office vendor number fields. This step is necessary for your AP system to receive the office vendor numbers
The office vendor number fields in an office profile can be blank, and there will simply be no office vendor number in the invoice spreadsheet. However, if a firm submits an invoice that is assigned to an AP Route for which office vendor numbers are required, then the invoice cannot be fully approved until a number is provided.
Creating Office Vendor Number Fields
To use vendor numbers in Tracker, you must first create and name the required office vendor number fields.
To create office vendor number fields:
Select
Settings
in the left navigation.
In the
Accounting and A/P Settings
section, select
Office Vendor Numbers - Field Names
.
On the toolbar, click
New multiple values
or
New value
.
In the
Value
or
Values
field, type the new values. To enter multiple values, press Enter on your computer's keyboard after each value.
On the toolbar, select
Save & close
..
Editing Office Vendor Number field names
Select
Settings
in the left navigation.
Under
Accounting and A/P Settings
, click
Office Vendor Numbers - Field Names
.
Click the name of the field name you would like to edit. If it does not appear in the list, ensure that the appropriate option appears in the
Table Filter
then click
Change View
.
Edit the name you want to update.
On the toolbar, select
Save & close
.
Configuring AP Routes to Require Office Vendor Numbers
Office vendor numbers can be required for individual AP routes. If the numbers are required, then every invoice that is assigned to that AP route must include the required office vendor number information, or it cannot be fully approved.
To require office vendor numbers for an AP route:
Select
Settings
in the left navigation.
Under
Accounting and A/P Settings
, click
AP Route Configuration
.
Under
Step 3: Routing
, click the name of the AP route that you want to configure. The page opens to edit the AP route.
Under
Step 3a: General Options
, click
Select next
to
Required Office Vendor Numbers
, and check the appropriate office vendor number names.
Select
Settings
in the left navigation.
Entering or Editing Office Vendor Numbers
You can enter the office vendor numbers for each firm or vendor individually, or you can use the Bulk Update feature to enter many values at once. When you bulk update the numbers, you first select which office vendor number field you want to populate, and then you enter the numbers for all the vendors.
To enter a value for one firm:
Select
Firms > Our firms
in the left navigation.
Click the name of the firm or vendor for which you want to enter an office vendor number or numbers.
On the toolbar, click
Edit Office Profile
.
In the
Vendor Office ID
field, add or edit the vendor numbers you want to update.
On the toolbar, select
Save & close
.
Displaying a List of Office Vendor Numbers
Select
Firms > Our firms
in the left navigation.
On the Firms list page, select the name of the firm whose office information you want to show.
Select the
Offices
tab. The
Vendor #
field shows the vendor number for each office in the list.
Click
Users > Bulk Update
in the left navigation
Under
Step 1: Select a Field to Update
, select the office vendor number field that you want populate for multiple firms.
Click
Generate List
. The list of firms appears.
Enter the office vendor numbers you want to update.
On the toolbar, select
Save & close
.
Configuring the Invoice Spreadsheet Format to Include Office Vendor Number Fields
For the AP system to be able to receive the office vendor numbers, you must configure the invoice spreadsheet format to include the office vendor number fields. For example, you would create an "Oracle" invoice spreadsheet format that includes the "Oracle Site Number" and "Oracle Vendor Number" fields. Then you would assign that invoice spreadsheet format to all AP routes that should include the Oracle numbers.
To configure the invoice spreadsheet format to include office vendor number fields:
Select
Settings
in the left navigation..
Under
Accounting and A/P Settings
, click
AP Route Configuration
.
Under
Step 2: Formatting
, either select an existing invoice spreadsheet format or click
Create New Invoice Spreadsheet Format.
Scroll down to the
Standard Rows
section, and under
Column Name/Data
, select
Office Vendor Number - Office Vendor Number
.
Next to that field, select the name of your office vendor number field. If you want to add multiple office vendor number fields to your spreadsheet, repeat steps 4 and 5.
On the toolbar, select
Save & close
.