Parts Utilities

Use the Parts Utilities screen to access utilities for managing parts data.

To open the Parts Utilities screen, navigate to Product Support > Parts > Utilities.

Note:  Certain options may appear only if the associated switch is activated in security system 833.

Options on the Parts Utilities screen are:

Option Description
PARTMAST Import Updates

Opens the Partmast Import screen, allowing you to import a CSV file that updates the PARTMAST file.

All files updated during the PARTMAST import are immediately processed. This feature is for DPM (Deere Dealer Parts Management) only and is not supported for any other users. DPM assumes responsibility for all updates to the parts master using this utility.
Change Parts Information

Opens the Change Parts Information screen, allowing you to change information of a part in the Price Master and Part Master files.

To allow users access to the Change Parts Information feature, turn on the security switch Allow Change Parts Information in system 833.
Increase Miscellaneous Part On Hand

Opens the Increase Miscellaneous Parts on Hand screen, allowing you to adjust a miscellaneous part's on-hand quantity.

When you use this utility in the Receipt History you see a Purchase Order Number of IDQTYCHG.

A miscellaneous part is a part with a vendor equal to GL.
Upload Parts Conversion File

Opens the Upload Parts Conversion File screen, allowing you to add or overwrite the part records stored in the CONVPART file.
Delete Master Price File Records For Vendor Opens the Delete Master Price File Records For Vendor screen, allowing you to delete all part records associated with a specific vendor from the PARTPRC and PRUCONT files.
Upload Parts Cross Reference File Opens the Upload Parts Cross Reference File screen, allowing you to upload your part financial records in CSV format and update your PARTXREF file.
Parts Deletion Run

Opens the Selection Criteria screen, allowing you to delete multiple parts from the system using specific criteria.

Only parts that have no On Hand, On Order, or On Back Order quantities may be deleted. When the Parts Deletion Run is performed, two reports are generated: one listing all the parts that were successfully deleted, and one listing all the parts that could not be deleted.

If selected, these files are checked by the system:

  • SALDET (parts invoicing)
  • PURPART (parts ordering)
  • PARTCNT (inventory count)
  • PARTRET (surplus returns)

If the part is found in any of these files it cannot be deleted. Additionally, this deletion logic applies:

  • If the part has no history records or the history is beyond the retention period specified in the DIVTAB table (Years Of Journal History and Parts Receipt History fields), it can be deleted.

  • If the part does have history records within the retention period, the system checks for an accrual account entry for the part in the PARTHIST file. If an accrual entry exists for the part, it cannot be deleted. This logic was added to ensure that the Inventory Accrual journal details remain complete with all valid details for the parts that may affect the general ledger.

If the part can be deleted based on the criteria noted above, it is removed from these files:

  • PARTCOMM (comments)
  • PARTBIN (secondary bins)
  • PARTDES (description)
  • MEMOS (memos)
  • PARTLIST (related parts)
  • PARTMAST (part master)

Click Close to close the Parts Utilities screen.

Security: 833 - Parts System Options

Revision: 2026.01