The Supplier Unit Mapping provides mapping definitions for EDI or Punch out Interfaces.
EDI Supplier Unit Mapping
Accessing EDI Supplier Unit Mapping
- Go to “Administration” → “Utilities” → “Integration Configuration → “Supplier Integration”.
- On the Supplier Integration Workbench page, select the EDI Supplier in the Suppliers section.
- In the Unit Mapping tab, you can view the RedRock and Supplier Unit Codes.
Adding Unit Mapping to a EDI Supplier
- Go to “Administration” → “Utilities” → “Integration Configuration → “Supplier Integration”.
- On the Supplier Integration Workbench page, select the EDI Supplier in the Suppliers section.
- In the Unit Mapping tab, you can view the RedRock and Supplier Unit Codes.
- Select New to add a new unit mapping.
- Enter the RedRock unit code or select it from the dropdown menu, then add the corresponding supplier unit code.
- Select Update to add the new unit mapping.
- Refresh to see the new unit code.
- The Unit Mapping for the Supplier can be found in the Supplier Unit Mapping Report. (See below how to navigate to the report).
Deleting Unit Mapping from EDI Supplier
- Go to “Administration” → “Utilities” → “Integration Configuration → “Supplier Integration”.
- On the Supplier Integration Workbench page, select the EDI Supplier in the Suppliers section.
- In the Unit Mapping tab, you can view the RedRock and Supplier Unit Codes.
- Select the unit mapping that you want to delete (highlighted in blue), then click “Delete”.
- Refresh to update unit mapping tab.
EDI Example: Supplier Unit Mapping
- In the example above it is going to show that through the EDI (123456789-RRS) with Sysco Food Services whenever a User orders a RedRock Item with the Order Unit of:
- CASE it will populate as CS within Sysco
- TUB it will populate as CS within Sysco
- EACH it will populate as EA within Sysco
- BAG it will populate as CS within Sysco
- JAR it will populate as EA within Sysco
EDI Unit Codes
- With EDI, each vendor can hold different unit codes and the RedRock mapping process allows the
customer to maintain their unit structure while converting to the vendors units in the interface exchanges. - With the pricing file, the mapping will allow the vendor to send their unit (such as CS) but if RedRock items use CASE as the unit code, it will convert those items sent as CS to CASE.
- With the purchase orders, without a mapping in place, we convert and assume based on the below logic (which can vary based on EDI vendor):
- RedRock unit is 'CASE', then send the unit 'CA' in the order export
- RedRock unit is 'CS', then send the unit 'CA' in the order export
- RedRock unit is 'ROLL', then send the unit 'RL' in the order export
- For every other unit in RedRock not the above, send the unit ‘EA' in the order export.
- The unit mapping allows the customer to maintain their own units while customizing the mapping per vendor for a much easier integration process.
PunchOut Supplier Unit Mapping
Accessing PunchOut Unit Mapping
- Go to “Administration” → “Utilities” → “Integration Configuration → “PunchOut Integration”.
- On the Supplier PunchOut Configuration page, use the supplier search function to select the PunchOut Supplier.
- In the Unit Mapping tab, you can view the RedRock and Supplier Unit Codes.
Adding Unit Mapping to a PunchOut Supplier
- Go to “Administration” → “Utilities” → “Integration Configuration → “PunchOut Integration”.
- On the Supplier PunchOut Configuration page, use the supplier search function to select the PunchOut Supplier.
- In the Unit Mapping tab, you can view the RedRock and Supplier Unit Codes.
- Select New to add a new unit mapping.
- Enter the RedRock unit code or select it from the dropdown menu, then add the corresponding supplier unit code.
- Select Update to add the new unit mapping.
- The newly added unit mapping will be shown automatically.
- The Unit Mapping for the Supplier can be found in the Supplier Unit Mapping Report. (See below how to navigate to the report).
Deleting Unit Mapping from PunchOut Supplier
- Go to “Administration” → “Utilities” → “Integration Configuration → “PunchOut Integration”.
- On the Supplier PunchOut Configuration page, use the supplier search function to select the PunchOut Supplier.
- In the Unit Mapping tab, you can view the RedRock and Supplier Unit Codes.
- Select the unit mapping that you want to delete (highlighted in blue), then click “Remove”.
- A Delete Confirmation pop up will appear, select “Yes”.
PunchOut Example: Supplier Unit Mapping
- In the example above it is going to show that through the Sysco PunchOut whenever a User orders an Item through PunchOut that Supplier Unit Code is populated as the listed RedRock Unit Code for that RedRock Item.
- CS within Sysco will convert as CASE within RedRock
- EA within Sysco will convert as EACH within RedRock
- CS within Sysco will convert as BAG within RedRock
- CS within Sysco will convert as BOX within RedRock
- CS within Sysco will convert as PAIL within RedRock
- EA within Sysco will convert as JAR within RedRock
Creating a PunchOut Example
- Using the 2 items as example to create a Sysco punch out which will populate as “CS” on the Sysco Punch out.
- They will be brought over to RedRock initially as CS.
- Then when they are pushed onto the Procurement Request within RedRock they populate as “CASE” just as our Supplier Unit Mapping is set as.
Supplier Unit Mapping Report
Navigating to the Report
- To access go to Reports – Administration – Interface References – Supplier Unit Mapping.
- Click on Show Parameters: Parameters: Supplier Code, RedRock Unit Code, Supplier Unit Code. (Note: none of the parameters are required, the user can choose to not to place information in any of the fields.).
- Click on Run Report.
- The report will populate and allow the User to understand:
- How RedRock communicates the Unit Code of a RedRock Item through the EDI interface.
- How the PunchOut website sends the Supplier Unit Code back to RedRock to match with the RedRock Item Unit Code.
