Which price list applies to which customer and is valid for how long? If you have hundreds of customers in your B2B business, you need to know at all times which price lists are currently valid. Until now, employees of a global consumer goods manufacturer had to gather this information manually from a multitude of distributed Excel files. Reconciliations between Excel files were tedious, sometimes not possible and very error-prone. Data reconciliation with SAP was also time-consuming. Master data errors were difficult to find.
The aim of the revision was to simplify this manual price list work by defining the data source for the price list information. In addition, the time-consuming work should be greatly simplified and thus the usability and user experience increased.
Today, Excel files are created from one source and uploaded on demand to the connected systems. Depending on the customer, the solution automatically opens up individual downloads and formats of the price lists and contents. Changes to price lists are marked in colour, which makes it easier to advise customers and increases usability. The price list data is automatically matched with the SAP master data.