Formula calculation results (form) [AX 2012]

Updated: October 17, 2012

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Click Inventory and warehouse management > Common > Formula. Select the formula version in the lower pane and then click Calculation.

Use this form to perform product cost rollup calculations for a single manufactured item and costing version. You can also use it for all manufactured items when you perform formula calculations for a costing version. The formula calculation generates a pending item cost record in the costing version. It also generates an Infolog that contains any applicable warning messages. The formula calculation can optionally calculate a suggested sales price that is based on either a cost-plus markup approach or a rolled-price approach. It can also generate a sales price record in the costing version.

A variation of this form is used in the context of a sales order, sales quotation, or service order line item. You can use this variation to perform an order-specific formula calculation that generates a calculation record that is displayed in the Formula calculation results. It also generates an Infolog that contains any applicable warning messages. The calculation record includes a calculated cost and a calculated sales price that are based on a cost-plus-markup approach. Each order-specific formula calculation generates a calculation record in the Formula calculation results form, which is uniquely identified by a calculation number. An order-specific formula calculation does not generate a cost record in a costing version.

The following table provides descriptions for the controls in this form.

Tab

Description

General

Enter the information that will be used for the formula calculation.

Price recording in version

Select whether the formula calculation should generate item cost records or sales price records in the costing version.

This tab does not apply to order specific formula calculations.

Batch

Enter or change the batch criteria to run a job or report at a specific time or on a different computer. The batch job or report is submitted to a central batch list, where the jobs are prioritized, queued, and run according to the criteria you enter. You can use the Recurrence button to set up a recurring pattern for the batch job.

Button

Description

Select

Open the Calculation inquiry form to filter and sort associated records.

Recurrence

Open the Recurrence form to set up criteria for a permanent or temporary recurring batch job.

Batch

Enter or change the batch criteria to run a job or report at a specific time or on a different computer. The batch job or report is submitted to a central batch list, where the jobs are prioritized, queued, and run according to the criteria you enter. You can use the Recurrence button to set up a recurring pattern for the batch job.

Field

Description

Item number

The identification for the formula item.

Costing version

Select the costing version.

NoteNote

The costing version does not apply to an order-specific formula calculation because calculations always reflect the current active costs.

Site

Select the site when you use multisite functionality. The value reflects the site that was specified as a policy for the costing version.

For an order specific calculation, the site reflects the originating line item. You can enter a different site for simulating the manufacturing costs at a different site

Calculation date

Select the calculation date. This date determines which formula and route will be used for the calculation. The calculation date also determines the applicable cost records because each cost record has an effective-from date. The value will reflect the calculation date that was specified as a policy for the costing version.

For an order-specific formula calculation, the value will reflect the date on the originating line item. For example, the value reflects the confirmed ship date if it is specified, or it reflects the requested ship date on the originating sales order line item.

Cost price model

Select the source of cost data for valuing the components' cost contribution to the product. The source can reflect the cost data in the costing version, or it can reflect the basis that is specified in the formula calculation group that is assigned to each item.

For example, the calculation group can indicate the use of purchase price trade agreements as the source of costs. Only a formula calculation involving a costing version for planned costs can use the basis that is specified in the formula calculation group.

The option for the cost price model reflects the option that was entered for the costing version, which cannot be overridden if you selected a calculation restriction in the Costing versions form.

For an order-specific formula calculation, the choice of a cost price model does not exist. The source of cost data always reflects the current active cost records.

Purchase price model

Select to calculate the purchase cost based on trade agreements or the purchase price of the costing version.

Explosion mode

Select the method to apply for calculating the cost contributions. The options include the following:

  • Multilevel ─ The calculated cost reflects a complete recalculation of costs for all manufactured components in a multilevel bill.

  • Make to order ─ The calculated cost reflects a complete recalculation for all manufactured components, but the specified quantity will be used to amortize constant costs that are associated with manufactured components instead of each item's standard order quantity).

  • Single level ─ The calculated cost reflects the previously calculated costs of first-level manufactured components.

  • According to BOM line type ─ The calculated cost reflects a complete recalculation of costs for all manufactured components, but considers the formula line type of a manufactured component. For cost calculation purposes, a manufactured component will be treated as a purchased item when the formula line type is item. This option (according to the formula line type) replicates the cost calculations for production order estimates.

