Weighted average date [AX 2012]

Updated: October 7, 2011

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

Weighted average date is an inventory model based on the principle of weighted averages. Issues from inventory are valued at the average value of the items that are received into inventory for each day in the inventory closing period.

When you run an inventory closing with weighted average date, all receipts for a day are settled against a virtual issue, which holds the total received quantity and value for that day. This virtual issue has a corresponding virtual receipt from which the issues will be settled. As a result, all issues have the same average cost. The virtual issue and receipt can be seen as a virtual transfer or the weighted average inventory closing transfer.

If only one receipt occurs on or before the date, you do not have to value the average, because all issues are settled from the receipt, and the virtual transfer will not be created. If only issues occur on the date, there are no receipts from which to value the average, and the virtual transfer will not be created in this case either.

When using weighted average date, you can mark inventory transactions so that a specific item receipt is settled against a specific issue, instead of using the rule of weighted average date.

We recommend a monthly inventory closing when you use weighted average date as your inventory model.

For more information, together with examples that use weighted average date as the inventory model, see About weighted average date.


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

Community Additions

Show: