IM0900 Inventory Management Reordering Advice Reports
Reordering Advice Reports
Application Overview
There are three types of Reordering Advice Reports that can be printed. They are the Reordering Advice Report by Item, the Reordering Advice Report by Location, and the Reordering Advice Report by Vendor. These reports show you which items need to be reordered and aid you in deciding what purchase orders and/or manufacturing orders need to be originated.
Each of these reports may be printed for one or all locations.
Normally the Purchase Order And Receiving package would update the Quantity On Order field as items are ordered and received, but if you do not have this package it will need to be done manually through Inventory Item File Maintenance. When an item is ordered, increase the Quantity on Order field by the quantity ordered. When an item is received, decrease the Quantity on Order field by the quantity received.
If your company does ordering from a central location as opposed to individual ordering from each location, this report will be more useful than the Stock Status Report because the default or manufacturing location always shows the totals for all locations instead of just including its own figures.
Run Instructions
Select Reordering Advice Reports from the pull down I/M Reports window. The following screen will then be displayed:
Print Reordering Advice Report Entry Screen
The following options are available:
- Select the desired mode from the Reordering Advice Reports menu bar
- Enter the data requested on the screen
To return to the menu bar, press the ESC or F10 key. To leave this application, press X for EXIT when positioned at the menu bar.
Entry Field Descriptions
Print Reordering Advice Report By Item
Name | Type and Description |
1. Starting Item No | 15 alphanumeric characters. Enter the starting item number in the range that you want to print. Defaults to All. |
2. Ending Item No | 15 alphanumeric characters. Enter the ending item number in the range that you want to print. Defaults to the starting item number. |
3. Location | 2 alphanumeric characters. Enter the code for the location that you wish to print. The location must exist on the Location File. Defaults to All locations. |
4. Percent Over Reorder Level | 2 numeric digits with an optional minus sign (99‑). Percent over Reorder Level means you can select items with availability not yet to their reorder level, but within whatever percent you enter. If you prefer to specify more precisely how close to the re‑order level each item's availability may be selected, by‑pass the Percent by pressing the RETURN key, and enter the exact Amount Over the Reorder Level that you desire. These amounts may be negative. The report will print items with availability at or below their reorder level, as modified by these fields. |
Amount Over Reorder Level | 3 numeric digits with an optional minus sign (999‑). See Percent Over Reorder Level for description. |
5. Should Quantity Available Include On Order ? | Y or N. For the purposes of reordering, Quantity Available is usually considered to be: Qty Available = On‑hand + On‑order ‑ Allocated |
Should Quantity Available Include On Order ? (continued) | However, you may use this option to omit the On‑order quantity from this calculation so that you are only considering what is available right now. Defaults to N. |
6. Purchase Or Mfg Code | 1 alphanumeric character. P = only purchased items will appear on the report, M = only manufactured items will appear on the report, B = all items will be considered for the report. Defaults to P. |
7. Print Items With Reorder Level Only ? | Y or N. Enter Y to only print items with reorder levels defined. Defaults to N. |
8. Print Alternate Vendors ? | Y or N. If Purchase Order And Receiving is being used, the user has the option of including alternate vendors for each item on the report. If Purchase Order And Receiving is not installed, this field will not appear. |
9. Show Zero Qty Recommended | Y or N. Entry required. If using a percent/amount over/under reorder level and the calculated quantity recommended would be zero, this item will appear on the report if set to Y. Enter N if these items should not appear on the report. Defaults to Y. |
Print Reordering Advice Report By Location
All fields same as above except:
Name | Type and Description |
8. Print in Priority Order ? | Y or N. Defaults to N. For each location, items are usually printed in order by item number. However, if you answer Y to this question, items will be printed according to what percent the quantity available differs from the reorder level, with those that differ the most printing first. |
Print Reordering Advice Report By Vendor
All fields are the same as Reordering Advice by Item, except for one additional field:
Name | Type and Description |
3. Vendor No | 6 alphanumeric characters. Defaults to All vendors, if left blank. The report will be printed for the vendor selected, by item number within that vendor; or if all vendors are selected a section for each vendor will be printed. |
Reordering Advice Report By Item
Reordering Advice Report By Location
Reordering Advice Report By Vendor
