Hi to all;
What are the differences between the Weighted Average and the Weighted Average Date in Dynamics AX 2009??? is the Weighted Average is Periodic Inventory while the Weighted Average Date is Perpetual Inventory ???
Thanks with Regards
Mourad Shkour
Taken form the help, says it pretty well:
Weighted Average
Weighted average is an inventory model based on the weighted average principle, where issues from inventory are valued at the average value of the items that are received into inventory in the inventory closing period, plus any on-hand inventory from the previous period. When you run an inventory closing, all receipts are settled against a virtual issue, which holds the total received quantity and value. This virtual issue has a corresponding virtual receipt from which the issues are settled. In this way, all issues get the same average cost. The virtual issue and receipt can be seen as a virtual transfer, called the “weighted average inventory closing transfer”.
If there is only one receipt, all issues can be settled from it and the virtual transfer will not be created.
When using weighted average, you can choose to mark inventory transactions so that a specific item receipt is settled against a specific issue, instead of using the weighted average rule.
We recommend a monthly inventory closing when you use the weighted average inventory model.
Weighted Average Date
Weighted average date is an inventory model based on the weighted average principle, where issues from inventory are valued at the average value of the items that are received into inventory for each separate 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. In this way, all issues get the same average cost. The virtual issue and receipt can be seen as a virtual transfer, called the “weighted average inventory closing transfer”.
If only one receipt has occurred on or before the date, it is not necessary to value the average because all issues are settled from it and the virtual transfer will not be created. Likewise, 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 choose to mark inventory transactions so that a specific item receipt is settled against a specific issue, instead of using the weighted average date rule.
We recommend a monthly inventory closing when you use the weighted average date inventory model.
The What’s new in AX5 manual probably still on Partnersource also describes this with charts and in more detail with examples.
is the Weighted Average is Periodic Inventory while the Weighted Average Date is Perpetual Inventory ???
ALL INVENTORY COSTING METHOD CAN BE UNDER PERIODIC OR PERPETUAL SYSTEM.
Periodic inventory method calculate ending stock at the end of the accounting period, which could be Month to Date or Year to Date,
while Perpetual inventory system calculates the ending stock on a continuous basis after each transaction (Purchase or Sell).
AND IT IS HOW YOU SET-UP YOUR ITEM POSTING PROFILE.