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
