Use UNSPSC to map purchases to your ERP.
Background
One very useful feature in SAP Business ByDesign and some other ERPs is the ability to integrate PunchOut with the procurement cycle. In essence this allows employees in your organization to shop on a supplier's website and when done, transfer all of the items selected on that supplier's site directly into a requisition in the ERP. There are several benefits to this including:
- Reduced item setup in the ERP.
- A more interactive shopping experience.
- Eliminate manual replication of data already entered into the supplers website.
The basic workflow is:
- click a link in the ERP to be directed to the suppliers site (the user will be logged in automatically so that company negotiated prices are displayed)
- shop and add items to the cart.
- check out and have all of the items from the cart automatically transferred to the purchase requisition in the ERP.
The Problem
This sounds great! And it is. However there is a problem.
How do you ensure that all of those items purchased are categorized properly in the requisition and the follow up purchase order?
Using SAP Business ByDesign in our example, if we do not set up every item that can be purchased from a vendor, then we need to at least set up the categories of items to be purchased and associcate them with appropriate cost objects.
However Business ByDesign limits the setup to a single default product category for all purchases from a site.
The Solution
Enter UNSPSC or United Nations Standard Products and Services Code®.
Most suppliers (e.g. Office Depot) adhere to this standard to categorize the products they sell. The benefit of the UNSPSC is that it is a standard ensuring that products purchased from multiple suppliers are consistently categorized. Therefore it would be most beneficial to map the UNSPSC from the punchout catalogs to the ERP product categories. This would ensure uniform categorization of products purchased from multiple vendors without the need for manual coding.
Case Study - Integration of Office Depot punch out and SAP Business ByDesign
Our firm was tasked with setting up an integrated punchout catalog for Office Depot in Business ByDesign for one of our clients. In discovery we noted that there was an extremely high purchase volume from Office Depot spanning many product categories. As stated above, we are limited to setting a single product category for each external Catalog in configuration.
This would not suffice as the organization needed more granular categorization of its spending. Therefore we decided to:
- Set up an internal product category hierarchy based upon the UNSPSC codes that we knew could be provided to us in the punchout feed. Following is an example of what we imported into the ERP.
- Have Office Depot provide a shortened UNSPSC code in the punch out feed to reduce the number of categories that would need to be set up in Business ByDesign. This was based on the following analysis:
The Office Depot implementation of the UNSPSC was a total of 1600 product categories. For example, 67 product category codes related to paper products alone ranging from 14111502 through 14121901. However these 67 codes could be contracted to either one code 14000000 - Paper Materials and Products or 2 codes: 14110000- Paper Products and 14120000 - Industrual Use Papers. In essence, using the 2 digit Segment Code would result in a total of 39 Categories and using the 4 digit Family Code would result in 163 Categories.
We decided to base our product categories in Business ByDesign to the UNSPSC family code for the proper balance of purchase spend categorization.
It is important to remember that this is a one time set up that can be used to uniformly categorize purchases made from multiple punch out suppliers in an automated fashion. The result is consistent categorization of spend and removal of the burden of account coding from shopping cart users who would not be familiar with the proper coding. Also having more detail categorization of spend in the procurement part of the sytem will provide for very valuable analysis.
Implementation
- import the appropriate UNSPSC codes to the Business ByDesign product categories and map them to the appropriate account determination group.
- Have the punchout vendor map the UNSPC codes associated with each product to the family level when providing the punchout feed. Office Depot did this by replacing the last 4 digits of the 8 digit UNSPSC with zeroes.
