Revenue Recognition Error: Doc. item XXXX/XX: Only doc. items of the same profit center can be merged

[Former Member]

Hi all,

When I run revenue recognition, I have this error message "Doc. item XXXXX/XX: Only doc. items of the same profit center can be merged" and thus, the accrual revenue G/L account could not be cleared and the annual revenue account could not be credited.

We are using revenue recognition method "Point of invoicing" for "Project Fixed Price Item"

Has anyone encounter this issue and could you please share how you solve this issue? I tried to change the profit center in Sales order and Project and made them the same but the issue does not get resolved when I run revenue recognition.

Thank you.

Nguyen Ly

[HarshalVakil]

Hello Nguyen

Can you have a look on the case document : 2295257 - Error Message: Doc. Item XYZ/10 Only Doc. Items of the Same Profit Center can be Merged

Let us know in case you have further questions. Mark this thread as answered if this resolves your issue.

Regards,

Harshal

[Former Member]

Hi Harshal,

Thank you for your reply! I tried to access the case 2295257 but the link does not work, could you give me the pdf if you have it?

Thanks a lot for your help!

Regards,

Nguyen Ly

[HarshalVakil]

Hi Nguyen,

here is the content of the Document :

Description

You have run the Revenue Recognition for the sales order in question and you see the run got generated with errors.

Doc. item XYZ/10 Only doc. items of the same profit center can be merged

Reproducing the Issue

1. Go to Cost and Revenue work center.
2. Go to Periodic Tasks view.
3. Select Revenue Recognition subview.
4. Click on the Revenue Recognition ID you need.
5. Go to tab Processed with Errors.

You can see the error message:Doc. item XYZ/10 Only doc. items of the same profit center can be merged.

Cause

The Profit Center assigned to the sales project, related to the sales order item, differs from the actual project assignment for this particular sales docuemnt item.

Resolution

You need to reassign the profit center in the sales document item:

1. Go to Cost and Revenue Work Center.
2. Go to Sales Document Items View.
3. Search for Sales Document ItemsXYZ/10.
4. Click on Reassign -> Profit Center.
5. Enter the correct Profit Center.

Let me know in case you still face an issue.

Regards,

Harshal

[HarshalVakil]

Hello Nguyen,

You will also have to consider the following case document for the resolution.

Description

You have run the revenue recognition for the sales order in question and you see the run got generated with errors.

Doc.Itm XX/YY: AccrualMeth. Assignment For Fixed Price Project Incomplete.

Reproducing the Issue

1. Go to Cost and Revenue Work Center.
2. Go to Periodic Tasks View.
3. Click on Revenue Recognition Sub-view.
4. Select the Revenue Recognition XYZ.
5. Select sub tab Processed with Errors.

Cause

Rule : When ever you assign the accrual method 108 - Recognize using cost-to-cost project POC to a sales order of any customer project then all associated sales orders belonging to this particular project can only have the same accrual method assigned in order to system pick them in the revenue recognition runs.

Example:

For Sales Order 1 the accrual method 108 - Cost-to-Cost project POC is assigned and linked to Customer Project ABC.

Sales Order 2 is also linked to above project and cannot have a different accrual method, for instance 207 - Recognize based on manual amounts or any other.

Resolution

System is working as designed and all the sales orders associated to the project should be having same accrual method. This applies only in case of accrual method 108 -  Cost-to-Cost Project POC, so that below formula works. Otherwise the system will not able to perform the revenue recognition.

All fixed-price sales order items that are in the same project are bundled into a single item for the purposes of revenue recognition.

In order to be bundled into a single item, the sales order items must point to the same company, segment, profit center, and customer.

• POC is calculated by dividing the total actual cost for the bundled sales order items by the estimated cost of the project as a whole.

    

  Calculated POC = Total Actual Cost of Bundled Sales Order Items ÷ Total Estimated Project Cost

[Former Member]

Hi Harshal,

Thank you for your help! I managed to resolved some of the Sales Order Revenue Recognition based on your recommendation.

We have a big Project revenue recognition and now we encounter this message: "Doc. Item XYZ/AA: Use one merge item with code 'replace basic data' only"

I have aligned all Sales Orders with same Sales unit and Profit Center but rev reg still return this error.  could you please help?

Regards,

Nguyen Ly

[HarshalVakil]

Hi Nguyen,

For the error : "Doc. Item XYZ/AA: Use one merge item with code 'replace basic data' only",

We would need to analyse the details from the back end and as far as I recall, this may end up in corrections.

Can you please report an incident to SAP for this, along with your permission.

You can refer to this thread in the incident.

Regards,

Harshal

[Former Member]

Hi Harshal,

I continue to use the message 3500271672 with SAP. Hope to hear some good news soon.

Thank you very much for your help and support.

Cheers,

Nguyen Ly