Parts Profile

The Parts Profile screen displays detailed information for the selected part. See also Parts Substitution Notes.

Click on the Previous, Change, or Next icon in order to scroll to the previous part number on the list, search for a different part number, or scroll to the next part number on the list.

The search field appears on the Parts Profile screen:

Field Description
Select Part Number Enter another part number and click Go >> to display profile information of the selected part.

Use these buttons to complete your work on the Parts Profile screen:

Button Function
Back Closes the Parts Profile screen and returns to the Parts tab.
Label Opens the Select Print Parameters screen allowing you to print parts labels.

The sections on the Parts Profile screen are:

Note:  Field level-security assigned to your user profile (as defined on the Field - Work With Field Level Security screen) may change the appearance of or hide certain fields.

Main Section

The fields appear on the Parts Profile screen:

Field Description
Part Number The part number assigned to the selected part.
Description

A brief description of the part.

Parts/Package

The quantity of parts purchased from a vendor in a single package. The parts per package signifies how the system will maintain inventory on this part.

For example, a vendor may only sell you oil filters in cases of 12, but you can number and sell them individually from your store. When you receipt the part however, you would receipt it as a quantity of 12.

The price and cost loaded on this part should be the list price of one whole package. When the part is sold, the selling price and cost is divided by the Parts/Package to calculate the selling price and cost for a single item.

Note:  If the Use the same Parts Per Package for all locations setting is activated on the System Settings: Division screen, the value in this field must remain the same across all branch locations.

Vendor The vendor number for the supplier of this part.
Machine The machine number that the part can be used on.
Model The model number of the machine that the part can be used on.
Update Type Used to determine if a price update run should automatically update the parts master file or whether it is going to be maintained manually.
Label Indicates whether a label is to be printed for this part number when it is receipted through the Parts Ordering screen.
Category Indicates if the part is categorized as a Wear part. A Wear part indicates that the part will naturally wear and is not covered under warranty (e.g. filter or brakes). Wear parts are omitted from the parts highlighting rule (indicated by the Warning icon -flashing triangle) that appears on the Work Order Parts Requisition Details tab.
Last Count The last inventory count which included the selected part.
Last Count Date The date of the last inventory count.
Subs If this part subs to another part, the substitute part number will be displayed.
Comment An alternate description or note about the selected part.
Bin

The bin number indicates the part's physical location.

If this field appears highlighted, alternate bins exist. Move the cursor over the Bin number to view alternate Bin location numbers.

If applicable, the part's previous bin number will appear in brackets next to this field.

Source

The part's source of supply code. This typically represents the part's originating warehouse location.

Valid source of supply codes are configured and listed on the Source of Supply screen.

Class

The class code of the selected part.

In conjunction with the Type code, the class code is used to group similar parts together. Valid class codes are configured and listed on the Classes screen.

Type

The type code of the selected part. In conjunction with the Class code, the type code is used to group similar parts together.

Valid type codes are configured and listed on the Types screen.

Return

The return code for the selected part, which indicates whether it is returnable.

New return codes are configured on the Return Codes screen, however vendor-supplied return codes are not configurable within IntelliDealer. For more information regarding a specific vendor's return codes, contact the vendor.

This field will appear highlighted if the selected part number is on an active surplus return. Hover over the field label to display the surplus Return Number.

Weight The metric weight of the part.
Matrix

The price matrix associated to the part. The system uses this to determine the proper price increase percentage for the part.

Valid price matrices are configured and listed on the Price Matrix screen.

OFC Reclass Whether this part is affected by the OFC reclass run.
Sell The selling price of the part. The parts sell price may be affected by the Parts/Package field.
PIP The price increase percentage for the selected part (as specified in the Increase % field on the Parts Profile tab). The alpha character next to the value in this field (C or L) denotes whether the increase percentage will be applied to the Cost or List price of the part.
List Price The part's suggested list price.
Cost The net cost of the part.
Average Cost

The Average CostClosed The average cost is automatically updated whenever parts are receipted in the system (either through inventory adjustments or parts orders). When a part is returned, the system uses the Average cost to return that part to Inventory. To calculate Average Cost, assume a part is added to the system with a cost of $10.00 and 2 parts are receipted. The average cost is $10.00 for each of these 2 parts. Now assume the cost increases to $12.00 later in the year and 1 additional part is receipted after that cost has increased. The new average cost is calculated as follows: (Old Avg Cost x Old on Hand) + (New Cost x Number of Parts Receipted at New Cost) / Old on Hand + Number of Parts Receipted OR (10.00 x 2) + (12.00 x 1) / (2 + 1) = $10.66of the part.

