SAP Knowledge Base Article - Public

3580618 - Updated Inventory Cost is not Determined in the Customer Invoice

Symptom

The inventory cost of a product was updated in the Product Master Data but the updated Inventory Cost is not reflected in a Customer Invoice created after the Inventory Cost was updated.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Product and Service Portfolio work center.
  2. Select the Products view.
  3. Open the Product Master Data of Product XYZ (XYZ represents the Product ID).
  4. Navigate to the Valuation tab
  5. Select the respective Company.
  6. You can see that the following Cost are maintained:
  7. 10.00 EUR with the Valid From 01.01.2025 and the Valid To Unlimited (01.01.2025 represents an example date of the past, 10.00 EUR is an example of the Amount of the Cost).
  8. Click on Edit Cost and enter 20.00 EUR with the Valid From 01.03.2025 and click OK (01.03.2025 represents an example the new valid from date of the new Cost and 20.00 EUR is an example of the Amount of the new Cost).
  9. The newly created Inventory Cost of 20.00 EUR has then the Valid From 01.03.2025 and the Valid To Unlimited and the previously maintained Inventory Cost have the Valid From 01.01.2025 and the Valid To 28.02.2025.

  1. Go to the Customer Invoicing work center.
  2. Select the Invoice Requests view.
  3. Select Outbound Delivery Invoice Request ABC (ABC represents the ID of the Outbound Delivery Invoice Request).
  4. Click on the Invoice button.
  5. In the New Invoice navigate to the Pricing tab.
  6. Expand Line Item.
  7. The Cost is 10.00 EUR. You expect the Cost to be 20.00 EUR since it has been changed in the Product Master Data to 20.00 EUR

Cause

  • The cost in an invoice is taken over from the preceding document, in this case, the Sales Order.
  • The Pricing Date of the Sales Order falls into the Valid From and Valid To Dates of the previously maintained Cost in the Product Master Data.
  • Hence, the cost determined for the item in the Sales Order and consequently in the Invoice is 10.00 EUR.

You can check the Pricing Date and the Cost in the Sales Order as follows: 

  1. Go to the Sales Orders work center.
  2. Select the Sales Orders view..
  3. Open the respective Sales Order.
  4. Navigate to the Pricing tab.
  5. The Pricing Date in our example is the 01.02.2025 which falls into the Inventory Cost maintained in the Product Master Data with the Valid From 01.01.2025 and the Valid To 28.02.2025.
  6. Expand the Line Item
  7. You can see that the Cost is 10.00 EUR in our example.

Resolution

  1. Understand that this is the expected system behavior.
  2. The cost in an invoice is determined from the preceding document, not directly from the Inventory Cost.
  3. If the Inventory Cost is updated after the creation of the Sales Order, the updated cost will not reflect in the invoice generated from that Sales Order.

See Also

KBA 2609104 - Customer Invoice Takes Inventory Cost From Sales Order Not From Outbound Delivery or Customer Invoice

Keywords

Inventory Cost, Invoice, Sales Order, Cost Discrepancy, Material Cost Update, Expected System Behavior. , KBA , SRD-CRM-INV , Customer Invoicing , Problem

Product

SAP Business ByDesign all versions