Featured Post

Dynamics GP 2018 - Upcoming Features

We are counting the days for Dynamics GP 2018 release which is promising to introduce a new set of features that have been highly recogniz...

Sunday, June 5, 2016

Dynamics GP 2016 - Inventory All in One View

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.

Best Regards,
Mahmoud M. AlSaadi

2 comments:

  1. Thanks for your post! I was just showing a client the new features in GP2016 after the completion of their upgrade from GP2010. They were excited about this view and then bam...nothing...because they've never run the HITB reset tool. Microsoft needs to understand that companies which have been using inventory for years don't want general ledger adjustments made to their inventory, which they've already accounted for. I wish Microsoft had used the true inventory tables for this.

    ReplyDelete
    Replies
    1. Hello Trish
      Historical Inventory Table (HITB) is a must in my humble opinion, it is not an option that a client might wish to pick or not. Without having HITB, reconciling inventory to GL would be a nightmare. In fact, the main purpose of creating this table was to provide a proper and precise inventory to GL reconciliation.

      Please never hesitate to share any further inquiries or concerns,
      Best Regards,

      Delete