Material price information – sales schedules

If the Material Pricing in Sales check box is selected in the Material Price Parameters (tcmpr0100m000) session, material price information can be linked to the sales schedule line.

When sales schedule lines are generated in the Sales Schedule (tdsls3611m000) session, the material price information is retrieved from the linked sales contract line. This price information is linked at schedule line level, or at planned warehouse order line level. If the sales schedule results from a processed sales release on which a price is specified, this price is also used on the schedule line/planned warehouse order line. In this case, the material price information for the schedule line/planned warehouse order line is not retrieved.

Note: The Apply Material Prices if No Contract Material Prices check box in the Material Price Parameters (tcmpr0100m000) session is used to determine if LN must search for material price information for sales schedule lines if the linked contract line has no material price information.

On the appropriate menu of the relevant lines tab in the Sales Schedule (tdsls3611m000) session, click:

  • Price and Discounts, to start the Price and Discounts (tdpcg1600m000) session, in which you can view the Price and Material Price for the sales schedule line/planned warehouse order line.
  • Material Price Information, to start the Material Price Information (tcmpr1600m000) session, in which you can view more detailed material price information for the sales schedule line/planned warehouse order line.

Updates

Material price information cannot be updated for sales schedule lines/planned warehouse order lines.

If the material price information specified for the linked contract line is modified, the schedule lines/planned warehouse order lines are not updated.

Approval

If a planned warehouse order must be generated for the sales schedule, the material price information is generated when the planned warehouse order is generated, during approval.

If planned warehouse orders are not applicable, the material price information is generated when the schedule line is created.

Actual delivery

After the items for a sales schedule line or planned warehouse order are delivered, an actual delivery line is added to the Sales Schedule Actual Delivery Lines (tdsls3140m000) and Sales Schedule Actual Delivery Lines (tdsls3140m100) sessions. The material price information is defaulted from the relevant schedule line.

Note: If the Redetermine Price and Discounts at Shipment check box is selected in the Sales Contract Lines (tdsls3501m000) session, for the linked contract line, the material price information is not defaulted from the schedule line, but is redetermined when the actual delivery line is added.

If the material actual price cannot be retrieved, LN considers the best possible option. For example, instead of using the invoice date, which is required but not yet known, the actual transaction date is used to retrieve an approximate material actual price.

You can modify prices and discounts after the schedule delivery in the Change Price and Discounts for Actual Delivery (tdpcg1600m100) session. From the appropriate menu of the Change Price and Discounts for Actual Delivery (tdpcg1600m100) session, select Material Price Information to modify the material price information, after the items are delivered, in the Material Price Information (tcmpr1600m000) session.

Consumptions

If a consumption is processed and a matching sales schedule line is found, a sales invoice line is generated in the Sales Schedule Invoice Lines (tdsls3140m200) session. The price on the invoice line and the material price information are retrieved from the schedule line/planned warehouse order line.

The material actual price is determined when the sales schedule invoice line is created for the consumed quantity of the sales schedule line. If a matching sales schedule line does not exist, a consignment invoicing order is generated. The price, discount, and the material price information for the order are retrieved from the master data.

Invoices

When releasing a sales schedule line to Invoicing, a valid material actual price is required. If no material actual price is available, the invoice cannot be composed and an error message is displayed.

You must manually specify a material actual price for the invoice line, or redetermine the actual price using the Price and Discount Recalculation Parameters (tdpcg0240s000) session.

If an invoice correction is specified for a sales schedule invoice line, a negative quantity is applicable. The amount is calculated based on the price, discounts, and material prices. The material price information cannot be updated for invoice corrections.