Hi,
We identified that when inventory is blocked during an inventory close that the value of the blocked inventory quantity is not taken into account for determing the weighted average.
Example:
- Purchased goods 500 pieces at €15 per piece.
- Purchased goods 1000 pieces at €10 per piece.
- 200 pieces are not blocked
- 800 pieces are blocked by an inventory blocked transaction (for example: quality order). This inventory transaction is marked with the inventory blocked inventory transaction (= standard D365).
Currently the system calculates the weighted average as follows: ((500*15) + (200*10)) / 700 = €13,57. Because the 800 pieces are directly marked with the inventory blocked inventory transaction these are not taken into account.
Our customer expects the average to take into account all the received goods: ((500*15) + (1000*10)) / 1500 = €11,67. Is there a way to get this configured?
Here's another example. This might make it more complex, the general question is: how to take into account blocked inventory during weighted average inventory closing calculation?