Create reference tables

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

Reference tables are used as the basis for calculations for the distribution or allocation of costs or quantities. Reference tables are typically used when references are fixed for several periods. Examples of reference tables are square meters, headcount, equipment calculation, and so on.

1. Click Cost accounting > Setup > Calculation > Reference tables.

2. Press CTRL+N to create a new line.

3. In the Reference table field, enter a name for the reference table.

4. On the General tab, select the dimensions that you want to use in this reference table.

5. Click Cost accounting > Setup > Calculation > Calculation versions.

6. Click Reference table to open the Reference table values form.

7. On the Overview tab, in the list of created reference tables, click the reference table that you created in the Reference tables form.

8. On the General tab, select the dimensions that you want to enter the references for, and then enter the total reference quantity in the Reference quantity field.

9. Enter the reference quantity for each dimension that you want to allocate.

10. Confirm that the value in the Difference field is 0 (zero).

Example

The most common example of a reference table is the cost center building. Here, the costs are allocated by square meters, as shown in the following table.

If the total costs on the cost center building are USD 1,000, the period calculation will allocate USD 250 to the cost center's stock, USD 250 to the production 1, and so on.

See also

Reference tables (form)