This **Stock Required Report is** provided as a .csv file

To access the report, go to the Purchasing & Suppliers menu and select Purchase Orders .

You can then select the blue button at the top right marked Suggested Purchases Report .

This will pop up a window that will take one input – period to consider (days) the number that you put in there must be a positive integer.

The report will consider every “Available” product (based on the product record field “Item Status”) in your product database AND every warehouse

## How the Stock Required Report is generated #

If an account has 100 products and 4 warehouses the report will have 400 rows

For each possible combination of Warehouse and Available Product the system will add a row to the CSV

Each row will include the following columns.

Total Sales in last < period to consider (days)> is calculated by adding up the number of items of this type on all SHIPPED status orders in the warehouse in question over the last < period to consider (days)>.

Quantity to Purchase for this warehouse is calculated as follows

Take the minimum stock level for this item and add the number sold in the period then take away the number in stock in the current warehouse. If the result is negative show zero instead.

For example if a product has 4 items in the warehouse and has sold 20 in the period and a 5 unit minimum stock level, then the Quantity to Purchase for this warehouse will be 5 + 20 – 4 = 21

Quantity to Purchase for this warehouse (7 Days) is calculated as follows

Take the minimum stock level for this item and add the number sold in the period then take away the number in stock in the current warehouse. If the result is negative show zero instead. Then multiply the result by (7/Period)

For example if a product has 4 items in the warehouse and has sold 20 in the period which is 14 days and a 5 unit minimum stock level, then the Quantity to Purchase for this warehouse will be 5 + 20 – 4 = 21 this will then be multiplied by (7/14 = 0.5) result is 10.5 – – Round the answer UP to the nearest Integer if the answer is not an integer so show 11

Quantity to Purchase for this warehouse (28 Days) is calculated as follows

Take the minimum stock level for this item and add the number sold in the period then take away the number in stock in the current warehouse. If the result is negative show zero instead. Then multiply the result by (28/Period)

For example if a product has 4 items in the warehouse and has sold 20 in the period which is 14 days and a 5 unit minimum stock level, then the Quantity to Purchase for this warehouse will be 5 + 20 – 4 = 21 this will then be multiplied by (28/14 = 2) result is 42 – Round the answer UP to the nearest Integer if the answer is not an integer

## Some things to consider when you use this report #

The report is intended to show you what you need to order to ensure that you have enough stock to cover your sales based on the ASSUMPTION that your future sales will be the same as your past sales.

Obviously, this assumption is always wrong – but it can be used as a good guide to what you need as long as you apply a little common sense to the results.