Sales
Item Location Maintenance - Reorder Information Sales
Item Location Maintenance - Reorder InformationUse this screen to enter reorder details for a sales item at a specific location.
Click a link to advance to that section of the topic.
Access this screen by pressing F7 on the Sales Item Location Maintenance screen. Enter reorder details for the sales item such as order method, safety stock in days, and vendor IDs. Press Enter to return to the main Sales Item Location Maintenance screen.
Sales Item Location Maintenance - Launch
Sales Item Location Maintenance
Reorder Information
Sales Item Location Quantities
Displays the item number for which you want to add reorder information.
Displays a brief description of the item.
Displays the code for the location for which you want to enter reorder information.
Displays the code that represents the smallest unit of measure in which this item is sold, purchased, or stocked at this location.
Displays the code that represents the second unit of measure in which this item is sold, purchased, or stocked at this location. It also displays the quantity of items in the first unit of measure that is equivalent to one unit in this second unit of measure.
Example: The
first unit of measure is EA
for each. The second unit of measure is BX
for box. There are 10
of this item (in eaches) in one box, so enter 10
in the Quantity field.
When this item is sold, purchased, or counted during inventory,
you can enter a unit of measure of BX, and the actual boxes sold, purchased,
or counted, and the system calculates the amount in eaches based on this
quantity.
Displays the code that represents the third unit of measure in which this item is sold, purchased, or stocked at this location. It also displays the quantity of items in the first unit of measure that is equivalent to one unit in this third unit of measure.
Example: The first unit of
measure is EA for each. The
third unit of measure is CS for
case. There are 100 of this
item (in eaches) in one case, so enter 100
in the Quantity field. When
this item is sold, purchased, or counted during inventory, you can enter
a unit of measure of CS, and the actual cases sold, purchased, or counted,
and the system calculates the amount in eaches based on this quantity.
Displays the manufacturer's suggested list price for the item at this location. 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 for this location. This field is automatically updated when the item is received against a purchase order in the system. You can also view the code for the currency in which this amount is entered.
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 for this location. This is the vendor used on reorder and analysis reports for this item.
Enter or accept the number of an alternate vendor you might use to purchase this item if the usual vendor cannot supply it.
Enter or accept the number of a second alternate vendor you might use to purchase this item if the other two vendors cannot supply it.
Back to top
Enter the code that represents the method you want the system to use when suggesting reorder dates and quantities for this item at this location. The code is automatically populated from the setting in control record SALOCM, 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 or Blank - Don't order item
* - Use value from the item's master record
If you enter O or U, enter information in the Order Point/Quantity fields.
At reorder point
The system indicates if this item at this location is currently at the reorder point. The field is updated when you run the Reorder Report.
Displays the quantity to purchase that was calculated by the Reorder Report.
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 date of the last purchase order for this item at this location.
If the order method is E, this field displays the system-calculated economic order quantity for this item at this location based on the formula detailed in the Order method field description.
Enter the number of days from the time a reorder is placed with the vendor until the time it is received.
If you entered an Order method of U, enter the number of days of stock to always have on hand for this item at this location. This is the quantity 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 amount to order based on the item's average daily usage, vendor lead time (Reorder period in days), and safety stock in days.
Back to top
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 at this location.
Indicate if this item is considered seasonal.
Displays the average amount this item is used in a month at this location.
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.
If you are not using any of the order methods for this item, enter its standard order quantity for this location.
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.
If applicable, enter the discount that the vendor normally gives when you purchase this item for this location.
Displays the calculated weight of one unit of the item. This is based on the figures in the Manufacturer's pack quantity and the Item weight in pounds fields.
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. |
|
F3 |
Exit. Exit the page or program. |
|
F4 |
Search. Place your cursor in a searchable field and press F4 to access a lookup window or more advanced search screen. |
|
F9 |
Item Number Toggle. Toggle the Item number field to Manufacturer's number or UPC code. |
|
F12 |
Cancel/Previous. Exit the program or move back a screen. |
Sales Item Maintenance - Reorder Information
Back to top