The explosion mode reflects the value specified for the costing version, which cannot be overridden if you selected a calculation restriction in the Costing versions form.

For an order-specific formula calculation, the explosion mode choices are limited to multilevel and make-to-order. The only difference between the two choices involves the quantity basis, which can affect the amortization of constant costs and the use of quantity-sensitive formula versions or route versions.

Item procured using

Select whether the item was procured using a production order, production flow, or purchase order.

Route number

Select the route number if the item was procured using a production order.

Production flow

Select the specific production flow if the item was procured using a production flow.

Fallback principle

Select the fallback principle for the formula calculation. The fallback options include None, Active, and Costing version.

Use a fallback status of None when you use a one-version approach to cost data updates. Use the other fallback options when the costing version represents the incremental cost updates in a two-version approach. The option indicates the alternate source of cost data if it does not occur in the costing version. An alternate source consists of either the active costs (regardless of costing version) or a specified costing version.

The fallback status reflects the value specified for the costing version, which cannot be overridden if you selected a calculation restriction in the Costing versions form.

For order-specific formula calculations, the choice of a fallback status does not exist. The course of cost data always reflects the current active cost records.

Fallback costing version

Select the costing version that contains the cost data that will be used as a fallback when you use the fallback principle. The fallback version reflects the value that is specified for the costing version. It cannot be overridden if you selected a calculation record that is displayed in the Calculation form.

Formula

The identification for the formula that was selected to perform the calculation.

CW quantity

The quantity in catch weight units if the formula version item is a catch weight item.

Quantity

The formula size.

Profit-setting

Select the set of profit-setting percentages that will be used for calculating a suggested sales price based on a cost-plus mark-up approach. The profit setting reflects the value that is defined for the costing version. This cannot be overridden if you selected a calculation restriction in the Costing versions form.

Update/insert calculated prices

Select whether the formula calculation should overwrite the pending cost record for an item. Or, the formula calculation could update it when a pending cost record does not exist for the specified costing version, site, and effective date. This is termed a missing cost, which can indicate a new manufactured item or an item that requires recalculation. An item's pending cost record can be deleted so that it is treated as a missing cost.

When trying to update costs for selected items with missing costs, it may be useful to be notified when a selected item already has a pending cost record. This would prevent the outcome of updating the missing costs. Use the formula calculation warning policy associated with identifying missing updates to identify that an item's pending cost record already exists. This then generates a warning message to display in the Infolog that is generated by the formula calculation.

This policy does not apply to an order-specific formula calculation.

Record cost price and charges

Select whether the formula calculation should generate pending item cost records in the costing version. A policy in the costing version determines whether cost records can be added to its content.

Order-specific formula calculations do not generate a cost record in a costing version. However, they do generate a calculation record that is displayed in the Calculation form.

Record sales price and charges

Select whether the formula calculation should generate pending sales price records for the item. A policy in the price version determines whether sales price records can be added to its content.

Order-specific formula calculations always generate a calculation record that is displayed in the Calculation form, with the sales price information included.

Override group setup

Select whether to override the warning conditions that are associated with the formula calculation group that is assigned to each item. The formula calculation generates an Infolog that contains warning messages that reflect applicable warning conditions. You must select this check box to enable the individual warning check boxes.

Identify missing updates

Select whether the Infolog should identify items with an existing pending cost record. This prevents the outcome of updating missing costs. The policy should be used together with the formula calculation policy to update or insert calculated prices only for items with missing costs.

Display fallback data

Select whether the Infolog for the formula calculation should identify the items that required the use of a fallback when an item's costs did not exist. The policy does not apply to order-specific formula calculations.

Batch processing

Select to allow for batch processing.

Task description

Enter a description for the task to be performed in the batch processing job.

Batch group

Select the batch group to attach the job.

Private

Select to restrict other users from processing your batch job. A private job can bed run only by the user who submitted it and only on the computer where the user is logged on.


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

Show: