Use this screen to enter reorder details for a sales item that is inventoried, and for which you want the system to suggest reorder dates and quantities.
Click a link to advance to that section of the topic.
Access this screen by pressing F7=Reorder on the Sales Item Maintenance screen. On this screen, enter reorder details for the sales item such as order method, safety stock in days, and the ordering unit of measure. Press Enter to return to the main Sales Item Maintenance screen.
Sales Item Maintenance - Launch
Reorder Information
Displays the item number for which you are maintaining reorder information.
Displays a brief description of the item.
Displays the manufacturer's item number assigned to this sales item.
Displays the code that represents the smallest unit of measure in which this item is sold, purchased, or stocked.
Displays the code that represents the second unit of measure in which this item is sold, purchased, or stocked.
Displays the quantity of items in the first unit of measure that is equivalent to one unit in this second unit of measure.
Displays the code that represents the third unit of measure in which this item is sold, purchased, or stocked.
Displays the quantity of items in the first unit of measure that is equivalent to one unit in this third unit of measure.
Enter the number that the vendor has assigned to the sales item. This item number can print on purchase orders.
Displays the manufacturer's suggested list price for the item. This amount is not used for invoicing; it may be used for calculation of cost or selling price based on the codes assigned for auto calculations.
Displays the full received cost of the item, which includes the item's purchase price plus any freight, handling, insurance, and customs charges applied by the vendor and shipper.
Enter or accept the last or most current cost of this sales item. This field is automatically updated when the item is received against a purchase order in the system.
Displays the average cost of the item, which is calculated by the multiplying the total cost of all receipts by the number of items received.
Enter or accept the number of the vendor from whom you usually purchase this item. This is the vendor used on reorder and analysis reports for this item.
If applicable, enter the number of the first alternate vendor for this item.
If applicable, enter the number of the second alternate vendor for this item.
Enter up to six codes by which you can classify this item for analysis purposes. You can run reports by analysis code.
You have
a sales item for fuel. You use fuel a variety of ways, and you would
like to be able to analyze and report on those different ways. Use
analysis codes to identify up to six of the ways you use fuel.
Enter the code that represents the method you want the system to use when suggesting reorder dates and quantities for this item. The code is automatically populated from the setting in control record SAITM5, but you can change it. Valid codes are:
O - Order point. With this method, you enter the quantity (on hand) to which the item must fall before you reorder it, and you enter the quantity to reorder.
U - Usage. With this method, you enter the number of days of supply (based on the average daily usage) to which the item must fall before you reorder it, and you enter the quantity to reorder.
E - EOQ (Economic Order Quantity). The system calculates this using the following formula: square root of (((2 * cost of processing a PO) * (the usage in a month)) / (item unit cost * system percent))
N - Don't order item
If you enter O or U, enter information in the Order Point/Quantity fields.
If you entered an Order method of O, use the first field to enter the quantity (on hand) to which the item must fall before you reorder it, and enter the quantity to reorder in the second field.
If you entered an Order method of U, use the first field to enter the number of days of supply (based on the average daily usage) to which the item must fall before you reorder it, and enter the quantity to reorder in the second field.
Displays the system-calculated economic order quantity for this item.
Back to top
If you entered an Order Method of E for EOQ, enter the period of time in days that the system uses to determine the suggested order quantity.
If you entered an Order method of U, enter the number of days of stock to always have on hand for this item. This is the number of days of stock that you never want to fall below. It provides a safety level of inventory in case your purchase order does not arrive on time.
Displays the quantity to order based on the reorder period days and safety stock days.
Number of months to calculate usage
Enter the number of months that the system should use to calculate the average monthly usage for this item.
Indicate if this item is considered seasonal.
Displays the average usage of this item in a month.
Enter the code that represents the unit of measure in which you typically order this item.
If you are not using an order method, enter the quantity that you typically order of this item using the ordering unit of measure.
Enter the manufacturer's standard pack quantity. When you enter a purchase order for this item, you must enter an order quantity that is a multiple of this quantity.
Enter the weight of the manufacturer's pack quantity in pounds.
Enter the warehouse location that is responsible for supplying this item. If control record SAITMM - Warehouse Pricing is set to Y, and a transaction occurs that affects the price or cost of this item, the system updates the price or cost of this item for all locations supplied by this warehouse.
Enter the code for the vendor's price schedule that includes purchase pricing information for this item. This field is used for reference information only.
For more information, see Price Definition Maintenance and Update Items from Vendor Price List.
If applicable, enter the discount that the vendor normally gives when you purchase this item.
Enter the weight of one unit of the item. This information is used to track the weight of items ordered from the vendor.
If applicable, enter the European Union product code for this item.
Function Key |
Description |
F1 |
Help. Place your cursor in a field and press F1 to access online help for that field. Place your cursor outside of any field, and press F1 to access online help at the program level. |
F4 |
Search. Place your cursor in a searchable field and press F4 to access a lookup window or more advanced search screen. |
F12 |
Cancel/Previous. Exit the program or move back a screen. |
Reorder Report by Warehouse
Reorder Report by Vendor
Back to top