Hello,
I have a requirement in AX-2012 R2 and the details as follows:
I will always procure items into our main warehouse (MW) and do the inventory transfer to sub warehouses. The sub warehouses can be either same site or different sites. I am following “Weighted Average” valuation method. Here my problem start for example:
-
I procure Item A 10 quantity 100 dollar and received into main warehouse. This is my first PO
-
Once item received and invoiced, do a transfer to another sub warehouse 5 quantity
-
Now main warehouse having 5 quantity and sub warehouse having 5 quantity, when I check the cost in both warehouse the average cost will be 100. Till now no issue for me
-
Now I procure one more PO 10 quantity at 200 dollar rate into main warehouse, in this situation the average cost of same item in main warehouse will 166.66 i.e. (2,500 (Value) / 15 (Quantity) This is also absolutely fine at my end
-
Now when I do another 10 quantity transfer to same sub warehouse the item will be transferred with the rate of 166.66 and average cost of the sub warehouse will be 144.44 i.e. (2,166.6 / 15)
-
2,166.6 is derived as follows: 500 (100 * 5) + (166.66 * 10)
-
The point number 6 is my issue, as customer require the main warehouse latest average cost should be applied throughout all sub warehouse level.
Please let me know if this is possible in AX 2012 R2 to achieve this functionality and if possible kindly let me know how?
Thanks in advance and looking for a help.
Regards,
SAJEESH