SAP Knowledge Base Article - Public

1473507 - Cost Determination Error When Adding Material to a Sales Order

Symptom

When adding a material to a sales order the following error occurs:

“Item XX: Costs not determined: There is no active inventory price for material ABC in company 1000 (EFG)”.

The document cannot be saved.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Sales Orders work center.
  2. Select the Sales Orders view.
  3. In the Show field select the All Orders option and press the Go button.
  4. Select the sales order XYZ (XYZ represents the number of the sales order).
  5. Open the sales order and press the View All button.
  6. Select the Items tab.
  7. Add product ABC (ABC represents the identification name of the product)  
  8. Following error occurs:
    Item XX: Costs not determined: There is no active inventory price for material ABC in company 1000 (EFG). (XX represents the line item number and EFG represents the name of the seller party).

However, the material and costs have been maintained (cost type inventory cost) in the product master data.

 

Cause

When adding an item the system will compare the posting date of the document with the validity of the the sales prices and for consistency also to the inventory prices of the item. The validity of the inventory price for material ABC needs to be changed to the posting date/pricing date of the sales order or earlier.

When a sales order was created as a follow-up from a sales quote, the pricing related data are copied from the sales quote.

The posting date/pricing date will be compared with the validity of the sales price and for consistency also with the inventory price of the newly added item and with the validity date of this particular item. As this date is the same for the header level of the sales order, it is also valid for an item added newly in the order. Hence, also for material ABC the access is done with the posting date/pricing date of the sales quote. However, the inventory price for material ABC is only valid as of a later date than the posting date/pricing date  of the sales quote. Therefore the validity of the inventory price for material ABC needs to be changed to the posting date/pricing date of the sales quote or earlier.

Resolution

Since the inventory price for material ABC is only valid as of a later date than the posting date/pricing date of the sales order or if the sales order was created as a follow up document of the sales quote, the validity of the inventory price for material ABC needs to be changed to the posting date/pricing date of the sales order / sales quote or earlier.

  1. Go to the Product and Service Portfolio work center.
  2. Select the Products view.
  3. Select the material ABC and press the Edit button.
  4. Press the View All button and go to the Valuation tab.
  5. Select the respective line for the cost determination and press the Edit Costs button.
  6. In the pop up window Input Parameters for Edit Cost enter a date in the in the Valid From field which is equal to the posting date/pricing date of the sales order / sales quote or an earlier date.
  7. Press the OK button.
  8. Press the Save and Close button.

You can now enter the material ABC in the sales order XYZ and save the document. The error will not occur anymore.

Keywords

Costs not determined; Sales Order; Pricing Date; Add Product; Inventory Costs; , KBA , AP-SLO , Sales Order Processing , How To

Product

SAP BUSINESS BYDESIGN 1611 ; SAP BUSINESS BYDESIGN 1705 ; SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1.0 ; SAP Business ByDesign 1302 ; SAP Business ByDesign 1305 ; SAP Business ByDesign 1308 ; SAP Business ByDesign 1311 ; SAP Business ByDesign 1402 ; SAP Business ByDesign 1405 ; SAP Business ByDesign 1408 ; SAP Business ByDesign 1411 ; SAP Business ByDesign 1502 ; SAP Business ByDesign 1505 ; SAP Business ByDesign 1508 ; SAP Business ByDesign 1511 ; SAP Business ByDesign 1602 ; SAP Business ByDesign 1605 ; SAP Business ByDesign 1608 ; SAP Business ByDesign 1702 ; SAP Business ByDesign 1711 ; SAP Business ByDesign 1802 ; SAP Business ByDesign 1805 ; SAP Business ByDesign 1808 ; SAP Business ByDesign feature pack 2.0 ; SAP Business ByDesign feature pack 2.5 ; SAP Business ByDesign feature pack 2.6 ; SAP Business ByDesign feature pack 3.0 ; SAP Business ByDesign feature pack 3.5 ; SAP Business ByDesign feature pack 4.0

Attachments

ChineseTranslationOnly_1473507.pdf