Collection of purchase data from stand-alone companies

Background:
•Ahlsell’s BI reporting of purchasing data has historically been entirely based on data from the ERP system Vivaldi.

•This means that the purchasing data used in negotiations and for following up supplier bonus has been limited to the companies that are using Vivaldi.

•Data from stand-alone companies (i.e. companies not using Vivaldi) has had to be collected and added manually. In many cases we are relying on supplier data

•For the Tools assortment, including suppliers that are used by many of the stand-alone campanies, a manual quarterly reporting of purchase data from stand-alone companies was established in 2019. Currently 5 companies are reporting this way (Neoselect, PJ Control, Verktygshuset i Kiruna, Verktygsboden, T Bentsen)

•Given Ahlsell DK/Sanistål’s large purchase volume, their purchase data from SAP has been integrated to Ahlsell’s PowerBi reports using file transfer. This required mapping of data fields, product hierarchies and Group suppliers.

•It has recently been discovered that we have not received supplier bonus for purchases from all stand-alone companies

Purpose and rationale:

Purpose

Rationale:

•The purpose of this document is to discuss a possible digital solution for integrating purchase data from stand-alone companies to Ahlsell’s BI platforms

Complete, accurate and aligned reports on purchase data including stand-alone companies will contribute to:

–Additional bonus of estimated 5-10 MSEK thanks to more efficient and correct supplier bonus follow-up

–Improved negotiation results based on all spend

–Category planning covering all spend

Stand-alone companies:
•Acquired companies in all countries, not using Vivaldi

•For Ahlsell DK/Sanistål, a separate integration has been established

•Baltic companies

•Polish companies