Inventory |
The Inventory tab enables you to define how to manage the parts inventory at the location. You must specify a location ID in the filter.
Note: Refer to the Stock Status Upgrade screen for more information about these work-flows including additional details about search criteria.
The field in the top section of this tab defines the data that displays.
Location ID
Identifier of the location currently selected in the grid or that you are defining. This field has a list box. The location name displays to the right of the ID.
Data in the fields in the bottom section of this tab define how the parts inventory is managed. Unless otherwise indicated, these fields are required.
Address ID for deliveries
Identifier of the location’s normal address for deliveries. This field has a list box. The first two lines of the address information display to the right of the ID. Required if the Functions tab specifies that this is a parts inventory location.
If the Manage parts ordering and economic order quantity (EOQ) values field on the General tab of the Data -> Parts Items -> Setup -> Options screen specifies BY LOCATION, this address ID is used on purchase orders generated from the Generate tab of the Data -> Purchasing -> Reordering screen.
Address ID for invoices
Identifier of the location’s normal address for invoices. This field has a list box. The first two lines of the address information display to the right of the ID. Required if the Functions tab specifies that this is a parts inventory location.
This address ID is used on purchase orders for this location (if the Manage parts ordering and economic order quantity (EOQ) values field on the General tab of the Data -> Parts Items -> Setup -> Options screen specifies BY LOCATION). If this field is blank, the value in the Default invoice address ID field on the Purchase Orders tab of the Data -> Purchasing -> Setup -> Options screen is used.
Criteria for conversion of parts from ON DEMAND - PROMOTABLE to STOCKED
The following field is used only if the Manage parts ordering and Economic Order Quantity (EOQ) field on the General tab of the Data -> Parts Items -> Setup -> Options screen is set to ENTERPRISE. It is optional.
Ordered more than _____ times within _____ months on purchase orders with specified purchase types
If the date and time ordered is within the specified number of months and the number of times ordered is greater than the specified number of orders, the part’s stock status converts from ON DEMAND - PROMOTABLE to STOCKED.
The following fields are used only if the Manage parts ordering and Economic Order Quantity (EOQ) field on the General tab of the Data -> Parts Items -> Setup -> Options screen is set to BY LOCATION. If it is set to CENTRALLY, the same fields on the Stock Promotion tab of the Data -> Parts Items -> Setup -> Options screen are used. All fields are optional.
Issued more than _____ units of issue in _____ months
or more than _____ units of issue in _____ months
Two sets of criteria in which x number of units issued in x number of months converts the part’s stock status from ON DEMAND - PROMOTABLE to STOCKED. For example, more than 12 units in 3 months or more than 24 units in 12 months.
Maximum unit price for automatic conversion of consumable parts to STOCKED
Maximum unit price of a consumable part that automatically converts from ON DEMAND - PROMOTABLE to STOCKED.
Minimum age of part at a location for EOQ calculation (months)
Minimum number of months the part must be defined at this location before EOQ values are calculated for the part. This field is optional.
This field is used only if the Manage parts ordering and Economic Order Quantity (EOQ) field on the General tab of the Data -> Parts Items -> Setup -> Options screen is set to BY LOCATION. If it is set to CENTRALLY, the Minimum age of part at a location for EOQ calculation (months) field on the EOQ tab of the Data -> Parts Items -> Setup -> Options screen is used.
Parts receipt processing time (hours)
Average time (to the nearest tenth of an hour) it takes for this location to process a purchase order’s parts receipt. The time begins when the parts arrive at the parts location and ends when the parts are available for issue (after personnel at the parts location place the parts in appropriate bin locations and post the receipts). This field is optional.
Externally managed by vendor ID
Identifier of the external vendor that manages inventory. This field has a list box of active vendors that provide parts functions. The vendor name displays to the right of the ID. This field is optional.
Store ID
Identifier of the store associated with the external vendor. If a vendor is not specified, the list box for this field is blank. This field is optional.
External accounts for:
The following fields enable you to associate work order part issues, direct part issues, or stock transfers with account IDs in either the main system or an external system. You may specify a system account ID or an account ID from an external system.
Work order issues: Identifier of the account associated with work order issues. This field has a list box. This field is optional.
Direct issues: Identifier of the account associated with direct issues. This field has a list box. This field is optional.
Transfers: Identifier of the account associated with stock transfers. This field has a list box. This field is optional.
ABC parameters for inventory counts
Count parts an average x times per year
Specify by ABC code the number of times a year that a part at the location should be counted.
A: Number of times a year that A parts should be counted. Must be zero or higher. Maximum field length is three characters.
B: Number of times a year that B parts should be counted. Must be zero or higher. Maximum field length is three characters.
C: Number of times a year that C parts should be counted. Must be zero or higher. Maximum field length is three characters.
Other: Number of times a year that other parts should be counted. Must be zero or higher. Maximum field length is three characters.
Year type
Indicator of whether the inventory count is based on a calendar or a fiscal year. The options are:
CALENDAR: January 1 through December 31
FISCAL: Determined by the fiscal year end month specified on the Edit Criteria - General tab of the Data -> Setup -> Options screen. For example, if your fiscal year end month is 6, the evaluation is based on July 1 through June 30.
Percent of issue value over the past 12 months
A: Percentage of A code items. Must be zero or greater. Defaults to 70.
B: Percentage of B code items. Must be zero or greater. Defaults to 25.
C: Percentage of C code items. Must be zero or greater. Defaults to 5.
Note: The percentages in the previous three fields must total 100.
ABC codes for a part are calculated automatically if there is a check in the Automatically calculate ABC code field on the Replenishment tab of the Data -> Parts Items -> Location Information screen.
ABC code for parts with no issues over the past 12 months
ABC code for parts that were not used during the previous 12-month period. Must be a letter between D and Z. Defaults to D. This field is required.