SAP Knowledge Base Article - Public

3014109 - Wrong Cost for Sales Document being Calculated

Symptom

The cost for invoicing and sales documents is calculated incorrectly, distorting the profit margin, even though the ship from location contains a valid business residence.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Over-the-Counter Sales work center.
  2. Select Over-the-Counter Sales view.
  3. Search for the ID ABC (ABC represents the ID of the Over-the-Counter Sale).
  4. Click Edit.
  5. Navigate to the Pricing tab.
  6. Click Expand.

The cost value displayed for the items is not being calculated as expected.

Cause

The cost component for individual items can be calculated based on the business residence maintained in Inventory Valuation work center, under the Material Unit Costs subview.

If the document is not able to determine a valid business residence, it will take the average value of all business residences maintained for that product, as per KBA 2547292.

In order to use the ship-from location to determine the business residence, a valid Identified Stock ID must be maintained for the item, otherwise the system will revert to the above functionality of taking the average of all business residences.

Resolution

This is the current system behavior.

  • Maintaining a valid Identified Stock ID in the document and triggering a pricing recalculation will allow the costs to be calculated correctly.
  • This is also considered as a new requirement and it was added in the Product Backlog in order to enhance the functionality with this feature in one of the future product releases. Meanwhile, another possibility is to reach out Development Partner for a Custom Add-On Solution.

See Also

2547292 - Cost Component of Items in Sales Order Shows Incorrect Value

Keywords

Over-the-Counter, Sale, Cost, Ship-From, Wrongly, Calculated, Calculate, Wrong , KBA , AP-PRC-PC , Calculation , How To

Product

SAP Business ByDesign all versions