SAP Knowledge Base Article - Public

3577468 - Revenue Recognition Error - Use one merge item with code 'replace basic data' only

Symptom

  • The revenue recognition run then reports the error "Use one merge item with code 'replace basic data' only" appearing for the leading fix-price sales order item XYZ-XX of project ABC, using accrual method 108- Recognized Cost-to-Cost Project POC (XYZ-XX represents the ID of the leading sales order item; ABC represents the project ID). 

Environment

SAP Business ByDesign

Reproducing the Issue

  1. In the Cost and Revenue workcenter go to the Revenue Recognition view.
  2. Find the revenue recogntion run and view the Log Result. 
  3. The error "Use one merge item with code 'replace basic data' only"  appears in the Messages tab for item XYZ-XX. 

Now, find the sales order item and connected project: 

  1. Go to the Sales Document Items view of the Cost and Revenue workcenter. 
  2. Search for item XYZ-XX.
  3. Go to the Associated Objects tab.
  4. Here, the project ID ABC appears. Copy the ID.
  5. In the Sales Document Items view open the Advanced Search.
  6. In the Project ID field, enter ABC and press Go.
  7. Other sales order items such as DEF-DD and GHI-GG appear (DEF-DD and GHI-GG are sales order items associated with project ABC). 
  8. Select one of these items and go to the Accounting Data tab. 
  9. You notice sales order item XYZ-XX appears as Leading Sales Document Item. 

Cause

Background: 

  • To bundle all the project's fix-price sales order items, the system automatically creates an internal, ONLY-project-based item. There can only be one internal item for a project. 
  • However, for project ABC, an internal item is created per sales order (for item XYZ-XX as well as DEF-DD and GHI-GG. 

To verify that there are more than one internal items: 

  1. In the Sales Document Items view of the Cost and Revenue work center find and select sales order item XYX-XX. 
  2. Press Edit Manual Revenue Recognition Data and choose Percentage of completion.
  3. In the screen you notice several lines without sales order item, one per sales order and set of books. Howdver, you should see only one row per set of books. But in the case of project ABC you can see three rows, which indicates that there are more than one internal items created. 

The reason why multiple internal items are generated for project ABC and not only one, is that

  1. the automatic Accrual Method Determination fine-tune task is activated, assigning accrual method 108- Recognize Cost-to-Cost Project POC to all fix-price sales order items upon Release,
  2. the sales orders of project ABC, here sales orders XYZ, DEF and GHI have been released/approved at exactly the same time. 

In this case, when accrual method 108 is assigned automatically AND when multiple sales orders of the same project are released at the same time, the functionality is not able to generate only one internal item for the project. 

Resolution

Send a case to the SAP Technical Support team and request (give permission) to perform a backend correction and remove all internal items connected to project ABC that are not associated with the leading sales document item XYZ-XX. 

See Also

 2479036 - Revenue Recognition Run Error - Doc. item: Only Doc. Items of the Same Profit Center can be Merged

 2385608 - Revenue Recognition Error for Fix-Price Sales Order Items With/ Without Using Accrual Method 108 - Recognize using cost-to-cost project POC

Keywords

Revenue Recognition, Error, Use one merge item. replace basic data only, 108, Recognize Cost-to-Cost Project POC , KBA , SRD-FIN-COR , Cost & Revenue , Problem

Product

SAP Business ByDesign all versions