Vendor Record
  • 27 Aug 2024
  • 16 Minutes to read
  • Dark
    Light
  • PDF

Vendor Record

  • Dark
    Light
  • PDF

Article summary

The vendor record is where specific information related to a vendor resides in the system. Enter all necessary details as they pertain to each vendor. Vendors can also be organized into vendor groups for filtering purposes on the Payment Run screen.

Once a vendor group has been created, it cannot be edited or deleted. Therefore, ensure that vendor names and groupings are accurate before creating a group.


Navigation

To add a new vendor, 

  • Hover over the Vendor tab in the top ribbon and select New Vendor.
    The new vendor record opens in a new window.

To view or edit an existing vendor, 

  • In the Accounts Payables section of the left navigation pane, select Vendors
    The Vendors list opens.


General tab

The General tab is where general vendor information and settings are managed.

Field

Description

1

Name

Common name for the vendor.

2

Number

The identification number used by your organization to reference the vendor or any other value used to sort or identify vendors.

3

Primary Contact

The primary contact for this vendor.

This field is required for vendors who will be paid using R365 Payments. 

4

Comment

An open text field to be used for any purpose. The values in this comment box appear on the Vendor list and can be used to sort the list.

5

Phone

Phone number for the primary contact.

Phone numbers may contain numbers, dashes, parentheses, or spaces.

6

E-mail

The primary email address to which purchase orders are emailed.

Only one email address can be entered here. Configure a list of email addresses on the Location tab to send purchase orders to all multiple recipients.

7

Fax

Fax number, if applicable.

8

Payment Terms

Payment terms to be applied to the vendor.

9

Terms Discount Account

For payment terms that result in a discount, specify the GL account to which the discounts post.

10

Inactive

If your organization no longer does business with a vendor but has recorded transactions, the vendor record cannot be deleted.

Flag the vendor as Inactive by selecting this checkbox. The vendor can no longer be selected in other areas of the software.

11

Payment Hold

If selected, the vendor is put on hold from being paid. Once this checkbox is selected, the following will occur:

  • Payment Run - Any invoices, even if they are due, are not available in to be paid until the hold is removed.
     

  • Manual Payment - The vendor does not appear in the vendor list when making a manual payment.

12

Address

Mailing address for the vendor. Address information appears on printed checks for mailing purposes.

If the vendor is paid using R365 Payments, this field is required, only US states are accepted in the State field.

