SAP Knowledge Base Article - Public

2190266 - Current Earned CoGS Amount Differ In Each Set Of Books In The Revenue Recognition

Symptom

After running the Revenue Recognition, it is observed that the Current Earned Cost of Goods Sold amount varies across the results in each set of books.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Cost and Revenue work center.
  2. Go to the Revenue Recognition sub-view.
  3. Select the respective Revenue Recognition ID.
  4. From the List of Logs, open the Set of Book PQR results.
  5. Navigate to the Processed Successfully tab.
  6. Find the relevant Sales Order ID against which the Current Earned CoGS Amount is showing as, for instance, 45,000.00.
  7. Again from the List of Logs, view the results for Set of Book XYZ.
  8. Navigate to Processed Successfully tab and for the same Sales Order ID against which the Current Earned CoGS Amount is showing as, for instance, 48,000.00.


Note: 'PQR' and 'XYZ' refers to the respective Set of Book IDs.

Cause

  1. Go to the Inventory Valuation work center.
  2. Select the Material Unit Costs sub view under Master Data view.
  3. Select All Unit Costs and search for the Material.
  4. Highlight the Material ID with the respective Business Residence ID/Company.
  5. Select View Cost History button.
  6. Navigate to select the same Period/Year that matches your Revenue Recognition.

For Set of Book PQR the Resulting Inventory Cost is 45,000

For Set of Book XYZ, the Resulting Inventory Cost is 48,000, but the rate was updated to 45,000 only after the execution of the Revenue Recognition. Consequently, this updated rate is used and displayed as the Current Earned CoGS for this Set of Book.

Resolution

The material used in the sales order processing determines the Earned CoGS. The difference in value for each of Set of Book is due to the Material Unit Costs that is valid for each Set of Book at the time of running Revenue Recognition and its selection criteria.

Postings are inline with the above rates maintained. If the difference in values across the sets of books is unacceptable, the respective Revenue Recognition ID can be reversed by executing a new Revenue Recognition with the same selection criteria. After the reversal, verify the applicable rates, make corrections if necessary, and then rerun the Revenue Recognition process.

Keywords

Earned CoGS, Amount, Differ, Varies, Set of Books, Different, Revenue Recognition , KBA , SRD-FIN-COR , Cost & Revenue , How To

Product

SAP Business ByDesign all versions