Inventory Forecast Report
Select inventory on the category drop down
Search for Inventory Forecast Report on the list the double click on it to be able to edit it
The report is extensive and checks all sales by item and a forecast is made of the stock required based on the past period specified
Inventory Module> Reports> Reports List
Select from the following fields to run the report:
| Year From / To | Select the year From and Year To Dates from the drop-down menus will show results specific to the period you have selected. |
| Period From / To | Select the period From and the period to from the drop-down menu |
| Sort By | Sort the report by selecting one an option from the drop-down menu |
| Weekly Buffer | |
| Stock From / To |
Select a stock item you wish to search from. If you leave the stock item fields blank, all stock items will be displayed on the report. If you choose specific stock items, the report will sort information by stock item code rather than description. Select the start stock code and the end stock code for the report. |
| Warehouse | If you select all warehouses the report will fetch data from all warehouses. If you want to search by a specific warehouse, select the warehouse from the menu. |
| Show Columns | Tick which columns you would like to show on the report Job / Bom / SO WIP |
| Priority Level | Click on the drop down to and select by priority you wish to see |
| Active Tick | Allows the user to run either active or inactive inventory forecast |
| Decimal Places | It is advisable to set decimals to two places. You can View the report with any number of decimal places. |
| Include Preparation | Tick S.O or P.O |
| Use Group Codes | Double click on the code from the list to move the group codes you wish to filter your report by to the selected window. |

No Comments