Need Expert Help - Inventory

Anonymous 

Bear with me since I am a little lost at the moment with the process you have described:

1) She runs the report once a day. When she does so, a new calculation date is created (defined as "Last Gen date"), correct?

Now is when I am not quite understanding the context...

You mention: Whatever the qty on hand was at the time of the report is what the starting point for the inventory is.

And then say: "The on hand qty from the Items table does not take into account any outstanding requirements.  So if the Items report was generated on Feb 2 with on hand 206,656, but there was still an outstanding requirement from Jan, your actual beginning inventory for Feb should the 203,080 you stated below."

What values does the report generated each day contain? Does it have data from the dates previous to the report creation (given that she runs the report each day)? if so which? (If the "quantity on hand" must take account any outstanding requirements (from Jan in the above example) and the quantity on hand from the Items table does not take into account any outstanding requirements, you need data from the previous month -specifically the cumulative outstanding requirements-, right?) Is this [cumulative outstanding requirements] included in the daily report and if so, which field is it?

2) Does the report include a value for "Quantity on hand" for upcoming months?

Depending on how this value is generated, & what values the report contains, we need to use either the value itself or cumualtive.  So, if the report only contains values for the current month, we would use the cumulative value; if the report has "Quantity on Hand" values for future months (to cater for product ordered and delivered in the future months), we would use the SUM of the values.

3) does she need the closing balance for each month? (as I see it, there are two "closing balances":

   a. The closing balance of physical stock:  [stock - fulfilled demand] (ie physical stock remaining once products have left wharehouse)

   b. The closing stock taking into acount demand which has not been fulfilled:  [stock - fulfilled demand - non-fulfilled demand] (so, physical stock - products ordered but haven't actually left the wharehouse.) This value is what I understand  should be used in the actual calculations for the starting point or opening balance for the following month.

4) Assuming that what we use for the calculations for the starting point or opening balance for the current month is point 2.b. above, do you need the new demand for the current month to be part of the calculation)? ie: [2.b. - current demand]

or do you need to show the calculation [2.b.]