Release Notes for Keystone 5.0.x

Release 5.0.2.0 - 5/30/2025

Services

Application Server

Fix issue with generating out-of-balance G/L transactions when posting an in-balance G/L batch.

Release 5.0.1.0 - 5/23/2025

Accounts Receivable Module

Products Maintenance

Fix issues looking up product codes containing plus signs (+).

General Ledger Module

Import Payroll Transactions

When importing G/L transactions include only the transactions for the payroll run number being imported.

General

Company Database

Updated to version 25.08.

General

Fix handling of URL parameters in ghRestProvider.

Services

Device Server

For Keystone Online dispatch event notification, always send the "ticket" object for VERSION=2 (regardless of status.)

Add "GA" as a supported state for HaulHub.

KServer Windows Client Device API v2

Modify "dispatchevent" endpoint to include "JobKey" field in "Ticket" object.

Keystone Relay

Log error message if the HybridConnection doesn't exist and loop until INI file settings are changed.

Kserver Datatables API

Add "GA" to the "dotstates" data table.

Release 5.0.0.0 - 5/1/2025

Dispatch Module

Order Maintenance

When using the "Quoted Line 1" product lookup option, do not include products restricted to the customer in the drop-down list on the first detail line.

When switching from an order with GPS coordinates to one without, or vice versa, or to an order with different GPS coordinates, the Plant Id dropdown would not select the correct plant when typing in the Plant Id.

Re-Print Tickets

Allow re-printing of all dispatch tickets whether from the plant, office or ticket history tables.

Schedule

Display correct "Qty Ord" on the schedule after a shipped load is edited (where the quantity shipped is changed) using the right-click->Edit Ticket option.

When a truck is swapped for a pre-ticketed load, move the load to Begin Load status.

Do not allow a truck in Returning status that has been pre-ticketed to be swapped.

Do not allow a truck to be swapped to itself.

Ticketing Module

On Hand Inquiry

Orders, In-Stock and Available fields now reflect today's orders and future orders.

Re-Print Tickets

Allow re-printing of all ticketing tickets whether from the plant, office or ticket history tables.

Accounts Receivable Module

Customer Sales Report

Add two new report sequence options "Profit % This Year (Descending)" and "Profit % This Month (Descending)."

Customers Maintenance

Record field change events for "Print Dispatch Ticket" and "Print Ticketing Ticket" fields.

Inventory Transfers

Do not change the Qty On Order value for either product (Xfr Out/Xfr In) when posting the batch.

Job Prices Maintenance

Fix exception when deleting a job.

Print Invoices

Use the first active invoice form (instead of the default ARINV.FRM) when the ARINV form in the database is marked inactive.

Products Maintenance

When moving between products, the "Profit" value on the Mix Design tab does not update.

Required and Orders fields on the Inventory tab now reflect today's orders and future orders.

Query Export

Fix exception "EDBClient" when deleting a query.

Re-Print Invoices

When checking the "Use alternate form" checkbox or changing the selected form, update the Printer Name on screen to reflect the new selected printer.

Use the first active invoice form (instead of the default ARINV.FRM) when the ARINV form in the database is marked inactive.

Ticket Inquiry

Fix exception "EOleException: -1 is not a valid value for field Slump: The allowed range is 0 to 25" at startup or when viewing a ticket with a negative batched slump value (introduced in 4.6.1.1.)

Fix exception "EDatabaseError: Field VOID_SESSION_NO not found" when moving off a void ticket using OK or PgUp/PgDn (introduced in 4.7.3.5.)

Quote Module

Quote List

Add requested sequence options.

Add selection by File #.

Add File # column to summary/detail reports.

Quote Maintenance

When creating an order while booking/rebooking a job, properly assign the current SessionNo and create a new TransNo for the new order.

Accounts Payable Module

Invoice Register

Fix the ""Material Usage Report"" to convert the quantity/quantities from the component U/M from the product structure to the component product U/M.

Purchase Order Module

P.O. Receipts Maintenance

Reverted the "fix" from 4.7.5.4 when deleting a P.O. receipt.

General Ledger Module

Import Payroll Transactions

Updated to support multiple legals under one client.

The Payroll Run dropdown list will now include the pay group name.

Performance improvement when retrieving G/L data from iSolved.

When building the list of payroll runs, include all runs between 1 year in the past to 1 year in the future.

Add system option to optionally consolidate C/M check/dirdep transactions by Check Sequence.

