Dynamics GP 2018 R2 – HITB Include and Exclude Zero Quantity or Value

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)

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
HITB Report Modification
Best Regards
Mahmoud M. AlSaadi

Warehouse Management Solutions (WMS) through Microsoft Dynamics GP

It is said that “no two warehouses are alike” which very well attributes to the nature, type and the sector of the business the warehouse is dealing with.

(more…)

Dynamics GP – Inventory Aging Report

We have always received requests from clients about historical inventory aging report, unfortunately, this report is not available in the system as a standard report, and thus requires customizations.

(more…)