SAP Knowledge Base Article - Public

2374057 - Revenue Recognition Run Does Not Consider Supplier Invoice Discounts/ Surcharges

Symptom

You execute the Revenue Recognition Run. It finishes with the error 'Costs without assignment to a sales order exists for project.'
You ensure that all project expenses have been assigned to a Sales Order item.
Still, the warning appears.
You then check all expense postings as well as the expense assignment to sales document postings, the Customer Project Expense List (CPELs). Here, you notice a difference between supplier invoice amounts and their respective CPEL postings.

Environment

SAP Business ByDesign

Reproducing the Issue

Pre-Condition:

  • An Accrual Method is assigned to the project sales order item.
  • All project expenses have been assigned to Sales Order items in Project Management - Not Invoiced Times and Expenses.
  • All project expenses are to be realized with the Revenue Recognition run.


To check the Revenue Recognition run log:

  1. In the Cost and Revenue work center go to the Periodic Tasks - Revenue Recognition view.
  2. Find the respective Revenue Recognition run and open it.
  3. Navigate to the Messages tab.
  4. The warning 'Costs Without Assignment To A Sales Order Exists For Project' is displayed.

To check the expense and CPEL postings, open, for instance the Sales Accruals Report to view the unassigned, deferred expenses.

  1. In the Project field enter the Project ID.
  2. Use the following Characteristics and Sorting:G/L Account
    - G/L Account (Origin)
    - Associated Source Document Type
    - Associated Source Document ID
    - Business Transaction
    - Journal Entry
    - Associated Sales Order item: Enter #
  3. You can now see that the Supplier Invoice ABC (ABC represents the Supplier Invoice ID) was posted with the amount, say, 950,00 LC (LC stands for Local Currency).
  4. You also see a posting of type Expense Assignment to Sales Document. You expect that this is also posted with the amount 950,00 LC. However, it is posted with a different amount, -1000,00 LC.
    This results in an unassigned difference of -50,00 LC.

Cause

In Supplier Invoice ABC a Discount was maintained in the Deductions and Surcharges tab.
The deduction updates the Gross Amount of the Supplier Invoice expense posting. But it does not update the CPEL posting. Here, the whole invoice amount without any discount (here, 1000,00 EUR) is considered.
Similarly, surcharges are not considered in CPEL postings.

Resolution

Currently, deductions or surcharges maintained in the Deductions and Surcharges tab of a sales project relevant supplier invoice are not considered for CPEL postings.
The differences need to be manually assigned to the respective sales order item:

  1. In the General Ledger go to the Journal Entries - Journal Entry Vouchers view.
  2. Press New - Journal Entry Voucher.
  3. In the new screen select Journal Entry Type 00088 - Manual Entry for Sales Documents and Screen Variant 633 - Man. Adjusting Entry for Sales Documents.
  4. Maintain the Posting date.
  5. In the Line items table press Add Row.
  6. In the G/L Account field select the G/L Account defined for Deferred Costs of Goods Sold (Deferred COGS).
  7. If the deferred, unassigned amount results from a discount, so that the difference appears negatively, for instance, -50,00 LC enter the difference amount in the Debit* field.
  8. In the G/L Account (Origin) field enter the expense account where the expense is to be realized, for instance G/L Account XXXXXX (XXXXX represents the Expense Account/G/L Account (Origin) ID).
  9. In the Project task field enter the Project Task ID which is assigned to Supplier invoice item ABC-A (ABC-A represents the Supplier Invoice item ID).
    Press Add row again.
  10. In the next Line, in the G/L Account field enter the Expense account ID XXXXXX.
  11. In the Credit* field enter the difference amount, 50,00 LC.
  12. In the Sales Doc type field select 114-Sales Order.
  13. In the Sales Doc ID field enter the Sales Order ID DEF (DEF represents the Sales Order ID).
  14. In the Sales Doc. Item ID field enter the Sales Order item DEF-XX (DEF-XX represents the Sales Order item ID).
  15. In the G/L Account (Origin) field enter again Account XXXXX. Ensure that the correct project task is generated in the Project Task field.
  16. Press Post.

*If the deferred, unassigned amount appears positively in the Sales Accruals report, credit the Deferred COGs account and debit the Expense account.

After this the unassigned amount is cleared and the Revenue Recognition run will finish without warnings.

Keywords

Surcharge, Discount, CPEL, Costs without assignment to a sales order exist for project , KBA , surcharge and discount in cpel missing , cost without surcharge posted in cpel , SRD-FIN-COR , Cost & Revenue , How To

Product

SAP Business ByDesign all versions