Create price and margin data (form)

Article
05/05/2014

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 > Create price and margin data.

Use this form to create and run a pricing batch job to calculate the price of finished formula products that use the commodity item specified in the Commodity pricing template. The calculation uses the approved and active default formula and route. You can run the batch job for all items in the template or for only a select set of items. You should review and update the calculated price for a product before applying it to the related trade agreement. You update prices in the Price margin update form.

Tasks that use this form

Create a commodity pricing batch job

Navigating the form

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

Tabs

Tab	Description
General	Specify the pricing calculation and pricing template for the pricing batch job you want to run. Use the Select button on this tab to enter selection criteria for locating the items or item groups to include in the batch job.
Batch	Set up a batch job to run the pricing calculation.

Buttons

Buttons	Description
Select	Open the standard Inquiry form to enter selection criteria to locate items or item groups to include in the batch job. When you click OK, the item range or item group range you selected is displayed in the Items group on the General tab.
Recurrence	Open the Recurrence form to set up a recurring pattern for the batch job. This button is available on the Batch tab.
Alerts	Open the Setup alert for batch job form to set up alert criteria for the batch job. This button is available on the Batch tab.

Fields

Field	Description
Pricing calculation	View or select the pricing calculation identifier for the batch. If you do not know the identifier, you can enter an effective date in the Run effective date field to display pricing calculations for this date in the drop-down list.
Cost basis type	View or select the cost basis type for the pricing calculation. If you selected a pricing calculation identifier, its cost basis type is displayed automatically and you cannot change it.
Site	View or select the site for the pricing calculation.
Run effective date	View or select the effective date of the pricing calculation. If you selected a pricing calculation identifier, its effective date is displayed automatically and you cannot change it.
Pricing template	Select the commodity pricing template that you want to use for the batch.
Profit-setting	View or select the profit setting for the selected pricing calculation.
Item number	The item number range for the items associated with this price and margin record.
Item group	The item group range for the items associated with this price and margin record.
Batch processing	Select the check box to enable batch processing to run.
Task description	Enter the caption to use for the batch job.
Batch group	Select a batch group to attach the batch job for processing.
Private	Select the check box to restrict other users from processing this batch. A private batch job can be run only by the user who submitted it and only at the computer where the user is logged on.