Stock Reorder
Stock Reorder
(StkReord.exe) The Stock Reorder program will generate Purchase Orders using the Min, Max, ROP and ROQ settings in the Inventory Master File on the Unit of Issue tab, to determine replenishment quantities for Stock or Direct Location Type items. May also select to include Consignment Items. Remember All Quantities are set up according to the conversion factor.
Minimum Stock: The Lowest Amount of Stock you want to have on hand for this item
Maximum Stock: The Maximum Amount of Stock you want to have on hand for this item
Reorder Point: The quantity (On Hand) at which point this item should be ordered. When the On Hand PLUS the On Order Quantity is at or below this quantity the Stock Reorder program will include it and reorder enough to bring it up to the Maximum Stock value. This field must be set to a minimum of one (1) to be included in the Stock Reorder program.
Reorder Quantity: The quantity to be ordered when you reach the Reorder Point. The system defaults to use the ROP and will order enough to bring the On Hand up to the Max Stock quantity; however for some items you may override that and use the ROQ instead. It would now work as follows. When the On Hand PLUS the On Order Quantity is at or below the ROP the system will order the ROQ amount. To activate the override, check the box on the Location tab marked "Reorder Override" for these types of items.
There is a System Option, Use Reorder Quantity in the Inventory module, which will allow the user to let the system determine the reorder Quantity based on the Maximum Stock value minus (On Hand plus On Order) by selecting N.
The user may want to clear the reorder file when you start by pressing F2 or clicking on Tools under the menu bar and selecting Clear Reorder File. You will see a warning that you will clear any incomplete or previous records and start a new Stock Reorder based on the current information.
(1) Select the Location, or Multiple Locations if accessing, by clicking on the drop down arrow. If you wish to set a default Deliver To for a specific Location, do so in the Location Description Master File which will set when the Purchase Orders are created. If using the System Option, StkReord Use Release to PO, under the Purchasing module is set to Y, the Location in the drop down displays locked locations in red. This is to prevent a purchase order from being created before the person who is calculating has completed. When the System Option is set to Y (Yes), an option will display in the Tools menu, Lock/Unlock Location for PO creation or F6. A screen will display, Locked/Unlocked Locations and the user may then lock or unlock a location by double clicking on the line to change it from True to False or vice versa in the Locked column to prevent PO Creation. When completed with the change click the OK button and continue.
(2) Select All Vendors, Multiple Vendors or Single Vendor. If using the Multiple selection, press the icon next to the word Multiple and a Choose Vendor screen displays. Vendors may be entered or selected using the lookup and then press the Add button which will add to the list below. There is also the ability to Add All, Delete or Clear List.
There is an Exclude check box, which will allow the user to exclude based on the All, Multiple or Single Vendor button that is chosen.
(3) May select the Ship To from a drop down box or it will choose the default.
(3) Select all order days or single order days, as set in the Vendor Master File.
(4) May select a bin range by checking the Use Bin Range box, and entering a Starting Bin and an Ending Bin range.
You may include the Stockout Quantity, Items with a Reorder of Zero, or Consignment items by checking the appropriate box. Also, you may set a Percentage over Reorder Point to add items using that calculation.
There is a Buyer Memo, that may be created for a specified Material Code, which will display on the Purchase Order detail tab against that line and display as highlighted in red.
There is a Vendor Memo, which will display on the printed Purchase Order.
May mark the specified Material Code for Overnight or 2nd Day delivery by checking the associated box.
After this you can Calculate Reorder Quantities by pressing F3 or by clicking on it under the Tools menu. A progress bar displays until complete and the recommended items will appear below. A printed report can be accessed in Inventory Control/Reports/ Stock Reorder Report.
You can edit an item by clicking on the line, then clicking in the Quantity field above and entering the new amount then clicking Enter, and the Quantity will change below. If you do not wish to order an item, change the Quantity to 0.
If you wish to add an item that was not recommended, click on the Tools, Add Items or F4. An Add Item box appears, enter the Location using the drop down if there is more than one, Material Code or use the lookup, select the Vendor using the drop down, select the Unit of Purchase if more than one, enter the Quantity, press enter and continue until finished. Click Close and all items will be added to the list.
Once you have calculated the reorder quantities you can then create purchase orders by pressing F5 or clicking Create Purchase Orders under the Tools menu. The Building Purchase Orders screen appears and a progress bar runs until complete. You may choose to set the System Option, Stock Reorder Popup EDI, Fax, Print, in the Inventory module, which will determine how the Purchase Orders will be released in the system. If a user is set up to be able to choose how they want each PO to be released, they will now be able to release with more than one option, that is, they will now be able to Release to Never EDI, Fax or Print, Release to EDI, Release to Fax, Release to Email or Release to Print. After releasing, a log file is available to view or print. When choosing to Release to Never EDI, Fax or Print and the Min Order amount is not met as set in the Vendor Master File it will display in the Status field of the log file.
There are two other ways in which the Stock Reorder program can work.
(1) Use the Stockout Quantity. When using this option whenever the on hand plus the on order quantity is at or below the Reorder Point, the stock reorder program will order the Reorder Quantity.
(2) Use the Include Items with a Reorder of Zero, to bring up items which have a reorder point of zero.
Maximum Stock minus (On Hand plus On Order) plus Stockout quantity equals Reorder Quantity.
The user may include Stockout quantities when calculating reorder quantities. The Include Stockout Quantity check box must be checked to include the Stockout Quantity field amount to the recommended reorder quantity.
There is a System Option, Use Two Step Stock Reorder in the Inventory module, which when set to Y (Yes), will have the Stock Location run the Stock Reorder process but Purchasing or a Buyer, will create the Purchase Orders. Another System Option, Stock Reorder Can Choose PO Type, under the Inventory module, will allow the user to change the PO Type in the Create Purchase Order function under Tools. When the Building Purchase Order screen appears use the drop down to change the PO Type and then click OK. This will affect all Purchase Orders being created. A different System Option, Stock Reorder Create Reqs, under the Inventory module will allow the user the ability to create requisitions instead of purchase orders. If this is set, the Tools menu will display Create Requisitions or F5 instead of Create Purchase Orders. When accessing this process a Building Requisitions screen and a progress bar will appear until complete and then a Confirm screen displays asking if you wish to view the log file. Answer Yes or No. There is a System Option, Limit Ship To to Entity StkReord, under the Purchasing module which set to Y (Yes) will alert the user if attempting to select a Ship To in the drop down that does not exist for that Locations Entity when Creating the Purchase Orders with an Error message. Press OK and the system will return the user to the Ship To box until a correct Ship To is selected.
There is a System Option, Round Down Stock Reorder, under the Inventory module which will determine if the system will round down calculations in determining the quantity to reorder. There is a System Option, Stock Reorder Show Reorder Loc Warning, under the Systems module, that determines if a popup warning will occur when using the Add Items function under Tools to add an item with a Reorder location listed in the Inventory Master File on the Location tab.