How To Fix CK791 - Arithmetic problems when calculating future planned price

SAP Error Message - Details

• Message type: E = Error

• Message class: CK - Product Costing Messages

• Message number: 791

• Message text: Arithmetic problems when calculating future planned price

What causes this issue?

Arithmetic problems occurred when calculating the future price
concerning currency type &v3&. This was probably due to a field
overflow.
&what_to_do&
Either reduce price unit &v2&, or increase the costing lot size of the
cost estimate that you want to mark by creating a new cost estimate.
Carry out marking again.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message CK791 - Arithmetic problems when calculating future planned price ?

  The SAP error message CK791, which indicates "Arithmetic problems when calculating future planned price," typically arises during the calculation of future planned prices in the Controlling (CO) module, particularly in the context of product costing. This error can occur due to various reasons, including data inconsistencies, incorrect configuration, or issues with the underlying calculations.
  Causes of CK791 Error
  
  
  Data Inconsistencies: There may be inconsistencies in the master data, such as material master records, cost estimates, or other related data that are required for the calculation of planned prices.
  
  
  Division by Zero: The error can occur if there is a division by zero in the calculations, which can happen if certain cost components are not properly defined or if there are missing values.
  
  
  Incorrect Configuration: Configuration settings in the costing variant or costing sheet may not be set up correctly, leading to issues during price calculation.
  
  
  Missing Costing Data: If the necessary costing data (like overhead rates, activity prices, etc.) is missing or not maintained, it can lead to arithmetic errors.
  
  
  Currency Conversion Issues: Problems with currency conversion rates or missing exchange rates can also lead to arithmetic problems.
  
  
  Solutions to CK791 Error
  
  
  Check Master Data: Review the material master data, cost estimates, and any related data to ensure that all necessary information is complete and accurate.
  
  
  Review Costing Configuration: Verify the configuration of the costing variant and costing sheet. Ensure that all necessary parameters are correctly set up.
  
  
  Examine Cost Components: Check the cost components used in the calculation. Ensure that they are defined correctly and that there are no missing values that could lead to division by zero.
  
  
  Validate Overhead Rates: Ensure that overhead rates and activity prices are maintained correctly in the system.
  
  
  Check Currency Settings: Review the currency settings and ensure that all necessary exchange rates are maintained in the system.
  
  
  Run Costing in Simulation Mode: If possible, run the costing in simulation mode to identify where the error occurs. This can help pinpoint the specific data or configuration causing the issue.
  
  
  Consult SAP Notes: Check the SAP Support Portal for any relevant SAP Notes that may address this specific error. There may be patches or updates that resolve known issues.
  
  
  Debugging: If you have access to technical resources, consider debugging the program to identify the exact point of failure in the calculations.
  
  
  Related Information
  
  
  Transaction Codes: Familiarize yourself with relevant transaction codes such as CK11N (Create Cost Estimate), CK40N (Change Cost Estimate), and CK24 (Display Cost Estimate) to analyze cost estimates and related data.
  
  
  SAP Documentation: Refer to SAP documentation and help guides for detailed information on product costing and configuration settings.
  
  
  User Forums and Communities: Engage with SAP user communities and forums where similar issues may have been discussed, providing insights and potential solutions.
  
  
  By following these steps, you should be able to identify and resolve the CK791 error in SAP. If the problem persists, consider reaching out to your SAP support team for further assistance.