Skip to content

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 de­ciding 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 re­ceived.

 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 avail­ability not yet to their reorder level, but within whatever per­cent 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

     


    ScreensREPORTS

     

    Reordering Advice Report By Vendor

     

     

     

     

                               

    Feedback and Knowledge Base