The average cost of a part is calculated using the Landed CostClosed The Landed Cost of a part is the final cost of the part on an order after all applicable Order Creation and Order Update cost code factors have been applied to the Current Cost of the part. Cost factors are applied when the part is ordered and receipted into the system based on the order Type (eg. SO: Stock Order, MD: Machine Down, FI: Fill In, etc.) The Landed Cost of a part will, in turn, be factored into the Average Cost of a part (as specified in the Average Cost field of the Parts Profile tab.) For details regarding cost code logic, please see the Cost Code Logic topic in the FAQs and Troubleshooting section of the online help. For details regarding the Average Cost of a part, please see the Average Cost definition in the Glossary section of the online help. of a part which, in turn, is calculated based on the Cost Code assigned to the part profile. For details, see the Cost field description on the Parts Profile screen.

Level 1, Level 2, Level 3, Level 4, The pricing levels of this part. These levels refer to such things as wholesale price, fleet price, jobber price, etc.
Added The date the part profile was added to the system.
Modified The date the part profile was last modified.

You can drag and drop the Sales Summary, Availability, Ordering Information, and Additional Information sections as indicated by the Drag/Drop icon , allowing you to customize the order of the sections that appear on the Parts Profile screen.

Sales Summary Section

The fields on the Sales Summary section of the Parts Profile screen are:

Field Description
Rows
Quantity The number of parts sold per month.
Demand

A single demand entry (1) is made by each parts invoice to a part's profile regardless of the number of times that part is sold on that one invoice. Also, only one credit demand entry (-1) is made by each parts invoice regardless of the number of times that part was returned on that one invoice. However, if a part is sold (1) and returned (-1) on the same parts invoice the demand entry is zero because 1 +(-1) = 0.

  • Demand is calculated the same way for both parts invoices and work order requisitions.
  • A demand is recorded for a parts lost sale, if the Record Demand field on the selected lost sales reason code is active.
Trips The number of physical trips to the part's bin.
Average The average between the quantity of the part and the number of bin trips.
Columns
Current

Values appearing in this column are for activity to date in the current month.

L6 Values in this section of the column refer to the most recent six month period.
L12 Values in this section of the column refer to the most recent twelve months of activity.
LYR Values in this section of the column refer to the sales quantity for the last fiscal year.
2 YR Values in this section of the column refer to the total sales quantity from two years ago.

Availability Section

The fields on the Availability section of the Parts Profile screen are:

Availability
Field Description
Location The branch location that stocks the selected part.
On Hand

The number of parts the corresponding branch location has in stock.

A 'future rental adjusted' value will appear in red colored text on parts for non-serialized rentals so that the true On Hand value is displayed without having future rentals considered in the quantity.

On Order The number of parts the corresponding branch location has on order.
OFC

The order formula code for the part in the corresponding branch location, which will determine the amount of parts to order on the next stock order shipment.

For more information regarding order formula codes, see the Order Formula Codes Summary.

Click on a Location to switch from your default branch location to another branch location.

Ordering Information Section

The fields on the Ordering Information section of the Parts Profile screen are:

Ordering Information
Field Description
OFC

The order formula code for this part. This code determines the method to be used in computing the order quantity for a part.

For more information regarding order formula codes, see the Order Formula Codes Summary.

Package Quantity

The minimum package quantity that the supplier sells the part in. (e.g. the part could come in a package of 10).

Parts Per Set If the part is normally sold as a set this field lists the number of parts in a set. The system reorders parts for this item to maintain at least one complete set in inventory.
Order Quantity

The number of parts needed the next time the part is ordered.

For some order formula codes you can set the order quantity manually, but for other order formula codes system automatically calculates the quantity.

Safety Stock Maintains parts in stock so you don't run out of stock. Maintained as a fixed amount or as a percentage of sales history, F (fixed) or % (for percent).
Lead Time

The time (in weeks) it takes the vendor to ship the parts, or the number of weeks between the time part should be ordered and the time that the parts are actually received.

Reorder Point The minimum on hand amount the part can reach before an order is placed.
First Month Shift

Shifts the sales history used in calculating stock orders. The sales history can be shifted forwards or backwards a specified number of months.

In the first month shift field, 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.

Central Branch If selected, indicates which location will act as a central location as set up in the stock transfer and central inventory parameters.
Central Order If selected the system includes this part's sales history in the central ordering branch even if it is a stocking part. If not selected, the system would only include sales history of parts that had either an OFC of 5 or a don't order code.
Reclass Indicates whether this part is affected by the OFC reclass run.
Protect Months

