Johnstone Supply P2P integration FAQLast updated on 03/14/2023
What is the Johnstone Supply P2P integration?
The P2P integration streamlines the supply chain, allowing you to have Johnstone Supply materials and equipment information loaded directly into your ServiceTitan Pricebook, along with the contractor-specific cost for participating distributors.
Create and submit POs directly within ServiceTitan, saving time and reducing errors.
Increase reconciliation efficiency with POs, receipts, and invoices in a single system. Take advantage of the accounts payable module within ServiceTitan to manage their bills and statements, and even make payments directly to participating Johnstone Supply distributors.
I’m interested in turning on the Johnstone Supply P2P integration, what steps do I need to take?
See this ServiceTitan’s Knowledge Base article to determine whether your Johnstone Supply distributor group is currently available as a P2P integration. Once you have reviewed the list to confirm that your distributor group is enabled for P2P, you should contact your distributor group’s POC and request that they submit an activation request using the Johnstone Supply landing page.
What costs will I see with the P2P integration?
This ServiceTitan’s Knowledge Base article lists whether the distributor group provides bulk costs and/or real-time costs at the time of PO submission. These will both be your customer-specific costs due to Johnstone Supply.
Bulk costs: Bulk costs are costs that are displayed in the Pricebook for equipment and/or materials in the Johnstone Supply distributor group’s catalog. With bulk costs enabled for the distributor group, you can automatically map costs for items that are synced/mapped with the Johnstone Supply distributor group’s catalog and see the costs as you navigate through the Johnstone Supply distributor group’s catalog. Note: These costs are only visible the next business day once Johnstone Supply’s daily cost sync has been completed for all mapped items.
Real-time cost: If the distributor group does not provide bulk cost, the real-time cost is still available at the time of submitting an electronic PO. These costs can then be applied to your Pricebook, preserving your margins for items you purchased the most.
During the integration setup, how do I properly set up Johnstone Supply as my vendor?
For the first step of the integration setup, you should enable Johnstone Supply as a replenishment vendor in order to see the dropdown list of vendors.
Note: If you have Payables, you will see Johnstone Supply both as a purchasing vendor and a replenishment vendor. You should set up the purchasing vendor as a replenishment vendor in order for the P2P integration to work.
Where do I find my account number, and what if I purchase from multiple Johnstone Supply distributor groups?
Your account number can be found on your invoice from Johnstone Supply. If you work with multiple distributor groups, we recommend you include the account number for the distributor group from which you purchase the most.
To set up the integration for a second distributor group, you should go back to the integration setup and enter the other account number. This setup gives you access to both distributor group catalogs. You need to map all of the items.
Note: Bulk cost and real-time cost differ for each distributor group. If bulk cost is available, there will still be a one-business-day delay after mapping is completed.
How should I map my accounts, using business units or inventory locations, trucks, and warehouses?
To ensure smooth functionality and integration with accounting systems, and ensure accurate accounting, you should use either business units or trucks and warehouses for exporting purchase orders.
Business units: If you export to an accounting system and your main focus is general ledger accounts, you should utilize business units.
Trucks and warehouses: If you want to get more granular and have inventory enabled on your accounting integrations, you should utilize trucks and warehouses.
Another option is if you utilize the purchasing module you should set up business units and if you use the inventory module you should set up trucks and warehouses.
What do I do if I purchase the same items from multiple suppliers, including a Johnstone distributor group?
It’s important to note that you can only map your items in your Pricebook to one catalog at a time. You should decide which supplier you are looking to purchase from. We recommend the following mapping process:
Export your Pricebook in its current state.
Work with your branch rep to make sure you have exactly what is in their catalog so you have a high match when mapping your Pricebook to the Johnstone Supply catalog.
The branch rep should give you a list of frequently purchased items so that when you go to Map to Provider, the same number of items is displayed.
If there is a discrepancy in the number of items, you should update your Pricebook and export it again. Make sure you see the exact number of items to be mapped in your Priebook.
Once they all return a high match, map them accordingly.
How should I do the mapping process between my Pricebook and the supplier catalog?
Once you have determined whether you are going to map the equipment and/or materials in your Pricebook to the Johnstone Supply distributor’s catalog, you can proceed with these steps to complete mapping:
Export your Pricebook in its current state.
From the side menu, click Pricebook Connect > Catalog. The Catalogs screen opens.
On the Johnstone Supply distributor group’s catalog, click the icon, then click Map to Provider.
On the Map to Provider pop-up that opens, click Begin Matching.
On the Select Items to Map screen that opens, click Bulk Select. The screen opens with the Equipment and Materials tabs.
On both tabs, select High Match and deselect the Code and Name fields. Note: This ensures that the supplier's Code and Name fields don't override your current pricebook items.
On both tabs click Filter. The Filters screen opens.
From the Match dropdown, select High.
When you’re done, click Apply.
Note: We recommend you exclude the code and name fields from the high matches so that your technicians and employees can continue searching for the item using the item name or code in ServiceTitan Mobile.
When you’re finished, click Map.
What should I keep in mind when sending my purchase orders electronically?
The following are several best practices regarding sending purchase orders electronically:
Make sure business units and trucks and warehouses are set up based on vendor integration settings or the purchase order will be rejected.
You can only search Active items in your Pricebook. If there is a new and not downloaded item, you can add it. Note: Make sure that the vendor part number is accurate.
If a vendor part number does not populate, you can add the part number, quantity, and unit cost manually. This works for checking costs.
To send the purchase order, click Create > Create and send as electronic delivery. Depending on the distributor group, they may allow you to opt-in for discounts based on electronic delivery.
You have the option to change your branch based on the location you’re close to.
If the purchase order is sent electronically and rejected, it will appear in the Pending section for you to hover over the icon for more information. This will display the latest error message to make corrections.
What if the location I want to purchase from doesn’t have the quantity on hand at my default branch?
This is not a problem. All of the distributor groups will accept the purchase order as a backorder. And, regardless of the quantity on hand being available at the default or selected branch, the purchase order will be accepted. Then, the distributor group will figure out on their end how to handle the purchase order accordingly.
Does Johnstone Supply, and specifically my distributor group, accept Payables?
All Johnstone distributor groups accept Payables. Payables offer a more streamlined process for submitting payment for your purchase orders.
How much does the P2P integration cost?
This is free to all ServiceTitan customers. There is no additional cost for contractors to use the integration, outside of their core subscription fees.
Who should I reach out to with questions pertaining to P2P?
Please contact our Support Team through Live Chat from your account, through firstname.lastname@example.org, or by calling 818.877.4675. Contacting Support will provide the quickest response for any urgent issues your customer is experiencing.
Important note: Some features may not be currently included in your account and additional configuration may be required. Please contact technical support for details.