Export (0) Print
Expand All

Track running average cost per inventory dimension [AX 2012]

Updated: November 8, 2010

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

Each inventory item is assigned an inventory dimension group. The running average cost price for an item is therefore calculated based on the selection of inventory dimensions that are being tracked financially.

There are three different types of inventory dimensions: product, storage, and tracking. Product dimensions include configuration, size, and color. Product dimensions are always tracked financially. Storage and tracking dimensions include site, warehouse, batch number, location, pallet ID, and serial number. You decide which storage and tracking dimensions will be tracked financially.

If the inventory dimension group attached to the item is financially tracked by warehouse, the running average cost price is calculated per warehouse.

The following purchase orders have been invoiced:

  • Purchase order for a quantity of 2 at a cost price of USD 10.00 has been invoiced for warehouse GW

  • Purchase order for a quantity of 3 at a cost price of USD 12.00 has been invoiced for warehouse GW

  • Purchase order for a quantity of 5 at a cost price of USD 15.00 has been invoiced for warehouse MW

The running average cost price for warehouse GW is USD 11.20

The running average cost price for warehouse MW is USD 15.00.

A sales order invoice is posted for warehouse GW. The value of the inventory and cost of goods sold (before inventory close is run and without marking) will be USD 11.20. Another sales order is posted for warehouse MW. The value of the inventory and cost of goods sold (before inventory close is run without marking) will be USD 15.00.

If the inventory dimension group attached to the item is financially tracked by warehouse and batch number, the running average cost price will be calculated for each batch.

NoteNote

We recommend always viewing the cost price with all financial dimensions being tracked.

The following purchase orders have been invoiced:

  • Purchase order for a quantity of 2 at a cost price of USD 10.00; invoiced for warehouse GW and batch AAA

  • Purchase order for a quantity of 3 at a cost price of USD 12.00; invoiced for warehouse GW and batch AAA

  • Purchase order for a quantity of 2 at a cost price of USD 15.00; invoiced for warehouse GW and batch BBB

The running average cost price for warehouse GW and batch AAA is USD 11.20.

The running average cost price for warehouse GW and batch BBB is USD 15.00.


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft