Commodity pricing (form)

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

Click Inventory management > Periodic > Commodity pricing > Pricing calculation. Select a pricing calculation, and then click the Commodity pricing button.

Use this form to set up the commodity pricing cost basis information for a pricing calculation.

Tasks that use this form

Set up commodity cost basis pricing for a pricing calculation

The following tables provide descriptions for the controls in this form.

Buttons

Button

Description

Select

Open the standard Inquiry form to query commodity pricing records.

Show all

Clear all values in the Criteria field group to display all commodity pricing calculations.

Remove locks

Clear the selected Lock check boxes and the corresponding Site and Warehouse fields in the Criteria field group.

Fields

Field

Description

Pricing calculation

The identification for the calculation run selected in the Pricing calculation form.

Cost basis type

The cost basis type associated with the pricing calculation.

(Criteria)

Item number

Select an item number to query pricing calculations by item.

Item group

Select an item group to query pricing calculations by item group.

(Site)

Lock

If you query by site identification and you want to save the criteria, select this check box before you close the form. The next time that you open this form, the saved criteria are displayed. To remove the criteria, clear the check box.

Site

Select a site to query pricing calculations by site.

(Warehouse)

Lock

If you query by warehouse identification and you want to save the criteria, select this check box before you close the form. The next time that you open this form, the saved criteria are displayed. To remove the criteria, clear the check box.

Warehouse

Select a warehouse to query pricing calculations by warehouse.

Buyer group

Select a buyer group to query pricing calculations by buyer group.

Product name

The name of the product currently selected.

Price quantity

The quantity that will be used when allocating the specified miscellaneous charges to the price per unit. This quantity will be used only if the Incl. in unit price check box in the Released product details form is selected.

Unit

The number of units of the item on which the cost price is based.

Item number

The identification for the item.

Active cost price

Select this check box if the active cost for the item, which is set in the Item price form, will be used for the specified warehouse. If a warehouse is not specified for the item, the active cost will be used for all warehouses where this item is stored. If the active cost is used, the value in the New cost field is automatically updated with this amount.

Site

View or select the site for the warehouse where the item is maintained. A site can be associated to more than one warehouse.

Warehouse

View or select the warehouse where the item is located. If you leave this field blank, the value in the New cost field will be used for all warehouses where this item is maintained.

Previous cost

The cost basis from the previous pricing calculation for the item.

New cost

View or enter the new cost that can be used as the cost basis for the new pricing calculation. If you selected the Use standard cost check box, or specified a base item in the Base item field, the New cost field is display only.

Difference

The difference between the New cost and Previous cost. The difference amount is used in the automatic calculation of the New cost field using this equation: Previous cost + Difference = New Cost.

Base item

If the cost basis for the item in the Item number field will use the cost basis of a predefined base item, select the base item. You cannot use the same item number as both the item and the base item.

Base site

Select the site that is associated with the base warehouse. This field is available only if you select an item in the Base item field.

Base warehouse

View or select the warehouse in which the base item is stored. This field is available only if you select an item in the Base item field.

Price plus

View or enter the difference between the New cost for the base item, base site, and base warehouse and the Previous cost. When you enter the difference between the two amounts in this field, the value in the New cost field is automatically calculated using this formula:

New cost of Base item, Base site, and Base warehouse * Price multiplier + Change amount = New Cost. This field is available only if you select values in the Base item, Base site, and Base warehouse fields.

Price plus percentage

View or enter the difference between the New cost for the base item, base site, and base warehouse and the Previous cost. When you enter the difference between the two amounts in this field, the value in the New cost field is automatically calculated using this formula:

New cost of Base item, Base site, and Base warehouse (+ or –) Price change % = New Cost.

This field is available only if you select values in the Base item, Base site, and Base warehouse fields.

Price multiplier

View or enter the price multiplier used in the automatic calculation of the New cost of the item. This is available only when the Base item is selected.

New cost of the Item = (New cost of Base item, Base site, and Base warehouse) * Price multiplier. The default is 1.

See also

About commodity pricing

Item price (form)

Pricing calculation (form)

Released product details (form)

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