Reports
- Stock Batches - per product and warehouse, excluding those with quantity = 0
- Stock Usage - various MRP stock fields, plus a calc over 3 ranges of the average
issues to production and/or customers
V2-00 30.08.13 Added Make or Buy calculation, if “A” then BoM is checked to decide.
Added phantom field. Included C/N.
V1-00 01.07.13 Calculate average usage per product from stock history.
Note: In test this report took 10 minutes to fetch 11,000 products from a database
with 2.1million stock history records.
Other options: Make a “snapshot” using SSRS subscription, or take out the SQL and
run the data into a table every night
Wish list:
- Replace DueIn / Backorder stats from stock with a calc from the orders, to give same
results that would be seen in PFS when looking at PO / SO / WO.
- Use Audiiting to show when the product was created, then anything created in say
the last month or having open orders or having usage in the last X days can be classed
as “active”, to enable the exclusion of old products for a more concise report