Release Notes for Keystone 3.4.x

Build 3.4.6 - 10/26/2018

Enhancements

A/R Email Invoices

Add new tags [CompanyName] and [InvoiceNo].

A/R Email Statements

Add new tag [CompanyName].

Dispatch End of Day

For Export Ticketing locations, move tickets into sales history after tickets are processed.

Dispatch Order Maintenance

Add "Products" checkbox to Advanced Copy form.

Dispatch Schedule

Add user option to increase the height of schedule grid rows (Options->Schedule Row Height.)

Add Customer P.O. as an available column on the schedule grid.

Export Tickets to Accounting

Support up to 99 products per ticket for EXF export.

Payroll Import Timecards

Add support for TotalPass timeclock by Icon Time Systems (contact support if you need this feature.)

Payroll Tax Library

Updated to 2018-R11 version.

General

In any date field that is not within a grid, the Up/Down arrow keys may be used to decrease/increase the date value by one day if it is not blank.

Improve readability of Security Code dialog.

Device Aggregator

When processing batch results, forward batch ticket data along with actual batch weights to QC batch device.

Device Server

Add support for Verifi status device.

Add support for Verifi batch device.

KServer

Add support for cached queries.

Add ability to implement customer-specific endpoints.

Corrections

A/R Print Statements

Save "Include Inactive" checkbox setting from run to run.

Enter Inventory Balances
Inventory Production Receipts
Inventory Purchase Receipts
Inventory Requirements Report
Inventory Status Report
Inventory Transfers
Inventory Valuation Report
Miscellaneous Inventory Transactions
Physical Inventory Entry
Physical Inventory Work Sheets
P.O. Receipt Entry
P.O. Receipt Maintenance

Validate Time field upon entry.

Dispatch Order Time/Yardage Analysis Report

Expand width of Qty Sold column.

Dispatch Schedule

When using Quick Ticket feature, product drop-down does not filter properly for plant products.

When using Quick Ticket feature, scale weight interface does not pop-up in Qty Sold field.

A/P Invoice Vouchering

Set discount date and discount % when using down arrow after entering Gross Amount.

P.O. Receipt Entry

Sort P.O. Number drop-down list by P.O. Number only.

Payroll Import Timecards

Ignore blank records in the timecard import file.

System Menu

When closing the menu, wait a maximum of 60 seconds for other Keystone windows to close.

Device Server

Log exceptions in Verifi Batch and Status devices without terminating device thread.

---

Build 3.4.5 - 9/7/2018

Enhancements

A/R Customer Maintenance
Quote Prospect Maintenance

Show both customers and prospects in the Customer Id drop-down list.

A/R Quick Ticket Entry

When a conversion error happens while posting a ticket batch, display the Cust Id and Ticket No that caused the error.

Dispatch Batch Weights Report

Add user option to show variances.

Add "Mix Name" to selection criteria.

Dispatch Order Maintenance
Dispatch Ticket Printing
Ticketing Order Maintenance
Ticketing Ticket Printing

Add new system option to restrict the ability to enter non-existent Job Ids.

Dispatch Order Time/Yardage Analysis

Print Customer Name after Customer Id.

Email Dispatch Orders

New option added to the Dispatch menu which will email orders to customers for a specified date (contact support if you need thie feature.)

Email Ticketing Orders

New option added to the Ticketing menu which will email orders to customers for a specified date (contact support if you need this feature.)

Ticketing Order Maintenance

Add Job Lot to Order Id drop-down.

Quote Maintenance

Add Preview button to preview the quote form.

A/P Check Register
A/P MTD Check Register

Add user option to print the current vendor name if it doesn't match the check vendor name.

A/P MTD Check Register

Add user option to show only checks with vendor name discrepancies.

P.O. Receipt Entry

Ask if user wants to print the receipt when OK button clicked.

Session Log

Always show status information, even when showing an exception.

General

Add ability to show/hide tabs in Keystone options based on security settings.

KServer

When logging that a query has finished, include the number of records retrieved or affected.

KServer Version API

