ERPs make procurement data extraction harder, not easier

TransformationPyramid.pngThe great irony of today’s ERP systems is that, once they are implemented, it becomes harder to extract information so that it can be used within the business to drive decision-making and take action, Alan Low of Purchasing Index (PI) says in this month’s SmartProcurement.

Spend analysis can have a huge influence on the behaviour and processes around how organizations spend money. Identifying who spends how much with which suppliers on what and how can show savings opportunities throughout the organization.

Here are some of PI's findings from the deployment of its Decision Support Service to analyse spend.

The majority of savings opportunities highlighted by spend analysis relate to poor processes and inappropriate behaviour. Procurement may do a good job negotiating with suppliers, but if processes are not streamlined then the internal costs and the suppliers’ service and delivery costs can add to the total cost to company.

A simple example of this would be a decision to go with a to-desk delivery service from a stationery supplier coupled with no minimum order value. The service may be very good, but the process may encourage lots of low value orders resulting in a very high internal administration cost relative to each order value. If the internal cost per order is high for the customer, the same is also certainly true for the supplier. A good spend analysis tool should be able to identify these process anomalies and highlight the costs involved.

Behaviour in spending the organization’s money can vary from the sloppy to the fraudulent. Frequent ordering increases suppliers’ costs; and delays in signing GRNs or approving invoices can stretch suppliers’ cash-flows and ultimately jeopardise their businesses (particularly SMEs!). Identifying these anomalies allows organizations to remedy specific errant behaviour.

PI’s experience is that most people change their behaviour if they know it is being monitored.

Many instances of potential fraud can also be uncovered through building simple checks and algorithms into the spend analysis software (i.e. comparing staff and supplier bank account numbers, etc.). Spend analysis must also be able to identify trends and patterns to mitigate against corruption.

Analysing spend must also allow for a holistic view. For instance: it is important to identify black-owned suppliers if a business is trying to maximise its BBBEE procurement score. But, if the analysis system can’t incorporate external credit rating information, the company may run the risk of doing more business with suppliers who are not sustainable. On the other hand, identifying these risks may not only allow the business to develop a long-term supplier, but also earn it a higher Enterprise Development score.

As organizations learn to use information to make changes to their environment and decision making, the requirements for incorporating extra internal and external information grow. The process tends to be iterative. However, spend analysis users are constantly amazed at what they can do with little or poor information, even if it is just to identify what needs to be fixed.

Please contact if you would like some practical assistance on spend analysis or would like to discuss PI’s Decision Support Service.

Leave a comment

SmartProcurement Newsletter

Please enter your details below to receive the SmartProcurement Newsletter for FREE on a regular basis.

As part of the SmartProcurement Newsletter you will be receiving World Class Procurement News, Tools, Tips, Tactics, Procurement Training updates, Upcoming Events, and the latest Procurement Career Openings.

* Email Address:
* Title:
* First Name:
* Surname:
* Company:
* Country:
* Public / Private:


Career opportunites

Operations Manager

  • >500 000 Gauteng Operations, Planning & Inventory Permanent Supply Chain
Our client within the FMCG industry with a ...More

Warehouse and Distribution Manager

  • >500 000 Gauteng Logistics & Warehousing Operations, Planning & Inventory Permanent
An exciting opportunity awaits for a Warehouse and ...More

Demand Planner

  • <500 000 Permanent
Get an opportunity to be part of one ...More

Procurement Manager

  • >500 000 Gauteng Permanent Procurement Management Procurement Officer / Specialist
An opportunity for a seasoned Procurement Manager, who ...More

Industrial Engineer

  • >500 000 Gauteng Industrial Engineer Permanent Procurement Consultant
An exciting opportunity that offers extensive exposure on ...More

Deputy Director: Procurement

  • >500 000 Contract Procurement Management Procurement Officer / Specialist Western Cape
Department of Economic Development and Tourism:Procurement Specialist, Ref ...More


  • >500 000 Gauteng Operations, Planning & Inventory Projects / Category Management
(Total Cost to Company R750k – R900K) excluding ...More


  • >500 000 Gauteng Operations, Planning & Inventory Permanent Projects / Category Management
(Salary: R 1.3M –R1.5M, dependent on level of ...More


  • >500 000 Contract Gauteng Procurement Consultant Projects / Category Management
Total Cost to Company R1mil – R1.2mil excluding ...More

Project Manager

  • >500 000 Contract Procurement Management Projects / Category Management Western Cape
 Description:A well-known retail organization is looking for an ...More


  • >500 000 Analyst Gauteng Permanent Procurement Management
Description:A leading infrastructure development group with strong presence ...More

Commodity Manager: Fuels and Lubes

  • Commodities Gauteng Permanent Projects / Category Management
 Ensuring continuity of supply in line with business ...More

Senior Facilities Manager

  • >500 000 Commodities Gauteng Operations, Planning & Inventory Permanent
(Total Cost to Company R800K – R900K) Johannesburg Our ...More


  • <500 000 >500 000 Gauteng Industrial Engineer Permanent Procurement Management
(Total Cost to Company R350K – R550K) JOHANNESBURGYou ...More

Supply Chain Analyst

  • <500 000 >500 000 Permanent Procurement Officer / Specialist Supply Chain Western Cape
(Total Cost to Company R350K – R550K)  SOUTHERN ...More

Security Manager

  • <500 000 >500 000 Gauteng Permanent Projects / Category Management Strategic Sourcing
(Total Cost to Company R350K – R550K) JOHANNESBURG This ...More

Demand Planner

  • <500 000 >500 000 Operations, Planning & Inventory Permanent Projects / Category Management
(Total Cost to Company R450k – R550k, dependent ...More

Procurement Specialist-Randburg

  • >500 000 Gauteng Permanent Procurement Management Procurement Officer / Specialist
(Total Cost to Company R700k – R800k including ...More

Solutions Architect

  • >500 000 Gauteng Industrial Engineer Permanent Projects / Category Management
(Total Cost to Company R1.3Mil – R1.1Mil including ...More


  • >500 000 Gauteng Permanent Projects / Category Management
(Total Cost to Company R850k – R950K including ...More