Open Forum

Expand all | Collapse all

Inventory Report

  • 1.  Inventory Report

    GOLD CONTRIBUTOR
    Posted 11 days ago
    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
    ------------------------------


  • 2.  RE: Inventory Report

    TOP CONTRIBUTOR
    Posted 11 days ago
    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
    ------------------------------



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