Tips and Tricks for Parts Inventory Accuracy

IntelliDealer’s parts module provides robust tools for maintaining inventory accuracy, but achieving reliable on-hand counts requires careful attention to data setup and daily processes. This topic describes how configuration, daily posting habits, and counting routines affect parts on-hand accuracy in IntelliDealer. Use it as a practical checklist to maintain parts records.

Topics in this section are:

• Effective Inventory Management

• High-Impact Workflow Improvements

• Healthy Parts Operation Benchmarks

Effective Inventory Management

Effective inventory management requires correct configuration (table setup), disciplined transaction posting, and continuous counting and auditing. Missteps in any of these areas undermine accuracy. This section describes how to improve each within IntelliDealer:

• Table setup and Configuration

• High-Impact Workflow Improvements

• Healthy Parts Operation Benchmarks

Table setup and Configuration

IntelliDealer configuration tables and part records must be set up carefully, because they determine how inventory is tracked and valued.

• Unit of measure and parts per package (PPK)— The Parts Per Package field should reflect how parts are stocked versus sold. If one box of 12 spark plugs is entered as PPK = 1 instead of 12, the system treats each plug as a full box and can overstate quantity and value by twelve times. Audit parts with PPK greater than 1 regularly and ensure cost values align with package quantity.

• Default accounts and codes—Each part is linked to a vendor code and sales account that drive how transactions post to accounting. Incorrect defaults (for example, a part tied to the wrong vendor or revenue account) can make inventory reports misleading even when on-hand counts look fine. Many dealerships use separate accounts per vendor line. See Reconciling the General Ledger to your parts inventory.

• Controlled adjustment tools—IntelliDealer supports several ways to adjust inventory, including Inventory Count and Parts Invoicing Details using special customers and transaction types. Configure security and operator codes so that only approved methods are used and changes leave an audit trail. For bulk corrections to master data, use Change Parts Information where appropriate.

Posting practices (transactions and workflows)

Every movement of parts should be reflected by a transaction in IntelliDealer. How those transactions are executed has a direct impact on accuracy.

• Receipting parts orders—Receipt vendor shipments in IntelliDealer before parts are issued to the shop or a customer when possible. If parts are sold or used before they are received, you can get negative on-hand quantities and timing errors. A practical rule is: do not sell or use a part until its purchase order is received and posted when your process allows it. Use Parts Order Receipting and, where deployed, Parts Receipting on Parts Inventory Control so on-hand quantities update as soon as material arrives.

• Using special invoices for adjustments—When you find discrepancies during a count or while investigating damaged stock, avoid silently overwriting quantity. Preferred practice is to use Parts Invoicing with an inventory adjustment style customer (for example, an IAXX-style account configured for your location) so inventory and G/L stay aligned. Each location typically configures that customer so it does not distort sales history, is tax-exempt where applicable, and uses average cost. This approach records an invoice that explains the change. Ad-hoc adjustments without proper offsetting entries are harder to reconcile. For related context, see Reconciling the General Ledger to your parts inventory.

• Returns and credits—Process customer returns so inventory is credited at the correct cost. When returning parts to vendors, use the appropriate Parts Return workflow so inventory and credits match. For vendor returns, your team may follow procedures such as those in Recording a Vendor Parts Return or Returning Core Parts to a Vendor.

• Parts transfers—For multiple locations, configure System Settings to use the accrual method for inter-store transfers when available so stock in transit is accounted for correctly. Complete both sending and receiving steps so one location is not relieved before the other records receipt.

• Daily workflow discipline—Use standard reports as part of the daily routine. The Parts Daily Error Control Report (PAR014) highlights new parts and exceptions; review it to catch missing bin, cost, or vendor information. If enabled, the daily low-margin report (PAR127A) can flag unusual margins that may indicate receipt or costing issues. See also Parts Reports Overview.

Counting processes

Regular auditing is essential. IntelliDealer supports full physical counts and cycle counts through Inventory Count, Cycle Count, and optional Wireless Inventory Control.

