New Keystone Releases

NOTE: Items in bold type are NEW features.

Build 4.7.2 - 10/11/2024

Dispatch Module

Order Maintenance

Add ability to initiate sending an email when clicking the new email icon next to an email address on the Contacts tab.

Schedule

Fix "Quick Ticket" logic to incorporate necessary changes for "split order" functionality.

Fix "Quick Ticket" logic to properly set the load number in the ticket.

Fix "Quick Ticket" logic to properly set order fields so that voiding the ticket works correctly.

Fix order load alert messages not working (introduced in 4.5.6.2.)

Add new system option "Split Orders by Load Plant" which controls whether split orders are available or not.

Add Plant Id to status pop-up.

Add optional "OrdPlt" field to schedule grid (Plant Id from order.)

Ticket Printing

Fix exception "Field MM_ADJUST_QTY_FLAG not found" when sending mix design containing mix modifier with ticket.

When loading mix design containing mix modifier properly handle the case where the Adjust flag on the mix modifier component is checked.

Ticketing Module

Order Maintenance

Add ability to initiate sending an email when clicking the new email icon next to an email address on the Contacts tab.

Order Stack

Fix exception "Unknown Parameter KEY" when you edit an order immediately after opening the option, then try to ticket or edit an order after that.

Accounts Receivable Module

A/R Inquiry
Cash Posting
Customer Maintenance
Job Price Maintenance

Add ability to initiate sending an email when clicking the new email icon next to an email address on the Contacts tab.

Customer Maintenance

Do not require Tax Exempt Id for non-taxable customers that are Inactive.

Import Tickets

When reading CSV file, strip the Excel UTF-8 BOM characters from the first record.

Prepare Remote Ticketing Data

Add client-side log messages.

Print Invoices

Modify invoice generation logic to include sequence number when generating sort sequence for the invoicing procedure. (Fixes issues introduced in 4.7.)

Sales Tax Report

Fix exception "cdsReport: Cannot modify a read-only dataset" when the "Include All Tax Entities" box is checked and the "Run Queries in Main Thread" system section option is checked.

Fix exception "EVariantTypeCastError: Could not convert variant of type (Null) into type (OleStr)" when the "Include All Tax Entities" box is checked and the Tax Entity Type is "Locality" and one of the tax localities has a blank description.

Quote Module

Prospect Maintenance
Quote Maintenance

Add ability to initiate sending an email when clicking the new email icon next to an email address on the Contacts tab.

Accounts Payable Module

Vendor Maintenance

Add ability to initiate sending an email when clicking the new email icon next to an email address on the Contacts tab.

General Ledger Module

Batch List

Print transaction second description line if present.

Payroll Module

Tax Library

Updated to version 2024-R10.

General

Company Database

Updated to version 25.02.

System Menu

When releasing locked tickets, clear the Z$ARTGENINVSORT table for the invoice sessions that are released.

When retrieving pending web update, eliminate possibility of endless loop which consumes a large amount of resources in KServer.

Windows Client

Fix auto-task handling to properly set the location of the Application Server (introduced in 4.5.5.1.)

When processing an auto-task, initialize client-side log.

Decrease file chunk size to 1MB when reading/writing files from/to KServer.

When reading file from KServer, raise exception if the response content type is not valid.

When reading file from KServer, raise exception if an attempt is made to read the same file chunk twice.

Services

Application Server

When printing invoices, clear the Z$ARTGENINVSORT table for the current session before generating the invoice sort records.

Keystone REST Server (KServer)

Fix possible memory leak in ActnReadFileChunk and ActnWriteFileChunk methods.

Online Customer Portal API: Modify "invoice" endpoint invoice query to properly calculate NON_TAXABLE_1, 2, and 3.

Windows Client A/R API: Modify query in "rdmARProductStructure/cdsProdStructure" endpoint to include MM_ADJUST_QTY_FLAG.

Windows Client A/R API: Moved query for "rdmARCashRegister/cdsDepositHistory" endpoint into stand-alone SQL file.

Windows Client Dispatch API v2: Modify "rdmDISchedule/cdsGetSchedData" endpoint to add "SPLIT_ORDERS" parameter.

Build 4.7.1 - 9/13/2024

Dispatch Module

Order Maintenance

Fix issue when processing automatic products on a new order with a quoted line 1 product on a job (entering a product code caused the automatic products to be immediately added without giving an opportunity to enter the Qty Ordered.)

Accounts Receivable Module

Cash Posting

Adjust position of Post Allow/Post Cash/Post Disc dialog box to be below/above the invoice being posted to.

Customer Maintenance