Add "config" endpoint.

Corrections

A/R Product Price Changes

Update Last Change User and Date/Time fields when job price changed.

A/R Quick Ticket Entry

Fix to copy all three Tax Code fields from the ticket batch table to the office ticket detail table.

A/R Void Invoice
A/P Void Invoice

Prevent double-voiding when two users attempt to void the same invoice at the same time.

Dispatch Order Time/Yardage Analysis

Fix to print Qty Sold total under the Qty Sold column.

Dispatch Schedule

Include closed orders in schedule screen totals.

Exclude cancelled orders from schedule screen totals.

Quote Maintenance

Prevent "book job" for an inactive quote.

The "Lookup Inactive Quotes" menu option has no effect.

A/P Void Check

Prevent double-voiding when two users attempt to void the same check at the same time.

G/L Financial Statements

Fix tab order on Options tab.

P.O. Receipt Entry

Remove the Print button.

KServer

Generate descriptive exception message when executing a local query with a missing source dataset.

KServer Dispatch API

ScheduleByCust, ScheduleByPlant, ScheduleBySls, ScheduleOrders and ScheduleOrderLoads endpoints: Fix handling of IncComplete parameter (previously was always treated as False.)

ScheduleByPlant endpoint: Handle cross-shipped loads properly (always use order plant number.)

KServer FX API

Fix dispatchtime and tickettimes endpoints: BATCH_END_DT may not be present in all datasets.

---

Build 3.4.4 - 8/27/2018

Enhancements

Payroll Workers Compensation Report

Add ability to sequence and select by Department with subtotals.

KServer FX API

Added sales $ field to kpi endpoint.

Corrections

A/R Credit Reference Letters

Aging totals are no longer including service charges (they should be.)

Dispatch Order Maintenance

Add original error message to "Another user has made changes to the loads" message.

General

Include correct time when sending email (previously was using UTC time.)

Device Aggregator
Device Server

Log unhandled main thread exceptions.

Device Aggregator

Log error message when processing batch results where the device does not have a plant associated with it.

Log error message when processing batch status where the device does not have a plant associated with it.

Fix variant conversion exception when processing batch results and batch status.

Device Server

For batch controls using Trimble XML protocol, fix incorrect TICKETTIMEZONEOFFSET value during daylight savings time.

Use UTCToLocalTime function in place of TZOffsetFromUTC function.

KServer Customer Portal API v1

Fix getorderdetails endpoint (missing setparam, introduced in 3.4.2.4.)

KServer Customer Portal API v2

Fix OrderDetails endpoint (missing setparam, introduced in 3.4.2.4.)

Fix CurrentOrders endpoint (NextLdDt incorrect value.)

KServer Dispatch API

Fix ScheduleOrderLoads endpoint (missing setparam, introduced in 3.4.2.4.)

KServer GPS API

Fix truckticketinfo endpoint (missing setparam, introduced in 3.4.2.4.)

KServer On-Delivery API

Fix truckticketinfo endpoint (missing setparam, introduced in 3.4.2.4.)

KServer On-Demand API

Fix loadgpslocation, schedulecustorderloads, scheduleplantorderloads endpoints (missing setparam, introduced in 3.4.2.4.)

KServer Stonemont QC API

Fix xprojects, xprojectlist endpoints (missing setparam, introduced in 3.4.2.4.)

---

Build 3.4.3 - 8/14/2018

Enhancements

A/R Cash Posting
A/R Inquiry

On the invoice history screen, the Posting History will fill the entire form if there is no Ticket History for the invoice.

A/R Email Invoices
A/R Email Statements
System Menu

Add "Send Spacing" field to Email Configuration form. This can be used to add a delay when sending bulk emails (invoices, statements) through Keystone.

Payroll Tax Library

Updated to 2018-R9 version (MD and NJ.)

KServer

Add "setparam" field property.

The "hidden" field property now implies the "setparam" property.

KServer Dispatch API

InvoiceHistory endpoint: Break out ticket products to a separate JSON array.

LoadGpsLocation endpoint: Add TruckClass field.