• Annual full counts versus cycle counts—A single annual count true-ups the file, but errors can accumulate all year. Prefer cycle counting on a rotating schedule (for example, fast movers weekly or monthly, slower items quarterly). Use Inventory Count under Product Support > Parts > Inventory Count to build count lists, enter quantities, and post adjustments. For cycle count concepts, see Expanded Cycle Counts Information.

• Wireless scanning and spot checks—If your dealership uses Wireless Inventory Control, you can perform Quick Check, sequential counts, or counts tied to count numbers with barcode scanning to reduce keying errors. Scanning helps ensure the part on the shelf matches the part in the system.

• Immediate variance reconciliation—When a count shows a variance, investigate before posting: unposted invoices, wrong bin, or pending transfers often explain the difference. Use variance reporting available in your count workflow to focus on large differences first. See Inventory Count vs Inventory By Bin.

• Ongoing monitoring—Run the Inventory Summary (report WPSPR02B or WPSPR04A for details; see Reconciling the General Ledger to your parts inventory) on a schedule that matches your controls, and compare parts valuation to the inventory G/L account. Drift between physical process and the ledger is a sign to tighten posting or counting.

High-Impact Workflow Improvements

Consider these changes to tighten control and reduce errors. Each uses features that are already available when your dealership is licensed and configured for them. Together, these practices improve fill rates and customer service because on-hand quantities and bin locations in the system match what is on the shelf.

• Barcode scanning for movements—Where Wireless Inventory Control is in use, scanning for receiving, transfers, and counts reduces wrong part numbers and speeds data entry. Barcode scanning generally improves count accuracy compared to manual entry.

• “No off-system transaction” discipline—Treat IntelliDealer as the source of truth. Parts should not leave the storeroom without an invoice, work order issue, or transfer. Receive shipments before put-away when possible. For deliveries that are not invoiced immediately, use the PicPak process so issued parts are tracked consistently (see also Tips and Tricks).

• Training on standard features—Ensure you and your team know how to complete an Inventory Count from count file through variance review, and how to use inquiry screens to verify on-hand before and after unusual transactions. Features such as Quick Check and Stock Movement on Parts Inventory Control, and Picking List tied to invoicing, help prevent missed billings and unexplained shortages.

• Formal cycle count schedule—Assign recurring slots (for example, one aisle before lunch, special-order shelves on a set day) so the entire storeroom is covered each quarter at minimum. Track whether adjustments shrink over time; that is a sign the process is working.

• Periodic data cleanup—Review parts management reporting (PAR029) at month end, list negative on-hand parts and drive them to zero, and review large gaps between average and last cost. Minimize catch-all miscellaneous part numbers for everyday sales, which can hide true usage. Use Change Parts Information for controlled corrections to master data.

Healthy Parts Operation Benchmarks

Use these indicators to gauge whether table setup, posting, and counting are working. Targets vary by dealership size and line of business; treat them as goals, not guarantees.

• Inventory record accuracy rate—The number of SKUs where system on-hand matches the physical count. Many operations aim for 95% or higher accuracy on counted items; world-class operations often reach the mid-to-high 90s.

• Cycle count frequency—A strong program touches all active stock at least once per quarter, with faster movers counted more often (monthly or weekly).

• Negative on-hand quantities—Try to eliminate the occurrence of negatives. Persistent negatives usually indicate problems with receipt or issue timing.

• Parts versus G/L variance—When you compare inventory valuation to the inventory G/L account, variances should be small (often well under half a percent of inventory value when processes are tight). Investigate recurring gaps.

• Annual adjustment size—If you still take a full physical inventory, net write-offs much above roughly 1–2% of inventory value may signal process gaps; that number should shrink as cycle counting matures.

• Fill rate and lost sales—Better accuracy supports higher first-pick fill on stocked items. Track lost sales and stock-outs to complement pure accuracy metrics.

• Obsolescence—Accurate records and management reporting make slow-moving and obsolete stock visible so you can return or phase it out.

Revision: 2026.04