With the release of Dynamics GP 2016, multiple features were introduced making this release an outstanding one. In this post, I am shedding a light on the new reporting method represented with the "All in One view".
Inventory-related transactions can be categorized as either Quantity In Such as Adjustment In, Receiving ...etc or Quantity Out such as Adjustment Out, Sales Transaction ..etc. Or Quantity Moved represented with the Transfer type through which quantities are moved from one site to another.
|Inventory - Item Site All in One View|
In a previous post; Cost Layers Analysis, I have provided a script which provide a view for how each cost layers has been consumed. A purchase receipt; represented with any (In) transaction will either be moved among sites or withdrawn out by an adjustment out, sales transaction ...etc. Dynamics GP 2016 provides the same results in a "visualized" way. The purpose of this view is the following:
- To provide an analysis for cost layers. How every purchase receipt has been consumed per each or all sites.
- To provide an inter-related view of the inventory transaction. By clicking on a specific document, the other sections will be updated accordingly.
- To provide brief details of every single item transaction such as: originating module, document number, quantity, cost ...etc
|Inventory All in One View|
|Related Cost Layers|
As shown above, when checking a specific purchase receipt from the "Quantity In" section, the system will automatically filters the other sections to leave only related cost layers, the "related cost layers" means that the quantities out/ moved have been withdrawn from the selected quantity in.
Below is a look at the SQL tables; primarily IV10200 and IV10201 showing the link between a specific purchase receipt (in IV10200) and the related Out Transaction (in IV10201)
|Inventory Tables - IV10200 and IV10201|
Important Note !
Unlike the Item Stock inquiry which retrieves data primarily from IV30300 and IV10200, The inventory All in one view retrieves data primarily from SEE30303, which is the historical inventory trial balance HITB.Therefore, if you've got any internal inventory issues represented with inconsistent quantities and values, these two inquiries may not provide the same results.
Mahmoud M. AlSaadi
Mahmoud M. AlSaadi