Reorder Level Report
Created by: arun kelkar
When a product is created, there will be one more field, this will be Reorder Level. Depending upon the UOM, this will be in integers or in decimals. It can be zero but can not be less than zero. The user will input this figure. When an item of inventory reaches its Reorder Level, the software should trigger a message that a particular order needs to be ordered.
Apart from this there will be a Report of Reorder Status. For this, the user will be asked to enter any date from within the Financial Year. Then user will be asked to enter or select a particular item of inventory. The user will be given an option if he wants to view this report for all items of inventory. Thus the user will select one or all. When this is done a report in a table form containing the following columns will be displayed. At the top either the name of the item, if the user has chosen one, or “All Items” will be shown, to be followed by the words “as at” to be followed by the dd/mm/yyyy selected by the user. The headings of the columns will be:
- Sr. No.
- Product Name
- Category.
- Balance on hand (this will be the Balance on the dd/mm/yyyy selected by the user).
- Purchase Orders Pending
- Sales Orders recd
- Net Stock on Hand (this will the product of 3+4-5 above).
- Reorder Level (this is inputted by the user when he created the product).
- Short Fall ( this will be displayed only if 6 is less than 7 above). All figures will be quantities only. There will be no total row at the bottom.