Skip to main content
DealerTeam

Parts Record

The Parts Record provides details on a specific inventory item. Sounds simple right? Before we move into how the part is used we need to learn about all the information contained in the parts record.

  In this section you will Learn about the different components and fields that make up the Parts Record. Remember the Parts Record is a Store specific record. Because of this some of the attributes are controlled by the Parts Master and some are changeable by the Parts Record.  Any changes in Manufacturer, Part Number, Parts Description, Cost, Retail Price or Pack Quantity should be done at the Parts Master level.  

Part Detail 

Included in this section are fields that define the Part. 

  • Location:MFG:Part Number - This field is the Part Name and a unique string representing the Part.The layout will be as follows: Location Code: Manufacturer Code: Part Number.
  • Company - The physical location of the inventoried part item. This is synonymous with Location.
  • Description - Description of the part. This field is limited to 255 characters. This is Driven by information input in the Parts Master.
  • Part Master - Required for all inventoried part items, this lookup field controls and defines the part. Learn more about Parts Master.
  • Status - Status of the part.  This value can be Active, Obsolete, Obsolete with Inventory.  The status of this part is controlled by the Part Master.
  • MFG - Manufacturer of the part. Defined by the Part Master.
  • UPC - Universal product code associated with this part.  This field allows for part managers to save an additional unique value related to this part.

Parts Record, Detail Section image

Pricing

Included in this section are fields for list, cost and core values.  These values traditionally represent the pricing details either provided by the part manufacturer or manually populated. Most of these field

  • List - Represents the suggested retail price for this part. This is set by the Retail Price entered in the Parts Master.
  • Cost - This value is the current cost of replacing this part. This is set by the Cost Field in the Parts Master.
  • Core - Core value to be reserved when this part is sold.
  • Static Price - This price field overrides the pricing strategy set on a part.  For example, if using a matrix pricing strategy and this field is populated the part will be sold at this static price. This field will over ride the Minimum Advertised price set in the Parts master.
  • Gross Margin - This is a calculated field.  List - Cost / List.  This field is primarily used for reporting.
  • Minimum Margin - Control field.  When set, a part may not be sold for less than the minimum margin.  This field does not base margin on the FIFO/LIFO value, but the replacement cost specified on the part record.
  • Price Update - Checkbox that defaults to True when a new part inventory record is created.  This field determines if this part should allow it's values to be updated if a price tape update is run.
  • Jobber - Control field that specifies what the default jobber price on this part should be.  Jobbers are usually categorized as mechanical repair shops purchasing for resale purposes. This is set at the Parts Master Level.

Parts record Pricing section

Inventory

Inventory section contains details related to the current stocking levels of the part inventory. 

  • On-Hand - Current on hand quantity at Store Level.
  • Pack Quantity - Supports pack purchase requirements for parts.  On-Hand will represent each individual item within the pack.  The pack quantity is used primarily in purchasing when a vendor only sells a part in a specific quantity.
  • Physical On-Hand - A system calculated field based on entries in the parts ledger.  
  • Physical Value - Ledger value of this part record, On-hand multiplied by Cost. Note this is what you paid for your current inventory not the replenishment cost of your on hand inventory.
  • Entry Date - Date the part was entered into the inventory.  This value represents when this part first entered the locations inventory.
  • Last Sale Date - Date this part was last sold at the specific location.
  • Replenishment Date - Date the part was last replenished at the specific location. 
  • Days in Stock - Used to measure the duration of parts in-stock.
  • On-Order - Count of on-order records for this part.
  • On-Backorder - Count of this part currently on-backorder.

Parts record, Inventory section

Stock Management

The settings related to a specific part determining how the part should be stocked within the location.  

  • Stocking Group - Stocking Groups determine sales, cost of sales accounts this part, when sold, or added to inventory will be placed on the accounting ledgers.  This lookup is also used for categorizing parts for reporting purposes.
  • Source - Reporting field allowing users to store who is the preferred Vendor to order a part from.
  • Source List - Reporting field specifying the pre-configured source list.  This field offers structured sourcing lists/groups and acts as a high level reporting field.  This is not a required field.
  • Bin - This will reference the physical location of the part in your warehouse or parts room.
  • Remarks - Internal reporting and inventory stock management field reserved for tracking remarks on this specific inventory item.
  • Best Stocking Level - Number of units determined to be the best stocking level for this part. This should be considered your "normal" inventory level of a given part.
  • Re-Order Point - Use re-order point for running stock management and replenishment reports. This should be set based on time frame to replenish a given part compared to daily or weekly use of the part in normal operations.
  • Min - Minimum on-hand inventory desired stocking level for this part.
  • Max - Maximum on hand stocking level for this part.
  • Return Code - Notes specific to returns on this part.

Stock Management section

Images/Catalog -

Image and rich text resource, This will key off the input given in the Parts Master.

Parts image section with rich text

Related Lists

Related Lists are a selected group of Objects that relate to the Parts record. The most common occurrence you will see is if your part is part of a Parts Kit. 

Part Invoice Lines

This related list contains details on all parts invoice line sales.  These lines are details of sales related to this part from Part Invoices and Repair Orders.  This list can be customized by editing the related list on the standard page layout for the Parts Inventory Object.

related list, part invoice lines

Purchase Order Lines

This related list displays Purchase Order Lines related to this Part.  This list can be customized by editing the Purchase Order Lines related list on the Parts Inventory Standard Page Layout.

Related List, Purchase Order Lines

Part Ledger

This related list displays where this part has been added to Part Ledger Lines. 

Part Ledger Lines in a related list 

Part History

This related list records the history of all activity for this part at the specific location.

Related List Parts History