New options restrict update of product and commission costs

The prices for commodity products can fluctuate due to many conditions, for example, geopolitical developments, supply chain issues, or long gaps between when an order is placed and when it is delivered. However, you may not want the Sales Entry Invoice Processing Report to recalculate the order line sales costs and product commission costs for any number of business reasons, such as a requirement to record the original costs in accounting journals.

Now, you can determine at the product or warehouse level whether the product costs and commission costs are recalculated by the Sales Entry Invoice Processing Report.

Use these new options to restrict updates to the current sales order line costs and product commission costs on an order:

  • Product Setup-General
    • Use Current Sales Mgr Cost
    • Use Current Commission Cost
  • Product Warehouse Product Setup-Costs
    • Use Current Sales Mgr Cost
    • Use Current Commission Cost
Note: The values specified in the Use Current Sales Mgr Cost and Use Current Commission Cost fields in Product Warehouse Product Setup-Costs override the values in Product Setup-General.

These API calls are changed:

  • sxapiICProductMnt: Added these new fields as input.
  • sxapiicgetwhseproductdatageneralv3: These new fields are updated in this API by sxapiICProductMnt.
  • sxapiICGetProductDataGeneralV4: Output includes these new fields.
Note: When the product cost is recalculated by invoice processing, but commission cost is not, the commission is calculated based on the original product cost.

Feature activation

You can enable this feature by selecting the appropriate options for the new fields in Product Setup-General or in Product Warehouse Product Setup-Costs. The settings at the warehouse level take precedence over the settings at the product level.