Open Forum

Expand all | Collapse all

Analyzing Inventory In Groups

  • 1.  Analyzing Inventory In Groups

    Posted 7 days ago
    We are looking at possible ways to group our inventory in NAV so that we can track inventory levels within these subgroups. For example, high margin items, high turn items, contract items, things like that. In doing so, we noticed some descriptors on items within the vendor ordering screens. These two descriptors are 'item class description' and 'ranking code.' They seem to self assign a value of a,b,c,x or y. I cannot, for the life of me, find out what these two descriptors mean. Does anyone here have any idea what they mean, or have any interesting ideas on how to tag inventory in a way we can group it together on a report?

    Thanks!

    ------------------------------
    kevin keel
    American Ring
    Solon OH
    ------------------------------


  • 2.  RE: Analyzing Inventory In Groups

    Posted 6 days ago
    Edited by Matt McDowell 6 days ago
    Sounds like what you want are dimensions

    https://docs.microsoft.com/en-ca/dynamics-nav-app/finance-dimensions

    ------------------------------
    Matt McDowell
    Supply Chain Analyst
    Valley Blades Limited
    Waterloo ON
    ------------------------------



  • 3.  RE: Analyzing Inventory In Groups

    Posted 6 days ago
    You could use the Item Card's Phys Invt Counting Period Code. This list of codes is completely defined by you, and you can then filter on this field for reports. Another benefit of this field is that it can also guide the warehouse to routinely cycle count the grouped items. For example,  you can code High Value Items to be counted more frequently than Low Value Items.

    ------------------------------
    Pratik Patel
    Symbex Companies
    ------------------------------



  • 4.  RE: Analyzing Inventory In Groups

    TOP CONTRIBUTOR
    Posted 5 days ago
    Hi Kevin,


    I don't know what version of NAV you have but it seems like "item class description" and "ranking code" are part of an add-on.
    You can use an available field in the item card ("Shelf No." for example) to tag and group your items in a report. A more elegant and safe approach would be to add a new field to the Item table.

    Cheers,



    ------------------------------
    Eduardo Diaz
    IT Director
    Minequip Corp.
    Palmetto Bay FL
    ------------------------------



  • 5.  RE: Analyzing Inventory In Groups

    TOP CONTRIBUTOR
    Posted 3 days ago
    We have been able to breakdown item into subcatergories by simply adding a user defined field or table to the item card and setting up a validation login. join them to your valuation field and add the sort to any report you want to modify.

    Relatively easy mod for an administrator or VAR.

    Says he who has  good tech support in house.



    ------------------------------
    Michael Carr
    VP , Finance
    Philadelphia Scientific LLC
    Montgomeryville PA
    ------------------------------



  • 6.  RE: Analyzing Inventory In Groups

    TOP CONTRIBUTOR
    Posted 3 days ago


    Relatively easy mod for an administrator or VAR.

    Says he who has good tech support in house.
    Michael Carr,  09-17-2018 08:59 AM
    Ha ha @Michael Carr, yup that's the key. . :)

    ------------------------------
    Meenakshi Singh
    Manager of Business Applications
    Home Market Foods, Inc.
    Norwood MA
    ------------------------------



  • 7.  RE: Analyzing Inventory In Groups

    SILVER CONTRIBUTOR
    Posted 2 days ago
    Edited by Eric Moe 2 days ago
    These fields are part of Lanham's AFP module, which I assume is what you are using for your ordering screens.  Searching "Item Class" and "Item Rank" in NAV should bring these tables up which will explain how the rankings are assigned.

    The ranks are assigned to every Procurement Unit, and you can report on them that way.  The ranks update at the end of every month, and you can look at past records for each Procurement Unit in the Item Usage page.  In general, we evaluate items & inventory based on other metrics, but the Classes/Ranks provide a very quick way to judge if something is valuable or not.

    Item Classes rank items by the value of COGS.


    Item Ranks ranks items by the frequency of hits (sales lines).

    As for how to group items - Item Category Codes, Dimensions, Item Numbers all work.  You can assign multiple dimensions to an item to tag it into different groups.


    ------------------------------
    Eric Moe
    Global Supply Chain Manager
    Industrial Revolution
    Tukwila WA
    ------------------------------