VA Order Entry - Detail - Value Add Rollup field descriptions

Fields are listed in alphabetical order.

Addons
Read-only field field displaying the total addon amount from the VA order.
Calculation Type

Select whether Margin or Markup values display in these fields:

  • Price Labor Based on Cost Margin/Price Labor Based on Cost Markup
  • Price Inventory Based on Margin/Price Inventory Based on Markup
  • External Process Margin/External Process Markup
  • Internal Labor Margin/Internal Labor Markup
  • Non-Stock Margin/Non-Stock Markup
  • Inventory Margin/Inventory Markup

The specified value in the Pricing Worksheet Calculation Default field in SA Administrator Options-Documents-Value Add-Entry Settings determines the default value in this field.

Click Recalculate after changing the option to update the related field values.

Current OE Line Cost Margin
Displays, for comparison, the OE line item margin cost before the changes on the Value Add Rollup. Data is displayed when the Value Add Rollup is activated from Sales Order Entry or VA Order Entry where the VA order is tied to a sales order line directly or by warehouse transfer.
Current OE Line Price/Each
Displays, for comparison, the order entry line item price before the changes on the Value Add Rollup. Data is displayed when the Value Add Rollup is activated from Sales Order Entry or VA Order Entry where the VA order is tied to a sales order line directly or by warehouse transfer.
Customer Rebates
Read-only field showing any customer rebate amount that is available based on the products used to fabricate the final product.
External Process Cost
Read-only, calculated field based on values entered in the worksheet.
External Process Margin/External Process Markup
Enter a margin or markup percentage value to calculate the External Process Cost and External Process Price.
External Process Price
Read-only, calculated field based on values entered in the worksheet.
Internal Labor Cost
Read-only, calculated field based on values entered in the worksheet.
Internal Labor Margin/Internal Labor Markup
Enter a margin or markup percentage value to calculate the Internal Labor Cost and Internal Labor Price.
Internal Labor Price
Read-only, calculated field based on values entered in the worksheet.
Internal Parts Cost
Read-only field showing the cost of all non-labor products used in the Internal Processing sections on the VA order.
Internal Parts Price
Read-only field showing the price of all non-labor products used in the Internal Processing sections on the VA order.
Inventory Cost
Value is calculated based on the specified value in the Price/Cost Used for Inventory field in SA Administrator Options-Documents-Value Add-Entry Settings. This cost value is used as the basis for the system-generated pricing or the calculated Markup or Margin pricing in the Value Add Rollup.
Inventory Margin/Inventory Markup
Enter a margin or markup percentage value to calculate the Inventory Price.
Inventory In Cost
Read-only field showing the cost of all products returned to stock on an Inventory In section on the VA order
Inventory In Price
Read-only field showing the price of all products returned to stock on an Inventory In section on the VA order
Inventory Price

When the Price Inventory Based on Margin/Price Inventory Based on Markup option is cleared, the Inventory Price value is calculated by running normal system pricing for each inventory component using the pricing cost value selected in the Price/Cost Used for Inventory field in SA Administrator Options-Documents-Value Add-Entry Settings.

When the Price Inventory Based on Margin/Price Inventory Based on Markup option is selected, the Inventory Price value is calculated using the Inventory Cost and Inventory Margin/Inventory Markup entered by the user on the worksheet.

Margin
Read-only field showing the margin for the final product on the VA order.
Margin Percent
Read-only field showing the margin for the final product on the VA order.
Non-Stock Cost
Read-only, calculated field based on values entered in the worksheet.
Non-Stock Margin/Non-Stock Markup
Enter a margin or markup percentage value to calculate the Non-Stock Cost and Non-Stock Price.
Non-Stock Price
Read-only, calculated field based on values entered in the worksheet.
Price Inventory Based on Margin/Price Inventory Based on Markup

When cleared, Distribution SX.e calculates the Inventory Price by running normal system pricing for each inventory component using the pricing cost value selected in the Price/Cost Used for Inventory field in SA Administrator Options-Documents-Value Add-Entry Settings.

When selected, Distribution SX.e calculates the Inventory Price using the Inventory Cost and Inventory Margin or Inventory Markup entered by the user on the worksheet.

Price Labor Based on Cost Margin/Price Labor Based on Cost Markup

Controls how the External Process Price and the Internal Labor Price values are calculated.

When selected, the External Process Price is calculated using the External Process Cost and the External Process Margin/External Process Markup entered by the user on the worksheet. The Internal Labor Price is calculated using the Internal Labor Cost and the Internal Labor Margin/Internal Labor Markup entered by the user on the worksheet.

When cleared, the External Process Price is the value of the labor on the External sections on the VA order. The Internal Labor Price is the value of the labor on the Internal Processing sections of the VA order.

Price Override
Enter a value to manually override the price on the sales order line. A price override may be calculated and returned to this field by the Infor CPQ Configurator based on selected product configuration specifications.
Total Cost/each
Read-only, calculated field based on values entered in the worksheet. When you access the Value Add Rollup pricing worksheet from Sales Order Entry or VA Order Entry, clicking the Update button updates the margin cost on the sales order line item with this value. To update the sales order line item from VA Order Entry, the VA order must be tied to the sales order directly or with a warehouse transfer.
Total Price/each
Read-only, calculated field based on values entered in the worksheet. When Update Sales Order Price is selected, clicking the Update button updates the price on the tied sales order line with this value.
Update Sales Order Price
When selected, clicking the Update button updates the price on the tied sales order line with the calculated Total Price/each value. The field is selected by default when the Value Add Rollup is accessed from the Sales Customer Pricing Inquiry-Pricing Worksheet.
Vendor Rebates
Read-only field that shows any vendor rebate amount that is available based on the products used to fabricate the final product.
View Rollup Costs/Prices

Controls how the total price and cost of the final product are calculated.

When selected, the price and cost of the final product are rolled up from the prices and costs of everything used to fabricate the product.

When cleared, the price and cost are found based on values associated with the final product in ICSW and standard pricing logic.