Add SlsId parameter to ScheduleByPlant endpoint.

Add TicketNo field to ScheduleOrderLoads endpoint.

Add "CustNo" and "CustName" fields to ScheduleOrders endpoint.

KServer FX API

Add materialrequiredbyhour and batchvariation endpoints.

Add workdays data array to kpibud endpoint.

Add ksslsbud endpoint.

Corrections

A/P Aged Trial Balance
A/R Aged Trial Balance

Fix monthly aging when using last day of the month as the aging date (introduced in 3.3.0.4.)

A/R Cash Posting

When posting an open credit with A/R By Plant option active, store the plant's default division number in the credit invoice.

A/R Import Tickets

Batch tickets imported for an inactive customer do not show product description and unit of measure.

A/R Invoice Register
A/R MTD Invoice Register

Fix incorrect totals issue when a tax locality cannot be located for the tax transaction date.

A/R Print Invoices
A/R Reprint Invoices

Fix SALES_TAX_1 and NONTAXABLE_1 fields to include case where a tax locality cannot be located for the tax transaction date.

A/R Product Maintenance

Fix exception "EInvalidOperation: Cannot focus a disabled or invisible window" when changing Product Type from Ingredient to Other.

Change "Send to Batch" checkbox on Mix Design tab to "Send Mix w/Ticket."

A/R Product Class Maintenance

Change "Send to Batch" checkbox on Defaults tab to "Send Mix w/Ticket."

A/R Truck Maintenance

Changing the GPS Date does not refresh the GPS status information (introduced in 3.4.)

Dispatch Batch Weights Report

Do not triple report ingredients for tickets associated with voided/reversed invoices.

Dispatch Order Maintenance

Recalculate order load times when the load size is changed.

Ticketing Order Stack

Ensure that application server and database connections are active when refreshing the Order Stack.

System Menu

Fix scrollbar appearance to the way it was prior to version 3.4.

Device Aggregator

Close company database connections immediately when no longer needed.

Device Server

When processing returned concrete message in Integra XML status module, set the status code to "Returned Concrete" so the message will not be ignored (introduced in 3.3.1.3.)

KServer

Fix WorkDaysInMonth() function.

Fix Access Violation when executing certain GET endpoints (introduced in 3.4.2.4.)

KServer Customer Portal API v1

Fix getcurrentorders endpoint (introduced in 3.4.2.4.)

KServer Dispatch API

Fix "Completed" field value in ScheduleOrders endpoint.

Fix ScheduleByCust, ScheduleByPlant, ScheduleBySls and Ticket endpoints (introduced in 3.4.2.4.)

KServer GPS API

Fix truckticketinfo endpoint (introduced in 3.4.2.4.)

KServer On-Delivery API

Fix truckticketinfo endpoint (introduced in 3.4.2.4.)

KServer On-Demand API

Fix schedulecust, scheduleplant, schedulesls and ticketinfo endpoints (introduced in 3.4.2.4.)

KServer Quote API

Fix Prospect and Quote endpoints (introduced in 3.4.2.4.)

---

Build 3.4.2 - 7/3/2018

Enhancements

Dispatch Print Orders

Now includes only orders for Dispatch plants.

Ticketing Beginning of Day

Add warning message when "Purge Inactive Orders" box checked.

Ticketing Print Orders

Now includes only orders for non-Dispatch plants.

Payroll Tax Library

Updated to 2018-R7a version.

KServer

Add ability to set "authorization required" by port number.

Add validation of authorization token.

Add ToBool() function.

Customer Portal API: Add version 2.

Dispatch API: Modify to use ToBool() function.

FX API: Modify 'dispatchtime' endpoint to include 'targetminutesperload' field.

Corrections

A/R Job Price Maintenance
A/R Plant Maintenance
Dispatch Order Maintenance
Quote Maintenance
Ticketing Order Maintenance

Fix Windows error 193 when attempting to open the map.

Dispatch Cash Payment Entry

Handle products that use Auto Qty=Y or O correctly when calculating Extended Price for the receipt.

