Parts Reports Overview

A Parts Reports is an Availability report and Inventory Summary report that you can create using an easy-to-select querying tool. The output is generated to your screen for you to review and edit your selections.

Title Report Description
Availability Listing WPSPR02C

Prints a list of parts by part number for each store in this company. See Availability Listing.
Case Responses - Back Orders CNN009A PSO (public service obligation) status report from CNH showing updates to back-ordered only parts orders which have been transmitted.
Case Responses - Order by Dealer CNN009 PSO status report from CNH showing updates to parts orders which have been transmitted.
Consignment Inventory Suggested Replacement PAR218C Consignment-suggested replacement report based on current on-hand vs minimum stocking quantities.
Consignment Inventory Summary PAR218S Consignment inventory summary report by number of items.
Consolidated Order Receiver PSPO019C Consolidated ordering system-specific PO receiver report.
Customer Consignment Inventory PAR218D Consignment inventory detail report.
Group Receipt Report PSPOR03 Pending order receipt system-specific PO receiver report.
Inter - Company Transfer PAR229

Lists the parts being transferred from another location. The purchase order number and value are also listed on the report.

To enable this report, select the Print Inter-Company Transfer Report check box on the System Settings - Location screen.

Inventory by Bin WPSPR02D Lists all parts selected for this run showing bin location, part number, net on-hand, and part description. Space is provided on the report to record the physical inventory count, and the adjustments that will have to be made to each parts on-hand.
Inventory by Bin Location PAR042

Lists all parts selected for this run showing bin location, part number, net on-hand, and part description. Space is provided on the report to record the physical inventory count, and the adjustments that will have to be made to each parts on-hand.

Inventory Value Report PAR144 Displays detailed valuation of inventory count.
Inventory Value Report PAR144S Displays summary valuation of inventory count.
Inventory Variance Report PAR138 Displays variances between counted and on-hand values in an inventory count.
Management Information

 PAR029

Provides an analysis for the parts departments performance for the current month. For a detailed breakdown of how this report is calculated, see Management Information Report.

Vendor G/L and other miscellaneous vendors are NOT excluded in any way.

