Open Forum

Expand all | Collapse all

Inventory Balance?

  • 1.  Inventory Balance?

    SILVER CONTRIBUTOR
    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.

    Thanks!

    ------------------------------
    Dan Levett
    Accounting Manager
    White House Custom Colour
    Eagan MN
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: Inventory Balance?

    GPUG ALL STAR
    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
    ahanson@royal-basket.com
    ------------------------------

    Conference-GPUG_200x200


  • 3.  RE: Inventory Balance?

    TOP CONTRIBUTOR
    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. https://mahmoudsaadi.blogspot.com/2015/08/item-stock-movement-report.html

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

    Conference-GPUG_200x200


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