Add system option to require Tax Id number to be entered for tax exempt customer (default ON.)

Re-Print Tickets

Fix exception "cdsReport: Field SALES_LIST_PRICE not found" (introduced in 4.6.99.18.)

General

Company Database

Fix conversion from version 24.09 to handle issues when adding new foreign key constraints to ARTCSHDT and ARTINV tables.

Reports

Some reports were not respecting the default font/bold printer options.

Services

Keystone REST Server (KServer)

Add "FormatCurr" function.

Fix "StringReplace" function to handle NULL string parameters correctly.

Add ability to store SQL statements in external ".sql" files using "sqlres" JSON property within a Query object.

FX API: Modify "kpibymo" endpoint to add "workingdaysinmonth" field.

Online Customer Portal API: Add "invoice" endpoint.

Build 4.7 - 8/30/2024

Dispatch Module

Edit Ticket Times

Set associated status reason to "user edit" when one of the eight ticket times is changed.

Display green background on any of the eight ticket times when the associated status reason is "user edit".

Display associated status reason description as a hint for all of the eight ticket times.

Order Maintenance

Add ability to set Tax Authority based on job site GPS coordinates (limited to select states, contact support if you need this feature.)

When a job is entered for a new order or changed for an existing order, update the Pour Rate if the job specifies a Usage Type that specifies a Pour Rate.

Fix scroll wheel not working correctly on Job Id dropdown.

Do not copy the W/C Release Time field when copying an order.

Fix "Another user has made changes..." message when using the "Cancel Order" button on a newly added/copied order.

When cancelling an order, put the cancel reason into the Comment field of the "Order Status" field change event.

Eliminate duplicate "Item Add" event generated when copying order.

Fix "Another User has made changes..." message when saving an existing order where the list of contacts has changed.

Fix issue where field change events were sometimes not generated when saving an existing order where the list of contacts has changed.

Show the W/C Release Time as a hint when you hover on the W/C checkbox.

Print Orders

Add handling for "mix multiplier" auto qty products.

Re-Print Tickets
Ticket Printing

Use ticket form specified in job, then customer, then plant and finally the default form.

Add ability to print the user that originally created the ticket.

Add ability to print customer phone number on ticket.

Add ability to print the 8 load time source fields on tickets.

Add ability to print list price, list totals and savings fields on tickets.

Re-Print Tickets
Re-Transfer Tickets

Add missing fields (Comment 1 and 2, Notes 1 and 2, Order Balance, Amount Tendered, Qty Delivered, Qty Ordered and Order Line Number) when processing office/sales tickets.

Schedule

Do not reset the truck available time if only the custom status is changed.

Do not reset the truck to clocked out status after shipping and then voiding a load.

Performance improvement when scrolling or clicking the order grid.

Add "Plt Name" as an optional grid field.

Fix exception "EVariantTypeCastError: Could not convert variant of type (Null) into type (OleStr)" when attempting to assign one or more trucks to a specific order.

Fix "Assign/Clear Order" truck pop-up option so it assigns the truck to the proper order/plant when a split order is involved.

Fix dragging trucks to next to load grid, dragging next to load items to trucks, and dragging orders to trucks so they respect the truck's assigned order.

Fix truck drop-down list on Swap Truck option so that it shows ALL available trucks (introduced in 4.5.6.1.)

When displaying the Plant Truck Demand Graph, use the "Add Load to Plus Orders" setting from the Dispatch Truck Demand Graph.

Add ability to prevent will-call orders from being shipped (contact support if you need this feature.)

Ticket Printing

Apply mix modifier quantity based on the new "Adjust" setting on the Mix Modifier tab in Product Maintenance.

Fix endless printing when a ticket form CHAINs to another form (introduced in 4.6.2.2.)

Truck Demand Graph

Change calculation of departure time for additional Plus load to be the End Pour time of the last load.

Ticketing Module

Order Maintenance

Add ability to set Tax Authority based on job site GPS coordinates (limited to select states, contact support if you need this feature.)

Fix "Another User has made changes..." message when saving an existing order where the list of contacts has changed.

Order Stack

Add "Qty Ord" as an optional grid field.

Re-Print Tickets
Ticket Printing

Use ticket form specified in job, then customer, then plant and finally the default form.

Add ability to print the user that originally created the ticket.

Add ability to print customer phone number on ticket.

Add ability to print list price, list totals and savings fields on tickets.

Re-Print Tickets
Re-Transfer Tickets

Add missing fields (Comment 1 and 2, Notes 1 and 2, Order Balance, Amount Tendered, Qty Delivered, Qty Ordered and Order Line Number) when processing office/sales tickets.