Dispatch Order Maintenance

Handle products that use Auto Qty=Y or O correctly when calculating Extended Price for the print function.

General

Eliminate Access Violations when closing Keystone forms.

Fix black background on server connection indicator.

KServer

FX API: Fixes to tickettimes and dispatchtime endpoints.

FX API: Fix root URI.

---

Build 3.4.1 - 6/25/2018

Enhancements

A/R Customer Maintenance

When a new Credit Warning is entered for a customer, force the Show Warning checkbox to be checked.

A/R Trucking Report
A/R Month End Trucking Report

Add "Owner" to selection criteria.

Dispatch Schedule

Add "Owner" as an available field in the Clocked In Trucks list.

Dispatch Truck Demand Graph

Save selected Plant Id for Plant Graph from run to run.

Payroll Employee Maintenance

Generate Pay Rate field change event when a new employee is added.

Payroll Tax Library

Updated to 2018-R7 version (ID, KY, MO, NM states.)

General

Add visual indicator to show whether the company database is connected.

Device Server

When sending mix design to a ULINK batch control, support up to 20 characters for the ingredient IDs.

Company Database

Allow for 20 character Mix and Ingredient Ids in dispatch batch weight tables.

KServer

Add DayOf, MonthOf, WeekOf, YearOf, WorkDaysInMonth functions.

Add functions Div(), Mul(), Round() and Sub().

Add Keystone FX API.

Corrections

A/R Credit Reference Letters

Fix Credit Terms dropdown list not working (introduced in 3.3.1.8.)

Fix to print credit reference for customer with no invoices.

A/R Customer Maintenance

Fix to show History tab at startup.

Dispatch Order Maintenance

Fix order load spacing calculation (use "Spacing" if specified, otherwise use "Pour Rate" X "Load Size".)

Dispatch Ticket Printing
Ticketing Ticket Printing

When new ticket forms are added, populate the Printer Alias list on the Printer Setup dialog (introduced in 3.3.0.12.)

Web Update

Fix Azure download to avoid connection timeout errors.

Show progress bar when downloading update file.

General

Scrollbar appearance has been restored to its pre-3.4 appearance.

Ensure company database connection remains open when executing long-running code blocks (this eliminates many Access Violation exceptions.)

Show correct Thread Id in the system log.

When closing a Keystone option do a limited open of the company database if necessary.

Fix logging to record date/time log message is generated instead of when it is written to the log file.

Prevent multiple forms from calling the DB cleanup logic for a given Keystone option.

Prevent DB cleanup during opening of company and document databases.

Application Server

When creating a new database connection in the connection pool, create a default transaction.

Fix multithreading issues where multiple threads simultaneously attempt to run different queries against the same system database connection (this was causing several strange errors within the server.)

Fix logging so queries will be logged when LogEventTypes is set to * (ALL.)

Raise exception if attempt to lock system database fails after 60 seconds.

KServer

Stonemont QC API: Uppercase Customer, Product and Plant Ids.

Stonemont QC API: Modify materials endpoint to use MIX_UMS if specified and fall back to UNIT_OF_MEASURE if not.

Dispatch API: Cleanup several endpoints.

Dispatch API: Fix ScheduleOrders endpoint to return correct results.

---

Build 3.4 - 5/31/2018

Enhancements

A/R Cash Posting
A/R Customer Maintenance
A/R Inquiry

Support multiple forms for Credit Reference Letters and Dunning Forms.

A/R Credit Reference Letters

Add Division selection.

Add ability to lock the report to a specific division.

Support multiple forms.

A/R Driver Maintenance
A/R Truck Maintenance

Add "Mode" column to GPS status grid.

Performance improvement when loading GPS status data.

A/R Open Ticket Stack
A/R Quick TIcket Entry
A/R Ticket Maintenance
Dispatch Order Maintenance
Ticketing Order Maintenance

Add new price source code (eXternal) that prevents the product from being re-priced.

A/R Product Maintenance

Add "UPC Code" to product F4 search.

