Part Stats - Inventory Account Rework

KB 2940, Release Note, 2/10/2025

In version 10.20.1 and above, we have restructured the Inventory Account, moving it from the Price Code level to the Source level. As a result, the accounting process will be slightly different since it is no longer tied to the Price Code. Dealerships can rest assured that this update will integrate into their operations without any changes in behaviour.

IMPORTANT NOTES:

When upgrading to version 10.20.6, existing Dealerships will see their Source GL Distribution values automatically populated into the Source along with Core. However, if your Dealership's process requires the core return to default to a separate Inventory account, you will need to update the Core account to the appropriate one.

For New Installs, the Dealerships Inventory GL Accounts must be entered manually, and the Core account must also be updated into the Source.

This document details the changes in setups.

Set Ups

Price Code Maintenance

In the Price Code maintenance screen, Inventory and Other Accounts have been removed from the GL Distribution and the Source Distribution sections. These Account settings have now migrated to Part Sources. The configuration of the Source Distribution for Sale and Cost Accounts still needs to be done within the Price Code.

To access this feature, follow the path: Fixed Ops > Parts Invoices > Maintenance > Parts Price Codes

Source Maintenance

The Source maintenance screen now includes two new columns, Inventory and Core Return , providing a clear view of the associated Inventory and Core accounts for each source. When viewing the Source, the Inventory Account and Core Account can be found under the Description field.

Notes: The Core Account is used if dirty core returns do not follow the parent part inventory account. This account will need to be added to all sources that would follow this process.

Due to these accounting changes, source name codes can no longer be modified.

To access this feature, follow the path: Parts > Parts Stats > Maintenance > Advanced > Source

Manufacturer/ Supplier Maintenance

The Manufacturer/Supplier maintenance screen has been updated, with significant changes made to the bottom section. The Tax, State Tax, fields have been removed, while the Accounts Payable field has been relocated to the top section. The bottom section now focuses on Receipt and Return Integration as well as Divisional Transfers.

To access this feature, follow the path: Parts > Parts Stats > Maintenance > Manufacturer/Supplier

Previously, setting up Divisional Transfers required modifying each Manufacturer to include an Inventory Account in the bottom section. This is no longer necessary, as it will now directly look at the Source.

Fixed Ops Control File Settings

All functionalities remain unchanged. Receipt Integration continues to operate as usual, and the Fixed Ops Control File setting will still allow the use of Supplier from the Header. The Posting Type settings (Clearing or Payable) in Manufacturer/Supplier settings also remain unchanged.

If Receipt Integration is not configured for the Manufacturer/Supplier, it will still default to none. The main change is the removal of the Inventory Account setting.

Another change implemented is a setting in the Fixed Ops Control File, specifically pertaining to billing out CORES and using its Parent Source to determine the GL Account.

We have eliminated the Core Charges to use Parent Source Distribution setting from the Control File and standardized this behavior for all Dealerships. This will now be enabled universally, it will no longer be configurable.

All Receipt Integration functionality will continue to interface with Accounting seamlessly, maintaining the same operational flow.