Ticket Printing

Fix endless printing when a ticket form CHAINs to another form (introduced in 4.6.2.2.)

Accounts Receivable Module

A/R Inquiry

Add Ship To 2, 3 and 4 as optional grid fields.

Fix missing QR code when previewing invoice that contains a QR code.

Fix missing PDF hyperlink when printing to PDF from invoice preview form.

Comparative Customer Sales Report

Add product class selection.

Customer Maintenance

Significant performance improvement when renaming a customer.

Show all customer events except those related to customer prices.

Change "Rename Customer" dialog box to ask for the closing period Month/Year like Month End Processing.

Customer Price Maintenance

Show only those events related to customer prices.

Edit Ticket Times

Set associated status reason to "user edit" when one of the eight ticket times is changed.

Display green background on any of the eight ticket times when the associated status reason is "user edit".

Display associated status reason description as a hint for all of the eight ticket times.

Import Tickets

Handle exceptions when calculating sales tax during ticket import.

Job Price Maintenance

Add "Forms" tab which allows specifying a particular form to be used for tickets with this job.

Add ability to set Tax Authority based on job site GPS coordinates (limited to select states, contact support if you need this feature.)

Print Invoices

Add new invoice separation options: Customer Id, Job Id, Order Id and Customer Id, Job Id, Ship To.

Print Statements

Add Order Id and the four Ship To fields as available fields on the form.

Product Maintenance

Significant performance improvement when renaming a product.

Add "Adjust" column to the grid on the Mix Modifier tab.

Fix to properly set the Sales G/L account when a product is copied and the Sales G/L contains a plant mask.

Change "Rename Product" dialog box to ask for the closing period Month/Year like Month End Processing.

Product Sales by Customer Report
Product Sales Report

Add "Separate by Plant" checkbox which prints separate sections for each plant and does not print grand total.

Re-Print Tickets

Add ability to print the 8 load time source fields on tickets.

Sales Tax Rate Maintenance

Add "Geo State" and "Geo Id" fields to support tax authority lookup by GPS coordinates.

Ticket Inquiry

Show Invoice Number at bottom left of screen for sales history tickets.

Ticket Maintenance

Use job/customer specific ticket form when printing ticket if specified.

Accounts Payable Module

Import Invoices

Set the payment method for imported invoices from the vendor.

Re-Print ACH Stubs
Re-Print Checks

Add Division selection.

Vendor Maintenance

Change "Rename Vendor" dialog box to ask for the closing period Month/Year like Month End Processing.

Cash Management Module

Statement Reconciliation

Properly separate Check No and Check Amount columns based on check key.

Fix deposit history drilldown into combined deposits to show the original checks from all the sessions that were combined into the single deposit.

Record the last change date/time and user when generating combined deposits.

Payroll Module

Tax Library

Updated to version 2024-R9.

Services

Application Server

Record the status reason code when setting one of the eight ticket times when the load status is changed.

Device Aggregator

Do not record batch results if there are no batch results present from the batch device.

Device Server

When processing batch results from a ULINK device, ignore an ingredient if it's name is empty.

Keystone REST Server (KServer)

Add HaulHub/DOT support for these states: ID, KY, TN, WI.

Add new optional boolean parameter to "StringReplace" function for replacing all occurrences of the pattern.

External AICrete API: New API for interfacing with AICrete.

Online Customer Portal API: Modify "ContactInfo" endpoint to add "SecOrders" boolean field.

Online Customer Portal API: Modify "CustomerInvoices" endpoint to eliminate "UMTotals" array and replace with discrete fields in the invoice object (significant performance improvement.)

Windows Client A/R API: Modify "rdmARCashRegister/cdsDepositHistory" endpoint to include SESSION_NO and TRANS_NO fields from ARTCSHHD table.

Windows Client A/R API: Fix "rdmARCashRegister/cdsDepositHistory" query to properly return A/R check information for combined deposits.

Windows Client A/R API: Modify query in "rdmARAllTickets/cdsMaster" endpoint to include INVOICE_NO and INVOICE_DATE fields for sales history tickets.

Windows Client A/R Report API: Fix query in "ARDocumentList" endpoint (now returns the correct ticket when tickets exist in both the plant and sales ticket tables.)

Windows Client Device API v2: Modify "TicketProducts" query in "VehicleStatusUpdate" endpoint to pull ticket detail from all three ticket tables (plant, office, sales.)

Windows Client Dispatch API v2: Fix query in "rdmDISchedule/cdsDIAvailTrucks" endpoint to return LOCK_ORDER_PLANT_NO field.