Dispatch Order Maintenance

Add system option to show customer notes tab.

Dispatch Schedule

The Clocked In Trucks grid can now show trucks with custom modes before/after trucks with no modes. Additionally it will sequence these trucks starting with the truck that has been in that mode the longest.

Add custom mode date/time column to Clocked In Trucks grid (displays as minutes in custom mode.)

Add flyover hint to Clocked In Trucks grid for custom mode column.

Add flyover hint to Clocked In Trucks grid for truck status column.

Add "truck capacity" as an optional field on the Available Trucks grid.

Dispatch Ticket Printing

Add system option to prevent use of returned concrete at ticketing time.

Accept Payroll

Record check numbers in G/L Transactions table.

Payroll Tax Library

Updated to 2018-R6 version (ID, KY, UT.)

Form Reports

Now supports up to 10 images per form.

Backup/Restore

Improve data transfer speed between client and server.

Application Server

Add logging of active COM objects at termination.

Device Aggregator

Add new status device parameter to process (default) or ignore returned concrete.

Device Server

Now supports up to 20 character product codes for ULINK-based batch controls (please contact support if you need this feature.)

Add "Returned Concrete" and "Add Water" status codes.

KServer

Dynamic SELECT queries now build a WHERE clause.

Support empty PostData for non-SELECT queries (DELETE.)

Support connection pooling for database connections.

Quote API: Add ApprovalCodeList, ApprovedQuoteList endpoints.

Quote API: Modify ApprovedQuoteList endpoint to include the same fields as the QuoteList endpoint.

Quote API: Add JobClassList endpoint.

Quote API: Add GetProductPrice endpoint.

Quote API: Add PlantId, ProdType, Sellable and IngType filters to ProductList endpoint.

Corrections

A/R Cash Posting
A/R Inquiry

Reset grid column sorting and filtering when moving to a new customer.

Dispatch Batch Weights Report

Ignore batch weights for VOID tickets.

Dispatch Schedule

After setting a truck mode, refresh the order list.

A/P Aged Trial Balance

Fix broken report layout (introduced in 3.3.0.10.)

Payroll Tax Library

Fix issue where tax period date was always set to today's date.

Query Export

Controls will no longer be scaled when the form is maximized.

Form Maintenance

Fix issue where the tab caption for image #10 would display as blank when the screen is maximized.

General

Fix a form scaling issue.

Application Server

Clean up termination logic for Windows Vista behavior changes.

Improve logging so that messages logged just prior to termination are not lost.

New IB connection pool classes to eliminate threading issues.

Device Aggregator

Ignore truck status messages where the status code is "unknown" or invalid.

Device Server

For Keystone GPS, only process returned concrete when the status code is 17 (returned concrete.)

KServer

Improve logging so that messages logged just prior to termination are not lost.

Read JSON maps from "MapPath" port-specific configuration option.

Fix handling of query date and date/time parameters for local (SQLite) connections.

Always return a valid JSON object after processing a REST API call.

Quote API: Fix inconsistent field names.

Quote API: Fix incorrect "Id" Products field value for Quote GET endpoint.

Quote API: Modify Quote POST endpoint to always mark new contacts as quote-specific.

Quote API: Modify Quote Contact POST endpoint to always mark new contacts as quote-specific.

Quote API: Modify Quote Contact PUT endpoint to never change Contact Type, Entity Id and Entity Sub-Id.

---

Release Notes for Keystone 3.3.x

Release Notes for Keystone 3.2.x

Release Notes for Keystone 3.1.x

Release Notes for Keystone 3.0.x

Release Notes for Keystone 2.9.x

Release Notes for Keystone 2.8.x

Release Notes for Keystone 2.7.x

Release Notes for Keystone 2.6.x

Release Notes for Keystone 2.5.x

Release Notes for Keystone 2.4.x

Release Notes for Keystone 2.3.x

Release Notes for Keystone 2.2.x

Release Notes for Keystone 2.1.x

Release Notes for Keystone 2.0.x

Release Notes for CompuCrete 1.8.x