PCard Vendor Setup
Use this option to link vendors from the Vendor List table to bank layouts and merchants. These links prevent errors when you import files from your PCard provider. While you can create vendor-merchant links in the PCard Batch Errors page, you may find it easier to use the PCard Vendor Setup option.
The term merchant refers to the specific location where a purchase was made, as defined by your PCard provider. The system cannot recognize a merchant until it is linked to a vendor in the Vendor List. These links are required in reconciling transactions and creating Batch Accounts Payable records.
If a merchant has multiple locations, you can link all the locations to the same vendor. However, only one vendor can be linked to a merchant.
After you specify a bank layout, the records displayed in the PCard Vendor Setup include merchant records that are not linked to vendors. You can identify the unlinked records by the fact that they do not have a vendor code.
If your PCard provider does not identify merchants, you can use the PCard Vendor Setup option to link vendors to the bank layout record.
Menu Path: PCard Processing > Reference Tables > Reference Tables > PCard Vendor Setup
Page Sections
The PCard Vendor Setup page includes the following sections:
Field | Details |
Search Criteria | Enables you to search for merchant records associated with bank layout formats. |
List (untitled) | Lists vendor-merchant records found in a search. The records shown were created with either the PCard Vendor Setup or in the PCard Vendor Linking page provided with the PCard Batch Errors, PCard Reconciliation, and PCard Entry Reconciliation options. |
Bank Layout Vendor Information | Enables you to associate vendors from your Vendor List with a bank layout format. |
PCard Vendor Information | Enables you to link vendors with the merchants where PCard transactions are made. These links enable the system to recognize the merchant codes in PCard reconciliation files. |
Following are procedures for adding, listing, updating, deleting, and printing vendor-merchant records. If you want to link a vendor to a merchant after importing a reconciliation file, follow the procedures for listing and changing records.
Adding a vendor-merchant record
Select PCard Processing > Reference Tables > Reference Tables > PCard Vendor Setup to display the PCard Vendor Setup page.
Click Add New.
In the Bank Layout Vendor Information section:
Field | Details |
Bank Layout | Select the bank layout format you want to use. This selection provides the link between the vendor and the layout record. |
Vendor Code | Enter the vendor's code. If needed, use Lookup to display the Vendor Search page for selecting a code from the Vendor List. |
The vendor's name and address display when you enter the vendor code. This information can only be changed in the Vendor List.
In the PCard Vendor Information section, all of the fields are optional:
Field | Details |
Merchant Code | Code identifying the merchant. Character/25 |
Merchant Name | Name of the merchant. Character/30 |
Address 1 | Merchant’s first address line. Character/30 |
Address 2 | Merchant’s second address line. Character/30 |
City | Merchant’s city. Character/20 |
State | Merchant’s state abbreviation, from drop-down list |
Zip | Merchant’s zip code. Character/10 |
Leaving the fields in this section blank allows you to link a vendor to a PCard if your reconciliation file does not include merchant information for the vendor's transactions.
If you are adding multiple records, select the Continuous checkbox. Otherwise, leave the box blank.
Select OK to save the record.
If the Continuous checkbox is selected, add another record by repeating Steps 3-6.
Searching for and listing PCard vendors
Select PCard Processing > Reference Tables > Reference Tables > PCard Vendor Setup to display the PCard Vendor Setup page.
In the Search Criteria section's Bank Layout field, enter a code to identify the format associated with the vendors.
To select multiple formats, insert the pipe symbol between codes, for example, 1001|2002|3003.
Leave the Vendor Number field blank, unless you want to list specific vendors for the formats selected.
Select Find to list all vendors associated with the formats.
Important
If a record displays with a Merchant Code but no Vendor Code, then the merchant identified needs to be linked to a vendor before you can reconcile any file containing the merchant. To create the necessary link, follow the next procedure.
Updating merchant information
Complete the procedure above for searching for PCard vendors.
In the List section, select a vendor, and then click OK.
The Bank Layout Vendor Information section is display only if the current record includes a vendor code, whether a merchant is linked or not.
However, if a merchant is associated with the record but a vendor is not, then you need to add a vendor in the Vendor Code field. This links the merchant with the vendor.In the PCard Vendor Information section, update the fields as needed.
You cannot change the Merchant Code field. For other information on these fields, refer to Step 4 in the add procedure.If you are adding multiple records, select the Continuous checkbox. Otherwise, leave the box blank.
Select OK to save the record.
If the Continuous checkbox is selected, information for the next vendor in the List section displays. Repeat Steps 3-6 to update the vendor's record.
Deleting a PCard vendor
Complete the procedure for searching for PCard vendors.
In the List section, select the vendor to delete.
Select Delete.
In the Confirmation dialog, click Yes.
Generating the PCard Vendor Link Report
Complete the procedure for searching for PCard vendors.
Select Print.
In the Print window, specify how to generate the report, and then select OK. The report's default file name is pcd_vendor.rpt.
The report lists the following for each record: vendor code, vendor name, merchant code, and merchant name. The records are sorted by vendor name. If more than one format is specified, the records for each format appear on separate pages.