Indicates the number of months this part is protected from stock transfers. This is NOT a mandatory field but works in tandem with the Protect Code field.

Note:  The Months field will automatically countdown after each parts month end is run. When the countdown reaches zero, the part will no longer be protected.

Protect Quantity The quantity of the part that is protected from stock transfers. This is also NOT a mandatory field. This field is used to determine if there is a minimum quantity you want to protect. E.g. with 4 units of a part protected and with 20 on hand then a transfer of 6 based on the surplus transfer criteria will be suggested.
Protect Code

The protect code is assigned to parts to indicate that the part is to be excluded from all parts transfers.

This code is a dealer defined code and has no edit controls for it's value. The code can also be a number or a letter. This code is also blank by default and is not a required value. Most dealers use this as a letter (eg N - new part for a new model of equipment that they want to protect.) You can use the code by itself or to indicate that 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 Must be D or blank. Code D will prevent the part from being ordered on a stock order.
Do Not Order Date This field indicates that this part will not be ordered on a stock order until the first stock order in that calendar month. For example, 03 represents March. If this field is blank, normal parts ordering will occur.
Season Length

Used in conjunction with the Do Not Order Date. The number of months (01 to 09) that the part is considered in season, indicating the number of months the part is ordered.

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%).
Number of Months Refers to the month when the effectual % will no longer apply.
AMAX APR Code/Source

The APR code indicates whether AvailabilityMAX will control replenishment for the selected part.

The source code indicates the location the part is ordered.

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.

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 or equipment invoice, or the part is 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.

Note:  Parts sold on an invoice or work order parts requisition are shown as reserved, (not allocated), until the next billing run.

Reserved The quantity of parts that have been reserved.
A part is considered reserved when the part is entered as a non-serialized rental, the part is issued on a sales order, the part is issued on a work order requisition, the part is 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 Part 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.

The APR codes are:

APR Codes
Code Description
A The AvailabilityMAX will provide parts ordering recommendations.
M A dealer Manually orders part through the existing DBS.
D The part has been deleted from DBS, or it will no longer be communicated to CNH.

The Source codes are:

Source Codes
Code Description
D This part is ordered through a depot.
S This part is ordered through a CNH ship direct promotion.
A This part is ordered through an Allied depot.

Click on the Reserved quantity to view all of the customers who have reserved the selected back ordered part.

Click on the On Hand quantity to open the Parts Availability screen.

Click on the On Order quantity to display all current orders that include the selected part number.

Click on the In Transit quantity to view a list of pending order receipts for the selected part number.

Additional Information Section

The fields on the Additional Information section of the Parts Profile screen are:

Additional Information
Field Description
Lost Sale Frequency The number of times this part could have been sold if it had been in stock.
Lost Sale Quantity The total quantity of the part that could have been sold if it had been in stock.
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 selected part.
Date Last Sale The last date of sale for the selected part.
Company Last 12 The total sales quantity for the selected part 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 the selected part has been special ordered for the current fiscal year.
Special Order Quantity The total quantity of the selected part that has been special ordered this year.
Last Order The order number for the last order for the selected 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 selected part.
Movement Code

Defines the movement of the selected part into these categories:

  • F - Fast moving parts.
  • S - Slow moving parts.
  • Z - Zero sales parts; no sales or bin trips in the past 12
  • months.
  • N - New parts; no sales or bin trips in last 12 months but part added less than "Y" days ago.
Activity Code

Defines the type of activity the selected part has had with these codes:

  • N - New part.
  • G - Group file maintenance to stocking policy fields.
  • S - Positive sale processed by billing run.
  • R - Negative receipts through inventory adjustments screen.
  • C - Change to OFC parameters (stoking policy) or to sales
  • history.
  • T - Indicates that this part's history was transferred from a parent part which had a (Blank) activity code. Otherwise the child part would have inherited the parent's activity code during the transfer.
  • (Blank) None of the above since last stock order processed this part.
Last Stock Order The last stock order date for this part.
Last OFC Reclass The last OFC reclass run for this part.
From/To Element Ordering and receiving elements.
Months Supply

The number of months of supply for the selected part based on the current On Hand quantity of the part. The calculation for the value displayed in this field is:

 (On Hand quantity x 12)/L12  Sales

0 is displayed if the On Hand quantity of the selected part is less than or equal to 0 and the L12 Sales value is 0.

99 is displayed if the On Hand quantity of the selected part is greater than 0 and the L12 Sales value is 0.

 

Data Source: PARTMAST

Security Switch: 820 - Parts Profile

Revision: 2024.11