Product costs based on vendor contracts supported

The product cost on a sales order line can now be calculated from sales cost values on Level 1-4 PD Pricing Setup records. Sales costs reflect the cost of products based on your vendor contracts. A sales cost is used as the product cost when the pricing record is applied to a sales order line.

You can include a sales cost on these types of pricing records if the pricing record is based on a cost-related value, such as cost, margin, rebated cost, or rebated margin:

• Customer/Product (Level 1)
• Customer/Product Price Type (Level 2)
• Customer Type/Product (Level 3)
• Customer Type/Product Price Type (Level 4)

The sales cost can be a fixed amount or a percentage of one of these product values:

• Base or list price
• Replacement or standard cost

You can specify a percentage on Level 1-4 pricing records, but you can only specify a fixed amount on Level 1 and 3 pricing records. The sales cost is calculated from these new fields in PD Pricing Setup: Sales Cost, Sales Cost Based On, and Sales Cost Amount.

Typically, the product cost is determined by settings in SA Administrator Options-Products-Costs and is based on values from Product Warehouse Product Setup records. If a sales cost is applied to a line, it is not considered an override of the cost that is based on a Product Warehouse Product Setup record. A sales cost can be applied to a sales order line whenever line pricing occurs, including line creation through BODs, API calls, and imported spreadsheets.

If a sales cost was applied to a special line or direct order line, it is not updated when the tied purchase order or warehouse transfer is received. Instead, the cost from the receiving line is saved internally and is used to calculate GL cost during invoice processing.

If you use the pricing worksheet in Sales Order Entry and Sales Customer Pricing Inquiry, the sales cost affects pricing calculations if you apply Cost + or Margin % pricing. Additionally, as part of this enhancement, the percentage fields for Cost +, Margin, and Discount on the pricing worksheet now support four decimal places.

In support of this enhancement, the sxapiPDPricingMnt call, which is used to create or maintain pricing records, now includes the new sales cost fields. Additionally, you can extract the sales costs values from pricing records to the Infor Data Lake using the SA Administrator Birst Extraction Report. Updates were also made to these functions:

PD Mass Maintenance Entry Sales Order Audit Report

PD Customer Pricing Master List Report Data Conversion PD Customer Pricing PDSC Reports