Parts: Ordering Information
Use the Ordering Information tab to control the parts ordering behavior within the system.
To open the Ordering Information tab, click the Update/View Profile link on the Parts Profile screen.
The search field on the Ordering Information tab is:
Field | Description |
---|---|
Select Part Number | Enter a part number and click Go >> to display information on the part. If you have previously modified any information on the screen before clicking the Go >> link, you are automatically prompted to save prior changes. |
The fields on the Ordering Information tab are:
Field | Description |
---|---|
OFC |
A code assigned to parts. The system uses this code to determine when the part should be reordered, and the quantity of the part to reorder. This allows parts to be ordered centrally even if they are stocking parts. When the stock order is run for non-central locations, the parts will be transferred from central store based on the OFC criteria. See Centralized Inventory Management for Parts. |
Bin |
The bin number of the part's physical location. |
Package Quantity | The minimum package quantity that the supplier sells the part in. |
Parts Per Set |
If the part is normally sold in a set, enter the number of parts per set. If this part is a stocked part, the system will reorder to maintain at least one complete set in inventory. Defaults to 1 if left blank. |
Order Quantity | The quantity of the part that should be ordered when ordering this part. The order quantity is determined by the system according to the formulas for the order formula code on the part. Usually the order quantity is calculated as the quantity below the reorder point. Some order formula codes ensure that the quantity being ordered is an economical quantity by forcing the minimum amount being ordered to be at least as large as the Economic Order quantity. |
Safety Stock |
Maintains parts in stock so you don't run out of stock. Set as a fixed amount (F) or as a percentage of sales history (%). |
Lead Time |
The number of weeks required by the vendor to ship a part. This is only required for certain order formula codes. |
Reorder Point | The reorder point is the minimum level that the inventory is allowed to deplete to before an order is placed for this part. This field must be set manually for OFC 6. |
First Month Shift |
Used to shift the sales history used in calculating stock orders. The sales history can be shifted forwards or backwards a specified number of months. For example, if this year's sales activity is expected to be one month earlier than last year enter 01. If this year's sales activity is expected to be one month later, enter - 1. This first month shift stays in effect until manually removed. |
Central Order/Branch |
The central location field indicates which branch is to act as a 'Central Branch' set up in the stock transfer and central inventory parameter. If you want the system to include this part's sales history in the central ordering location even if it is a stocking part (OFC not equal to 5 and don't order code not equal to D). |
Protect Months |
Indicates the number of months this part is protected from stock transfers. This is not mandatory but works in tandem with the Protect Code field. The Monthsfield automatically counts down after each parts month end is run. |
Protect Quantity |
The number of parts that are protected from stock transfers. This is also not mandatory, but is used to determine if there is a minimum quantity you want to protect. For example, if the protect quantity is 4 and there are 10 on hand then a transfer of 6, based on the surplus transfer criteria, will be suggested. |
Protect Code |
The protect code is assigned to protected parts to indicate that the part is to be excluded from stock transfers. This code is a dealer-defined code and cannot be edited and can be a number or letter. This code is also blank by default and is not a required value. Most dealers use this as a letter (such as N – new part for a new model of equipment that they want to protect.) You can use the code by itself or to indicate the number of months you want it protected if you like the number of quantities to protect. Additionally, this code is part of the surplus transfer screen, and is used to indicate whether you want to include or exclude protected inventory on surplus transfers. Note: Once a protective inventory code (CD) has counted down to zero it resets the CD and Months field to blank. |
Do Not Order Code | The do not order code must be D or blank. Code D prevents the part from being ordered on a stock order. |
Do Not Order Date | The do not order date must be blank or a number from 01 - 12. If left blank, normal parts ordering will occur on the order formula code for this part. A number in this field indicates that this part is not to be ordered on a stock order until the first stock order in that calendar month (e.g. if 03 is entered, the part will not be ordered until the first stock order in March). |
Season Length |
Must be used in conjunction with the do not order date. If a do not order date of 03 (march) is entered and a season length of 2 (months) is specified, the part will not order until March and will only order for 2 months. Season length can be any value from 1 - 9. Season length and do not order dates will stay in effect until manually removed. |
Effectual % |
If you expect an increase or decrease in sales for this part, enter the percentage increase or decrease in this field (e.g. 50 = 50%). The effectual percentage is applied to the sales history before the stock order is calculated. Effectual percentage is only allowed for order formula codes that use sales history in their calculations. |
Number of Months |
Refers to the month when the effectual % will no longer apply. The number of months entered automatically counts down after each parts month end is run. However, even after the months have counted down to zero, as long as there is a protective code on the parts master file, the item will be excluded from the stock transfer routine. Protected months can be a value of up to 60 months. |
Reclass |
If selected, marks the part to be automatically reclassed by the next OFC reclass run. In the text field next to the checkbox, you can add a code of up to 10 alpha-numeric characters. The code is used as a label for a part. This code is used to associate parts with a reclass table and the lines within that table. You can use the Reclass code to group parts. This is not the same as the OFC, but is dealer-defined. Depending on the Reclass/Matrix Trigger setting on the System Settings screen, this field may be automatically updated by the system if the Source, Class, Type, or Inventory Class fields are changed on the Parts Profile tab. See Centralized Inventory Management for Parts. Note: The text field is not dependent on the checkbox being selected. |
AMAX APR Code/Source |
The APR code indicates whether Availability MAX controls replenishment for a given part. The source code indicates the location the part is ordered. Note: Only dealers with a frame connection to Case or who are using ABC can use the AMAX interface. |
Season Code | This code is used to apply a special forecast designed to take the seasonality of the part into account when the forecast is calculated. |
Required Quantity |
The minimum required quantity of a given part that needs to be stocked at the dealership location. This field is only visible if Configuration > Interfaces > CNH > AMAX is Active. |
Return Quantity |
The recommended amount of parts to be returned to Komatsu. This field is only visible if Komatsu feature 6523 is enabled. |
Inventory | The quantity of parts in stock at the start of your business day (since the last billing run), plus any receipted shipments or inventory adjustments. |
Allocated | The quantity of allocated parts. A part is considered allocated when the part is sold on a rental contract, equipment invoice, or adjusted on a work order. Once parts are invoiced, they are cleared from this field after a rental billing run, and/or a regular billing run has been processed. |
Reserved | The quantity of parts that have been reserved. A part is considered reserved when the part is entered as a non-serialized rental, issued on a sales order, issued on a sales order requisition, put on reserve using cash code R, a Machine Down or Field Inspection order has been created to special order the part, and then receipted in using the Parts Ordering screen, causing the part to be issued. Parts are no longer reserved after a sales order billing run has been processed. |
On Hand | The quantity of parts in stock (Inventory) less the number of parts Allocated or Reserved. |
On Order | Quantity of parts currently on order with the supplier. |
In Transit | Quantity of parts currently in transit. Click on the quantity to see a list of all pending order receipts for the selected part. |
Lost Sale Frequency |
The number of times this part could have been sold if it had been in stock. Note: The Lost Sale Frequency value will reset back to zero after running the last parts month end for the fiscal year. |
Lost Sale Quantity |
The total quantity of parts missed sales that could have been sold if the part was in stock. Note: The Lost Sales Quantity value will reset back to zero after running the last parts month end for the fiscal year. |
YTD Sales $ | The total year to date sales of the selected part. |
YTD Sales Quantity | The fiscal YTD (year to date) sales quantity sold for the part. |
Date Last Sale | The last date of sale for this part. |
Company Last 12 | The total sales quantity for this part number for the last 12 months for all stores within the company. This value is recalculated during the first full database reorganize after the parts month end. Processes that update or change parts sales quantities (ie. manual updates, transfer of parent part information to subs) will not impact this field immediately. |
Special Order Frequency | The number of times this part has been special ordered for the current fiscal year. |
Special Order Quantity | The total quantity of the part that has been special ordered this year. |
Last Order | The order number for the last order for this part. |
Last Order Type | The last order type (e.g. SO - stock order, Q1 - quarterly order, 1st quarter, MD - machine down). |
Last Receipt Date | The last receipt date for the part. |
Movement Code |
Defines the movement of the part into these categories:
|
Activity Code |
Defines the type of activity the part has had with the following codes:
|
Last Stock Order | The last stock order date for this part. |
Last OFC Reclass |
The last OFC reclass run for this part. |
From/To Elements |
The From/To Elements shows From: the previous matching element (row) within the OFC reclass table. To: the element (row) in the OFC reclass table that the element last changed to, during the last stock order run. |
Months Supply | A calculated number of months of supply for inventory of a part number that is currently on hand. The calculation is On Hand times 12 divided by the Last 12 Months Sales. |
Note: Case dealers can set a flag on the part number indicating that selected information on the part such as on hand quantity, sales history, bin trips, and cost be FTP'd to Case during the nightly database.
The Sales Summary section on the Ordering Information tab displays the total monthly sales quantity for each month over the past two years.
The fields on the Ordering Information tab are:
Field | Description |
---|---|
Current | Displays the current sales quantity. |
Month | Displays the total sales quantity per month, for the last 24 months. |
L 6 | Displays the total sales quantity for the last 6 months. |
L 12 | Display the total sales quantity for the last 12 months for this part for this store. |
LYR | Displays the total sales quantity for the last fiscal year. |
2 YR | Displays the total sales quantity for the previous two fiscal years. |
Select the Click here for suggested ordering parameters link to display suggested ordering parameters.
Use these buttons to complete your work on the Ordering Information tab:
Button | Function |
---|---|
Save | Saves changes made to the Ordering Information tab. |
Close | Closes the Ordering Information tab without saving and returns to the Part Profile screen. |