With the release of Dynamics GP 2018 R2, several new features were introduced to the core functionality in the system. In this post, we will shed a light on an interesting feature provided for the inventory module in regards to the Historical Inventory Trial Balance.
In previous posts, it has been thoroughly discussed that HITB usually encounters issues represented with zero quantity and negative/positive
cost. The source of the problem is represented with mismatching issues between inventory cost layers ( IV10200, IV10201) from one side and (SEE30303) from the other side.
Here is a brief on the issue:
Inventory Cost Layers versus HITB (SEE30303)
I have seen such case with multiple clients, resolving this case requires internal matching or rebuilding of the HITB inventory source in order to recalculate quantity and value records and ensure that historical and current inventory balances are matching.
In the same context, the recent release of Dynamics GP 2018 R2 has introduced an interesting feature for the HITB report represented with the ability to either include or exclude either items with “Zero Quantity” or “Zero Value”, this will ensure that HITB report is being filtered properly for all the zero quantity or value records.
In order to print the Historical Inventory Trial Balance report, follow the path below:
Reports > Inventory > Activity > Historical IV Trial Balance
Mahmoud M. AlSaadi