Open Forum

Expand all | Collapse all

Inventory Report

  • 1.  Inventory Report

    GOLD CONTRIBUTOR
    Posted Sep 05, 2019 10:48 AM
    I am working in NAV 2017.  Is there an inventory report in NAV that gives the item number, description, and all of the locations/bins for that part?  It would be nice to also know how many of the items are on Assembly Orders.

    If there is not a report standard in NAV, can anybody tell me the tables where the information is located to put together a JET report?

    Thank you,

    ------------------------------
    Traci Albosta
    Comitt Well Solutions LLC
    Katy TX
    ------------------------------
    Conference-BCNAVUG_200x200


  • 2.  RE: Inventory Report

    TOP CONTRIBUTOR
    Posted Sep 05, 2019 11:14 AM
    Rather than use a report, I would recommend using the Bin Contents inquiry.  Make sure you show all columns that indicate quantities on picks, putaways, etc.

    To create a Jet Report, you could try using table 7302 (Bin Contents), otherwise table 7312 (Warehouse Entry) could be used to calculate the on hand by item by bin.  I think that table 901 (Assembly Line) could be used to calculate QTY on Assembly Orders.

    ------------------------------
    Lewis Rosenberg
    IT Manager
    Mars Fishcare
    Chalfont PA
    ------------------------------------------------------------------------
    BCUG/NAVUG All-Star
    BCUG/NAVUG Board of Advisors, Chairperson
    BCUG/NAVUG Programming Committee

    Twitter: @RosenbergL
    LinkedIn: https://www.linkedin.com/in/rosenbergl
    ------------------------------------------------------------------------

    NAVUG/BCUG Summit (navugsummit.com)
    Orlando, FL - October 15-18, 2019

    Come hear me speak:
    GET50 - All About NAV/BC Security
    Friday, October 18, 2019
    9:45 AM - 10:45 AM
    ------------------------------

    Conference-BCNAVUG_200x200


  • 3.  RE: Inventory Report

    Posted Dec 23, 2019 03:41 PM
    Edited by Victor Adebo Dec 23, 2019 03:42 PM
    Hello Traci,

    Start by using the functions shown on  the screenshot,  then look for the NF of the following table headers.

    1. Item No.
    2. Description 
    3. Entry No.
    4. Quantity
    5. invoiced Qty,
    6. Reserved Qty
    7. Cost Actual,
    8. Cost Expected 
    9. Posting date

    NL function
    Take another NL, using Items table to demining the valuation, as shown on the screenshot.
    Looking for items link with Item Ledger Entry

    then apply the NF of the following : 

     

    1. Unit Cost 
    2.  Vendor Number 
    3.  Vendor Name 
    4.  Company Code

    On the spreadsheet calculate Valuation cost

    Valuation cost = Unit Price multiplied by Rem. Qty

    on another sheet create a table lookup such as

    Create a table of reference with the date that is needed to display on your valuations

    Data retrieving sheet
    Continuation for table header

    Once you obtain your data, apply your pivot Table. Thanks

    Victor A


    ------------------------------
    Victor Adebo
    Allan Crawford Associates Ltd
    Mississauga ON
    ------------------------------

    Conference-BCNAVUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role