1 Reply Latest reply on Jul 11, 2018 4:11 AM by ALOK KUMAR SACHAN

    Starting and Closing Inventory

    brady.holzhauer

      Hi everyone. I am building a report to keep track of inventory by a parameter I've created.

       

      In this report, I will be showing current on hand quantity, checked in quantity, days on hand, sales $, units sold, and more.

       

      I will have it always displaying the previous month, so you can get a full month's snapshot (other than current on hand quantity).

       

      My challenge is this.

       

      I have a field for "date" and I have a field for "on hand qty". I need to create a column that shows "starting inventory" and one for "closing inventory" based on the date filter selected (which is always showing previous month).

       

      I.E., something that would look and say: grab the on hand qty from the minimum date/maximum date (in the filtered date range).

       

      I've googled this a lot, and I'm still having trouble doing this. Any help would be great. Thanks!