Applies to Product - Dynamics 365 Supply Chain Management
What’s happening?
Closed inventory transactions are re-opened after recalculation, leading to discrepancies in cost amounts for items with zero quantity.
Reason:
There are multiple reasons why this can happen:
- Manual adjustments
- If manual adjustments are posted via the ‘Closing and adjustment’ form, after closing the inventory, then receipt transactions that were affected as part of this adjustment will get re-opened. Also, the issue transactions that were settled against such receipt transactions will also get re-opened.
After recalculation, if these re-opened transactions are fully settled, then these transactions will again get closed. If they're not fully settled, they'll remain open.
- If manual adjustments are posted via the ‘Closing and adjustment’ form, after closing the inventory, then receipt transactions that were affected as part of this adjustment will get re-opened. Also, the issue transactions that were settled against such receipt transactions will also get re-opened.
- Production orders
- Production orders and related transactions can get opened in the case where a raw material purchase is invoiced or the cost changes after closing the inventory. In such a case, the production order costs would need to be recalculated to reflect the change in the raw material costs and hence would get reopened.
- This is by-design and is caused primarily due to some cost change posted after closing the inventory resulting in impacting transactions that would need to be recalculated.
- Identify the inventory transactions that were re-opened as part of recalculation adjustments.
- Identify the items that were affected.
- Check for transactions that were financially posted after the last inventory close.
The ‘Cost Explorer’ tool can help identifying why closed transactions were re-opened and which transactions triggered this re-opening.