SAP Knowledge Base Article - Public

3410837 - Revenue Recognition Error: 'Document item XYZ/XX: Derivation of planned costs not possible'.

Symptom

You execute the revenue recognition run for sales order item XYZ-XX which uses accrual method 108 - Recognize using cost-to-cost project POC.

The run finishes with the error "Document item XYZ/XX: Derivation of planned costs not possible".

(XYZ/XX represents the sales order ID/sales order Item ID.)

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Cost and Revenue work center.
  2. Go to the Periodic Tasks view.
  3. Select the Revenue Recognition subview.
  4. Click the Revenue Recognition ID you need.
  5. Go to the Messages tab.
  6. You can see the error Document item XYZ/XX: Derivation of planned costs not possible.
  7. Go to the Processed with Errors tab, search and open sales order item XYZ/XX.
  8. Click View All.
  9. Go to the Items tab.
  10. The item is linked to a Project.

Cause

When using the accrual method "108 - Recognize using cost-to-cost project POC" the estimated costs are either derived directly from the project (work, materials, expenses tab) or from a manual Estimated Cost value.

The error is reported when no such planned costs exist and when no manual POC is maintained either. 

Resolution

To resolve this issue, you have three options: 

1. Maintain the cost directly in the Project:

  1. Go to Cost and Revenue work center. 
  2. Go to Sales Document Items view.
  3. Search for the related Sales Document Item.
  4. Go to  the Associated Objects tab.
  5. Open the Project related to the Sales Document item. 
  6. In the project Go to the Project Plan tab select a project task.
  7. Go to the "Work", "Materials" or "Expenses" sub tabs, where you can maintain planned values according to your business needs. 

2. Maintain a manual Estimated Cost value:

  1. Again in the Sales Document Items view of the Cost and revenue work center find the related sales order item. 
  2. Press Edit Manual Revenue Recognition Data and choose Percentage of Completion.
  3. Here, under Calculation Basis for calculated POC, you can enter the Estimated Costs manually. 
     

3. Enter a manual Percentage of Completion: 

  1. Again in the Sales Document Items view of the Cost and Revenue work center find the related sales order item. 
  2. Press Edit Manual Revenue Recognition Data and choose Percentage of Completion.
  3. Here, under Details for Project, you can enter a new row with the required Percentage. 

Keywords

revenue recognition, planned costs, pricing and invoicing, POC, percentage of completion, 108 - Recognize using cost-to-cost project POC
, KBA , SRD-FIN-GL , General Ledger , How To

Product

SAP Business ByDesign all versions