Open Forum

Expand all | Collapse all

Inventory Balance?

  • 1.  Inventory Balance?

    Posted Sep 30, 2019 12:36 PM
    Good Morning Everyone, I'm trying to get a handle on a specific set of items in our inventory. I haven't been able to find a report that will allow me to run it by a specific date range, and will then allow me to see:

    Item Number
    Item Description
    Beginning Inventory
    Quantity In
    Quantity Out
    Ending Inventory

    Anyone have any suggestions? I've tried playing around with creating a smartlist, and it doesn't quite get me all of the information that I need.


    Dan Levett
    Accounting Manager
    White House Custom Colour
    Eagan MN

  • 2.  RE: Inventory Balance?

    Posted Sep 30, 2019 02:15 PM
    Following! I just did some playing with this and found it difficult to get the answer. This would be very valuable for many of us! The inventory all-in-one view does gather most of this, but not in a way to summarize and get the beginning/ending values.

    Aleiha Hanson
    Royal Basket Trucks, Inc - IT Manager
    GPUG Milwaukee WI Chapter Leader


  • 3.  RE: Inventory Balance?

    Posted Sep 30, 2019 02:21 PM
    Mahmoud M. AlSaadi has this post, that I was able to modify to what we were looking for. Give it a look.

    Chase Landorf
    Director of I.T.
    Ideal Deals, LLC dba Ideal Aluminum Products
    Saint Augustine FL


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