Symptom
- The Revenue Recognition run finishes with the error message 'Doc. item ABC/XX: Only doc. items of the same profit center can be merged'.
This error message hints towards a project based fixed price Sales Order Item, ABC-XX, with the Accrual Method 108 - Recognize using cost-to-cost project POC.
In this case all fixed-price sales order items associated with the same project are bundled into a single item for the purposes of Revenue Recognition.
To be bundled into a single item, the Sales Order Items must point to the same Company, Segment, Profit Center, and Customer. - You have verified that all project based fixed price Sales Order Items of the project are assigned to the same Profit Center. However, the error is still reported in the Revenue Recognition Run.
(ABC-XX represents the sales order item ID)
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Cost and Revenue work center.
- Go to the Periodic Tasks view and select Revenue Recognition.
- Find the run with processing status Error.
- Open the Log via the Log Result link.
- Open the Messages tab.
Error message: 'Doc. item ABC-XX: Only doc. items of the same profit center can be merged is displayed'.
To verify that all fix-price sales order items of the project are assigned to the same profit center:
- In the Sales Document Items view of the Cost and Revenue work center find sales order item ABC-XX.
- Navigate to the Associated Objects tab.
- Take note of Project ID XYZ (XYZ represents the project ID).
- Open the Advanced search.
- Under Related Documents, in the Project ID field enter the project ID XYZ.
- Under Accounting Data, in the Revenue Type field select 3 - Project Sales (Fixed Price).
- Press Go.
- Check if all fix-price items associated with the project are assigned to the same project.
Cause
To bundle all fixed-price sales order items that use accrual method 108 – Recognize using cost-to-cost project POC, the system automatically creates an internal, project-only item in the backend.
This internal project-only item inherits the company code, segment, and profit center of the leading sales document item.
However, if the profit center of the leading sales document item (or any related items) is changed, this updated assignment is not automatically transferred to the internal project-only item. As a result, a mismatch occurs, which leads to the error message during the revenue recognition run.
Resolution
Our development team is working on improving the profit center assignment logic for internal project items. This functionality will be enhanced in a future SAP Business ByDesign release.
In the meantime, if you encounter this scenario and have verified that all fixed-price sales order items of the project are assigned to the same profit center and segment, please submit an incident to Support. We will then update the profit center of the internal project-based item in the backend.
Keywords
Revenue Recognition, Run, Error, Profit Center, Same, Posting, POC, Project, Items, Sales Document, Company , KBA , SRD-FIN-COR , Cost & Revenue , Problem
SAP Knowledge Base Article - Public