Featured Post

Dynamics GP 2019 is now Released

It is now released, Microsoft Dynamics GP 2019 which moves the system to the modern product life cycle   " Beginning with the October...

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

3 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
  2. BE SMART AND BECOME RICH IN LESS THAN 3DAYS....It all depends on how fast 
    you can be to get the new PROGRAMMED blank ATM card that is capable of
    hacking into any ATM machine,anywhere in the world. I got to know about 
    this BLANK ATM CARD when I was searching for job online about a month 
    ago..It has really changed my life for good and now I can say I'm rich and 
    I can never be poor again. The least money I get in a day with it is about 
    $50,000.(fifty thousand USD) Every now and then I keeping pumping money 
    into my account. Though is illegal,there is no risk of being caught 
    ,because it has been programmed in such a way that it is not traceable,it 
    also has a technique that makes it impossible for the CCTVs to detect 
    you..For details on how to get yours today, email the hackers on : (
    atmmachinehackers1@gmail.com ). Tell your 
    loved once too, and start to live large. That's the simple testimony of how 
    my life changed for good...Love you all ...the email address again is ;
    atmmachinehackers1@gmail.com

    ReplyDelete