System Menu

Company Restore

Fix exception "EOleException: bad parameters on attach or create database" when restoring with the "Preserve current company data" option checked.

System Option Maintenance

Modify hint for iSolved API Credentials option to indicate that LEGAL_CODE may be required.

Utilities

DataScope

Fix exception "EDBClient" when deleting a query.

System Menu

When adding the "ADMIN" user on a new installation, set the default password.

General

Keystone Setup

Delete obsolete files when updating an existing Keystone installation.

System Database

Updated to version 6.02.

System Map

Fix several issues with Route map display failing to appear.

System Menu

Reduce delay when closing menu.

Windows Client

Add authorization key to all KServer API calls.

Modified sales tax calculation to properly handle a negative taxable amount.

Fix issue where window handles with a value greater than a 32-bit unsigned integer would cause errors.

Change KServer Windows Client System Database API from v1 to v2.

Ensure that the Application Server "ping" is only executed once per client application.

Services

Application Server

Avoid calling KServer dbsuspend/dbresume when upgrading the system database.

Fixed not properly setting the system Serial # when the server crashes/is killed and restarts automatically.

Update "ksrelay.ini" settings when loading license information.

Reload internal copy of license information whenever changes are posted to the license table.

Add "ResetCompany" method (called during AddCompany/DeleteCompany or when a company is changed.)

When a new ticket is added, use the Last Change datetime value as the StatusDateTime value.

When changing the load status to End Load, fix data when a pre-ticketed load never gets an At Plant status from its previous load.

Device Aggregator

Add "ksclient" authorization logic when calling KServer APIs.

Move KServer "notifyordercomplete" endpoint from Driver API to Windows Client Dispatch methods API.

Device Server

Add order location notify device for Keystone Online.

Dispatch Order Complete Notification

Move KServer "notifyordercomplete" endpoint from Driver API to Windows Client Dispatch methods API.

KServer Driver API

Add "notifyorderlocation" endpoint.

KServer External AICrete API

Add "exaicrete" authorization name.

KServer External AICrete Datatables

Common datatables unit for AICrete APIs.

KServer External Salesforce API v2

New API for Salesforce which requires authorization header.

KServer External Stonemont API v2

New API for Stonemont which requires authorization header.

KServer External Stonemont Datatables

Common datatables unit for Stonemont APIs.

KServer Keystone Online APIs

Add "ksonline" authorization name.

KServer Windows Client API

Remove "ksclient" authorization.

KServer Windows Client Company Database API

Add "ksclient" authorization.

KServer Windows Client Device API v2

Add "loadautoreturn" endpoint to auto-return a single load.

KServer Windows Client Device Autorun API v2

Fix "trxsync" endpoint so it actually runs.

Change "loadautoreturn" endpoint to "processautoreturn".

KServer Windows Client Dispatch methods API

Add endpoints "notifyordercomplete", "notifyorderlocation", "notifyorderroute" and "updateordcmpnotify."

KServer Windows Client Doc Database API

Add "ksclient" authorization.

KServer Windows Client Driver Autorun API

Fix "ordcmpautonotify" endpoint to properly execute the "notifyordercomplete" endpoint which is in a different root URL.

KServer Windows Client Quote Methods API

Fix "createorder" endpoint to properly assign SESSION_NO and TRANS_NO for the new order, and to assign JOB_SESSION_NO and JOB_TRANS_NO.

KServer Windows Client Quote Reporting API

Add FILE_NO parameter to QTSummaryQuoteList endpoint.

KServer Windows Client System Database API v2

Add "ksclient" authorization.

Add "validate" parameter to "dbrestore" endpoint.

KServer Windows Client Ticketing Lookup API

Fix "rdmTIPlant/cdsKey" endpoint to be sequenced by Plant Id.

Keystone REST Server (KServer)

Fix issue when restoring a company database, where the event alerter database connection was not closed before the restore operation tried to drop the database.

Updated to process authorization header.

Carry authorization header forward into sub-maps.

Remove "AuthRequired" config option.

The "AutoRun" manager will now be shutdown before the server is destroyed.

Add support for order location notification to the KDeviceCmd action.

Change default value of configuration option "LocalAuthRequired" to True.

Rollback all database changes for the request if an "exception" action was executed.

Add "KCompanyReset" action.

Delay initialization of request handling until the server has fully started.

Stop processing requests at the start of the server shutdown process.