Ensure that the zip code does not include a four-digit extension and that no special characters are used in the address fields (.,:;#@-*). When using R365 Payments, the payments will auto-fail if they contain either of these errors.

Vendor Additional Info tab

The Vendor Additional Info tab contains payment details for the vendor.

Field

Description

1

Check Name

The vendor name as it appears when printed on a check from within Restaurant365. This field is automatically populated based on the Name field in the General tab.

If a user wants to change the name of this vendor after it was previously created and saved, a warning message appears and asks if the Vendor Name should match the Payment Name, as shown in the image below.

  • Yes - Update the Payment Name - Both the Vendor Name and Payment Name are updated. The 1099 Vendor Name is unchanged, as noted at the bottom of the warning message. If the 1099 Vendor Name also needs to be changed, it must be updated manually.

  • Cancel - Only the Vendor Name is updated.

2

External Vendor Identifier

A reference number provided to your organization by the vendor that is used by the vendor to identify your organization.

3

Entry

The method by which invoices are entered into the software. The majority of vendors are invoiced by account while Food & Beverage vendors are often invoiced by item.

  • By Account - If invoices for this vendor are entered by GL account, select By Account. Upon selecting a vendor with Entry By Account, the invoice grid allows the user to select specific GL accounts on the invoice.

    For Restaurant Managers who need to enter invoices, the GL accounts must be made available to the managers. If the GL account is not available to the user, it does not appear as an option in the drop-down menu.

  • By Item - If invoices for this vendor are entered by item, select By Item. Upon selecting a vendor with Entry By Item, the invoice grid allows the user to select the vendor items specific to the vendor, as well as all purchased items (non-specific items in the system) on the invoice.

    If the vendor has been used on a purchase order or shopping list, the Entry method cannot be changed from By Item to By Account.

4

Default Check Memo

Enter a check memo in the text field to automatically populate the Check Memo field when performing a payment run.

5

Payment Method

Method by which the vendor will be paid when performing a payment run or when using Pay Bill features. Default: Check.

  • R365 Payments - The vendor is paid through R365 Payments. This is the default selection on new vendor records when R365 Payments is enabled.

    If selected, the Last Payment Method field appears and displays the payment type used in the previous transaction.

  • ACH - A file containing ACH stubs is produced at the conclusion of the payment. An ACH push requires that the vendor provides a bank account number, routing number, and account type so that ACH stubs can be authored to the vendor's bank account. Click here for more information on setting up ACH payments.

    Most users do not use ACH push and are most likely using ACH pull, where an authorization is granted to a vendor to automatically withdrawal funds via ACH. If this is the case for your vendor, select Auto-Direct Debit. 

  • Check - Prints a physical check with which to pay the vendor. This is the default selection unless R365 Payments is enabled.

  • Auto-Direct Debit - The vendor automatically withdrawals payments from a bank account. This option works in conjunction with the auto-pay feature.

  • Credit Card - The vendor is paid by credit card. This option works in conjunction with the auto-pay feature

6

Entry Instructions

Enter detailed entry instructions to display when a user enters an invoice, as shown in the image below:

7

Vendor Group

Vendor group to which the vendor is assigned.

8

Bank information

If the Payment Method is ACH, enter the bank account information for the vendor, including:

  • Type - The type of bank account used for ACH processing for this vendor.

  • Account Number - Account number to which payments are sent. 

  • Routing Number - Routing number to which payments are sent.

Organizations with the R365 Payments service enabled will also have the following field:

  • ACH remittance email - Email address to which confirmation of the ACH payment is sent. Users can add up to 4 email addresses in this field.

Only users with the following permission can edit this field:

  • Accounts Payable → Vendors → Edit Vendor Bank Account information

9

Payment Per Invoice

If selected, the vendor needs a separate AP payment record for each payment created. On a payment run, when multiple invoices are paid for the same vendor, a single AP payment is created that lists each invoice. If selected, a separate AP payment and check are created for each payment.

10

Vendor Priority

The priority status assigned to the vendor, which determines the priority field on the invoice. Vendor priorities assist in identifying and prioritizing the payments on a payment run that should be processed first to optimize cash flow.

11

Short Pay

This setting has specific uses for the restaurant industry and is used to control the way certain vendors handle credits and shortages on deliveries. A Short Pay vendor is one who only requires payment for goods and services actually delivered. This is likely most of your vendors.

  • Smaller food suppliers, such as local produce suppliers, only expect to be paid for goods delivered. For example, If an order was placed for 7 cases of tomatoes and the delivery arrived with only 6 cases of tomatoes, the person receiving would mark the difference on the invoice given to them by the delivery person. A Short Pay vendor would expect payment for the 6 cases of tomatoes that had been delivered. The fact that the original invoice showed 7 cases is irrelevant, as only 6 were delivered. Select the Short Pay checkbox for this vendor.

  • Larger food suppliers, such as Sysco, require that you pay for what was ordered, not what was actually received. This creates the additional step for you to request a credit from them for anything not received. Restaurant365 makes this process easy, but the first step is setting up the vendor with the proper Short Pay setting. For these vendors, clear the Short Pay checkbox.

12

Default Expense Account

If a Default Expense Account is selected, when entering in invoices for the vendor, the Expense Account field automatically populates with the selected default expense account. The value is not locked and can be changed as needed on the Invoice screen.

13

Use Tax

Select the checkbox to indicate that the vendor is a Use Tax vendor. Certain reports, such as Purchases by Vendor or Business Analytics (Ad Hoc Reports) can be configured to display totals for Use Tax vendors.

14

Items Available on Invoice

For vendors with vendor items configured in Restaurant365, determine which items are available to select when entering invoices.

  • All Items - All purchased items and vendor items populate the Item list on the AP/AR Invoice screen. This is the default setting for all vendors.
     vendor-additional-info-all-items

  • Vendor Items Only - Only vendor items for the vendor populate the Item list on the AP/AR Invoice screen. This limits selectable items to only the vendor Items for the selected vendor.
     vendor-additional-info-vendor-items-only

Organizations that utilize the brand repository can only select brand repo-sourced item records from brand-approved vendors. This means that brand repo-sourced items cannot be ordered from non-brand-approved vendors. For more information, please contact R365 Support.

15

Restricted Access - usage

If selected, Restaurant Managers cannot create transactions for this vendor but can view the transactions in the AP Transactions list.

16

PO File Format

File format used when exporting purchase orders. Options include:

  • .csv

  • .pdf

17

Fintech Integration Credit Processing

If a customer of Fintech, this selection enables the user to select how R365 will process refunds from Fintech. There are two options to choose from:

  • Credit - Create a Credit Memo - Create a credit memo to document the refund. This is the default option.

  • Refund - Create Bank Entry- Inserts a line item called Fintech Refund on the negative invoice and created undeposited funds or a bank account assigned to it to record the refund. Once mapped, the GL account can be updated.

    Note: The Fintech Refund line item must be mapped in R365. Click here to learn more about processing Fintech Refunds and mapping New Vendor Items in R365.

    The Fintech Refund line item must be mapped in R365. Click here to learn more about processing Fintech Refunds and mapping New Vendor Items in R365.

18

Invoice Date

Source of the invoice dates for this vendor. Users can select from either of the following:

  • AP Invoice - The date assigned to the AP invoice.

  • PO Delivery Date -When linked to a purchase order, the AP invoice date will change to the purchase order delivery date. 

Read more about the invoice date for linked purchased orders.

Additional fields when R365 Payments is enabled

Click here for more information.




Exclude from R365 Payments

If selected, the vendor is excluded from R365 Payments. Selecting this checkbox removes the requirement to complete certain fields for R365 Payments on the General tab.

Additional fields when EDI Vendor Integration is enabled

Click here for more information.






Food Service Distributor

The food service distributor that receives the purchase order.

Only the vendors listed in the Vendor Integration List are currently available for outbound EDI integration.

Distributor Division

The specific division of the company that will fulfill the order.

If the selected food service distributor does not have any divisions, this field does not appear.


Open Transactions Tab

Any open transactions associated with the vendor appear in this list view. Transactions that are past due or within ten days of being due are marked as Past Due or Due Soon, respectively, next to the due date.


All Transactions Tab

All transactions associated with the vendor appear in this list.


Contacts Tab

Any contacts associated with the vendor appear in this list.


Locations Tab

By default, vendors are accessible to all locations, but if needed, vendors can be limited to specific locations. If a vendor is limited to specific locations, then the vendor is only available for transactions if the transaction location matches one of the vendor's locations.

Vendor location numbers can be added for each location, as needed, for use in EDI Vendor Integrations

Vendor account numbers can be printed on Check Remittances. 

Limiting a vendor to specified locations

  1. On the Vendor form, select the Location tab.
    By default, the Available/Same All Locations checkbox is selected and the Location table is hidden, meaning that this vendor can be accessed by all locations.

  2. To assign specific locations, uncheck Available/Same All Locations.
    The Location selector and Locations table appear.

  3. In the Select Location lookup field, enter the name of a location or select a location from the drop-down menu.

  4. Select Add to add the location to the table.

  5. Add the location-specific Email (used for Purchase Orders) and Vendor Location Number (used for EDI Vendor Integrations).

    Multiple email addresses can be configured by separating each email address with a semicolon ( ; ).

  6. Repeat these steps until all desired locations are added.

    Ensure that all locations (even locations that will not be used in Purchase Orders or EDI Vendor Integrations) that will use this vendor for AP invoices / AP credit memos are added to this table, otherwise they will not be able to use or select this vendor during invoice entry.

  7. Save your changes.

Printing Vendor Account Number on Check Remittances

The vendor account number can be printed as part of check remittances:

  1. Select the Print Vendor Account Number on remittance checkbox.

    This option only appears if the Available/Same All Locations option is unchecked.

  2. Enter the Vendor Account Number for each applicable location.

  3. Save your changes.
    When checks are printed, the vendor account number for the location will be printed as the customer number.

     


1099 Tab

The 1099 tab is where all 1099 information is configured for the vendor. To learn how to update this information after it is initially saved, see Update 1099 Vendor Types.

Field

Description

1

Name

Common name for the vendor.

This field is automatically populated based on the Name field in the General tab and is read-only.

2

Check Name

The vendor name as it appears when printed on a check from within Restaurant365. This field is automatically populated based on the Name field in the General tab and is read-only.

3

Exclude when processing 1099s

If selected, the vendor is excluded during 1099 processing.

4

1009 Type Information

Select whether the vendor is a company or an individual. The following additional fields appear based on your selection:

  • Company- The following fields appear:

    • 1099 Company Name - The name that matches the Tax ID - EIN.

    • Tax ID - EIN - This Tax ID for the Vendor, which may be the EIN (Employer Identification Number). The formatting for this field is: ##-#######

  • Individual- The following fields appear:

    • 1099 Name - The name that matches the SSN/TIN.

    • Tax ID - SSN/TIN - The Tax ID for the individual, which is formatted as: ###-##-####

      For security purposes, only the last 4 digits are visible. Users with the following Permission can view unmasked SSNs:

      • Accounts Payable → Vendors → Vies Vendor Tax IDs for Individuals

5

Active

Select the checkbox to mark the corresponding form as Active, or in use, for the vendor.

Marking a form as Inactive will update all unapproved transactions that use this form and box to the next defaulted form/box. If no other forms are active, the 1099 information is removed from those transactions.

6

Default

The default form for the vendor, which will appear on the data entry screen (AP Transactions). Only one form can be marked as the default form, and if the default form is marked as Inactive, then the first active form will be set as the default.

The default form can be updated at any time.

7

Form

The available 1099 forms for the vendor, which include:

  • 1099-MISC - Miscellaneous Income

  • 1099-NEC - Nonemployee Compensation

  • 1099-INT - Interest Income

8

Box

A default box selection will need to be made for the form(s) selected. Options include:

  • 1099-MISC - Miscellaneous Income

    • 1 - Rents

    • 2 - Royalties

    • 3 - Other Income

    • 4 - Federal Tax Withheld

    • 5 - Fishing Boat Proceeds

    • 6 - Medical Payments

    • 7 - Direct Sales

    • 8 - Substitute Payments

    • 9 - Crop Insurance Proceeds

    • 10 - Proceeds to an Attorney

    • 12 - Section 409A Deferrals

    • 14 - Excess Golden Parachute

    • 15 - Nonqualified Deferral Compensation

    • 16 - State Tax Withheld

    • Pre-2022 Box 13 - Excess Golden Parachute

    • Pre-2022 Box 14 - Non qualified Deferral Comp

    • Pre-2022 Box 15 - State Tax Withheld

    • Pre-2020 Box 7: Nonemployee Compensation

    • Pre-2020 Box 9: Direct Sales

    • Pre-2020 Box 10: Crop Insurance Proceeds

    • Pre-2020 Box 14: Gross Proceeds to Attorney

  • 1099-NEC - Nonemployee Compensation

    • 1 - Nonemployee Compensation

    • 4 - Federal Tax Withheld

    • 5 - State Tax Withheld

  • 1099-INT - Interest Income

    • 1 - Interest Income

    • 2 - Early Withdrawal Penalty

    • 3 - Interest on US Bonds

    • 4 - Federal Tax Withheld

    • 5 - Investment Expenses

    • 6 - Foreign Tax Paid

    • 8 - Tax-Exempt Interest

    • 9 - Activity Bond Interest

    • 10 - Market Discount

    • 11 - Bond Premium

    • 12 - Bond Premium Treasury

    • 13 - Bond Premium Tax Exempt

9

Allow Box Override

If selected, the user can select a box other than the one selected on the vendor record when entering transactions.

10

Upload File

Upload a file to attach to the record.

For more information on 1099, view the 1099 Setup and Management training article.

Multiple columns can be added to the vendors list in regards to 1099 information. To add a column, simply click the Show/Hide Columns selector and select the checkbox next to the desired columns. Click here to learn more about working with lists.


GL Accounts Tab

This tab allows users to map GL accounts in R365 to the GL account numbers provided by the vendor. Only vendors who utilize DataPass need to have GL accounts mapped. Mapping these accounts will then automatically set up AP invoices brought in through FTP as Entry by Account in R365.

If no mappings are found for a GL account, an error occurs. Users must set up the necessary mappings so that data can be imported.

Users can map GL accounts in two ways:

  • Manually - Users with the necessary security access should navigate to this tab, select the desired GL account in R365, and then enter in the vendor's GL account number for that selected GL account. Select Add to include the account mapping for this vendor. After adding all necessary mappings, ensure to save the vendor record.

  • Import Tool - Users can enter in the desired GL accounts for a vendor using the Import Tool, which is efficient for adding a large number of GL accounts to a vendor record. To do this, navigate to the Import Tool, select Vendor GL Account Mapping for Options, and then select one of the following options in the Type field:

    • Create New - Use this when adding new GL accounts to a vendor record.

    • Update Existing - Use this when updating a vendor account number.


Attachments

Some vendors may have contracts or buying agreements. These and any other vendor-specific documents you wish to keep readily accessible can be added to the vendor record in Restaurant365. Do this by clicking on the Upload File button found on each tab. Click here for more information on Uploading Files.


Was this article helpful?