- 02 Dec 2024
- 1 Minute to read
- Print
- DarkLight
- PDF
Manage QuickBooks Vendor Mapping
- Updated on 02 Dec 2024
- 1 Minute to read
- Print
- DarkLight
- PDF
This article is part of the QuickBooks Online (QBO) integration and covers managing vendor mapping from R365 to QBO.
From the Vendors tab, users can map R365 Vendors to external (QBO) vendors, a necessary step for transmitting invoices to QBO. The same process applies when mapping vendors for the first time or updating existing vendor mappings. Vendor management can be performed individually or in bulk from the vendors tab of the QuickBooks mapping screen.
Map R365 Vendors to QBO Vendors Individually
To map or edit vendor mapping, follow these steps:
Click steps to expand for additional information and images.
1) Navigate to Smart Ops or Workforce in R365.
2) Click your username in the upper right corner of the screen then select integrations.
3) Locate QuickBooks.
If needed, the search bar can be used to find the desired integration.
4) Click edit in the QuickBooks box.
5) Click edit mapping.
6) Click the vendors tab.
7) Click the Select QBO Company dropdown, then select the desired QBO company.
Only linked QBO companies will be displayed as options.
8) Click the select external vendor dropdown.
9) Select the external vendor to map the R365 vendor to.
Users can scroll to locate the desired vendor, or type in the search box.
10) Click save in the top ribbon.
Map R365 Vendors to QBO Vendors in Bulk
To map or edit vendor mapping in bulk, follow these steps:
Click steps to expand for additional information and images.
1) Navigate to Smart Ops or Workforce in R365.
2) Click your username in the upper right corner of the screen then select integrations.
3) Locate QuickBooks.
If needed, the search bar can be used to find the desired integration.
4) Click edit in the QuickBooks box.
5) Click edit mapping.
6) Click the vendors tab.
7) Click the Select QBO Company dropdown, then select the desired QBO company.
Only linked QBO companies will be displayed as options.
8) Click the checkbox to select the desired vendors. (Select all R365 vendors that will be mapped to the same external vendor.)
9) Click edit external vendors in the bottom right corner.
10) Use the dropdown to select the desired external vendor.
Users can scroll through or begin typing in the search box to locate the vendor.