Management with Transfer Information PAR29A Provides an analysis of the parts departments performance for the current month. For a detailed breakdown of how this report is calculated, see Management with Transfer Information Report.
Manual Parts Order PAR031 Prints parts orders in the manual parts order format (not sending parts order through data communications, so print the parts order in this format and mail to your supplier). The report shows the part #, bin location and the quantity ordered.
MD/FI Parts Order PAR070 Prints a list of all parts that were ordered as machine down (MD) or fill-in (FI). These parts are assigned a parts order # every time a machine down/fill-in parts order is created. All parts that were ordered as machine down or fill-in since the last time a MD/FI was created are assigned to the next MD/FI parts order.
Non-Stock Review Report PAR187 Prints a Non-Stock Review report. All parts with an (OFC code = 5 or don't order code = D) and auto reclass = N and activity since the last stock order (i.e PMACT <> ' ')
OFC Reclass Impact Report WPSPR02E Lists old and new values for the parameters on the parts master if an OFC reclass were run.
Parts Cost Analysis - Details PAR127A Displays detailed parts billing cost analysis produced during billing run.
Parts Cost Analysis - Summary PAR127 These reports are created from the parts billing run if table DIVTAB - Parts Costing Journal or Detail (J or D) are set to "D". Reporting sale account, description, invoice account, sales account, sales$, cost$/%, profit$/%. Details reporting invoice#, part number, part description and quantity. Totals by branch, division and company.
Parts Cost of Sales Analysis - Summary & Details

PCAR16427

(formerly PAR127- Parts)

 Lists the cost analysis for parts billed to an invoice and shows the profit for each part sold.
Labor Cost of Sales Analysis - Summary & Details

LCAR80235

(formerly PAR127- Labour)

 Lists the cost analysis for labor billed to an invoice and shows the profit for each labor entry.
Parts Department Daily Error and Control Report

PEACR70081

(formerly PAR014)

Prints an error and control report for the parts department to review if a part sold in this billing run meets one of these conditions:

  1. Part is not on part master file, so it is added to the part master.

  2. Part has a negative on-hand.

  3. Part has a zero on-hand and is a stocked part (not order formula code 5).

  4. Part has been sold at least twice and is still coded as a non- stocked part (order formula code is 5).

  5. Cost is greater than selling price (selling price was probably overridden).
Parts Group Update Receipts PAR221 Lists the line items updated and not updated for the selected group receipt. A message is displayed indicating the conditions for the line items.
Parts Inventory Details WPSPR04A Displays detailed parts inventory report.
Parts Inventory Summary WPSPR02B Prints a report by part number, within source of supply, within vendor number, within branch, within division, within company, showing the average cost, current costs, and retail selling price for each part. Totals are printed for each source of supply, vendor number, branch, division, and company showing total average cost, current cost and retail selling price. If printing the summary, only totals for each source of supply, vendor number, branch, division and company are printed.
Parts Invoice SOINV Parts Invoice document. Normally sent directly to printer, it is also visible in the printer/PDF output queue as a SOINV document.
Parts Journal PAR044

Prints a detailed report of the parts costs of sales and parts inventory G/L allocations generated from the billing runs (when the parts system is active) for the current G/L month.

If the default cost of sales percentage is set up wrong. or if the wrong sale account is set up on a part number. then the wrong dollar amount will be retrieved from inventory when the part is sold.

See Parts Journal Report.
Parts Management Versus G/L PAR086

The parts management versus G/L report is used to help reconcile the parts management report to the G/L. See Parts Management vs G/L.

Parts Order PAR007

Prints parts orders showing each part number, description, bin location, quantity ordered, quantity outstanding, quantity received, quantity back ordered, cost of the parts ordered, and surplus of this part that exists in other stores. A total parts order cost prints for each parts order.

There is a switch in tables CMBR to print Deere Special Terms Order
Parts Order - Alternate Source PAR007S

Prints parts orders showing each part number, description, bin location, quantity ordered, quantity outstanding, quantity received, quantity back ordered, cost of the parts ordered, and surplus of this part that exists in other stores. A total parts order cost prints for each parts order.

There is a switch in tables CMBR to print Deere Special Terms Order
Parts Order #S Assigned PAR022 Prints the part order numbers assigned when adding to purchase order and purchase parts. Reporting company, division, branch, purchase order number, vendor, parts count and parts comments.
Vendor Parts Order POR38321

Print or email a part order document to be sent to the supplier automatically. The report contains Buyer, Order, Vendor and Ship To information as well as Required and ETA Dates, Ship Via method, Priority, FOB point, Collect/Prepaid data and Shipping Instructions if available. The purchase order detail includes Line number, Quantity, Unit of Measure (UM), Item number, Description, Unit Price, Extended Price, and Total Value of the order including Freight if available.
Parts Order Receiver PAR156/A

Parts Order Receiver prints to user’s default printer only if Print Parts Order Receiver Report is enabled on the System Settings - Location screen.

-Or-

Parts Order Receiver duplicate goes to the printer selected in the Duplicate Parts Order Receiver Printer dropdown on the the System Settings - Location screen. If no printer is configured, no duplicate is printed for the branch.
Parts Reserved for W/O but Never Invoiced CCP018 Displays parts posted to parts requisition, but not yet processed by a billing run.
PO History PARPOHIS01 Displays purchase order receipt history transactions.
Price Matrix Impact Report PAR169 Displays impacts to parts pricing prior to applying updated price matrix.
Pricing Matrix Report PAR167 Displays configuration of parts price matrix.
Protected Inventory Report PAR184 Displays parts inventory configured with protection codes/periods.
Re-Order Listing PAR190 Displays parts suggested for reorder based on stocking parameters.
Sales Analysis Journal GL9300 Displays summary of journals produced during sales analysis processing (typically billing run).
Sales Analysis Allocation Register BIL900 Displays detailed register of sales transactions journals during sales analysis processing (typically billing run).
Sales Analysis Allocation Summary BIL919 Displays summary register of sales transaction journals, by department, during sales analysis processing (typically billing run).
Select/Update - Parts WUPDRPT Displays selection criteria used during parts mass update.
Stock Check PSPSC01 Displays quoted on-hand quantities vs actual on-hand quantities.
Stock Transfer # CSO012 Displays detailed listing of branch stock transfers.
Surplus Analysis - Non Returnable PAR034-010 Lists non-returnable surplus on-hand parts.
Surplus Analysis - Returnable PAR034-100 Lists returnable surplus on-hand parts.
Surplus Returns PAR094 Lists parts suggested for surplus on-hand return.
Type Code Information PAR206

Provides an analysis for the parts department's performance by parts type code within each vendor. See Type Code Information.
Vendor Parts Listing WFMAP01C Prints a list of vendor parts, cross referenced by vendor, part number and vendor part number.
Weekly Transfer Report PAR188 Lists suggested stock transfers between branches.
Work Order Details WPSPLB

Printed from the Parts and Labor Billed tab, this report outlines the parts and labor charges on the selected work order.

If the Show Cost On Work Order Details (WPSPLB) Report switch is deactivated on the Authorization List For User Security screen, the Cost, Extended Cost and Profit columns are omitted from the report.

Security: 831 - Product Support Parts Reports

Revision: 2024.10