How To Fix O4167 - Condition type & is formula-based. Mass price changes cannot be made

O4167 - Overview

• Message type: E = Error

• Message class: O4 - IS-Oil: MAP message pool

• Message number: 167

• Message text: Condition type & is formula-based. Mass price changes cannot be made

What causes this issue?

Within purchasing, condition record prices for Info. records, Contracts
and Scheduling agreements can be maintained using the Mass Price Change
process. Using this method, it is possible to increase the rates of all
the records selected, by either a fixed amount or a percentage. This
type of increment is meaningless in the context of a formula and
average condition record, where there is no actual rate data stored.
Prices should therefore not be maintained in this way.

System Response

An error is raised if a formula based condition type is specified in
the selection criteria.

How to fix this error?

Formulae can be maintained directly within Condition Records, Info.
records, Quantity Contracts and Scheduling agreements by using the
Formula Maintenance function. If you want to increase prices accross a
range of vendors or materials and still use formula based prices, then
you should consider using a seperate discount/surcharge condition type
for that purpose.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message O4167 - Condition type & is formula-based. Mass price changes cannot be made ?

  The SAP error message O4167 indicates that you are trying to perform a mass price change for a condition type that is formula-based. Formula-based condition types are calculated based on specific formulas rather than being set to a fixed value, which means that they cannot be directly changed in bulk through mass change transactions.
  
  Cause:
  The primary cause of this error is that the condition type you are attempting to modify is defined as formula-based in the pricing procedure. This means that the value of the condition type is derived from a calculation rather than being a static value that can be updated directly.
  
  Solution:
  To resolve this issue, you have a few options:
  
  
  Manual Adjustment: If you need to change the values for a formula-based condition type, you will have to do it manually for each relevant record. This may involve navigating to the specific pricing document and adjusting the values as needed.
  
  
  Review the