Difference between revisions of "New Keystone Releases"

From GivenHansco Keystone Help
Jump to navigation Jump to search
 
(67 intermediate revisions by the same user not shown)
Line 4: Line 4:
 
<p><i>NOTE: Items in '''bold type''' are NEW features.</i></p>
 
<p><i>NOTE: Items in '''bold type''' are NEW features.</i></p>
  
==Build 4.0.3 - 11/2/2021==
+
==Build 4.7.10 - 1/3/2025==
  
===General===
+
===Payroll Module===
 +
 
 +
Tax Library
 +
:'''Updated to version 2025-R1c (LA state.)'''
  
Form Reports
+
==Build 4.7.9 - 12/28/2024==
:Fix EAccessViolation exception when printing a CHAINed form.
 
  
===Services===
+
===Payroll Module===
  
Device Aggregator
+
Tax Library
:Fix aggregator lockup issue (caused by Access Violation.)
+
:'''Updated to version 2025-R1b (MT, NC, VT states.)'''
:Fix "Out of Memory" and "Access Violation" exceptions when under heavy load.
 
  
==Build 4.0.2 - 10/29/2021==
+
==Build 4.7.8 - 12/23/2024==
  
===Dispatch Module===
+
===Payroll Module===
  
Keystone Map
+
Tax Library
:Fix "This page can't load Google Maps correctly" when displaying the map or route.
+
:'''Updated to version 2025-R1a (Federal, AR, HI, IN, MN, RI, WV states.)'''
  
===Services===
+
==Build 4.7.7 - 12/13/2024==
  
Application Server
+
===Payroll Module===
:Reverted 4.0 change which reduced maximum memory usage from 3GB to 2GB.
 
  
Device Aggregator
+
Tax Library
:Add more diagnostic information to the log during TCPServerExecute processing.
+
:'''Updated to version 2025-R1 (Federal-preliminary.)'''
  
==Build 4.0.1 - 10/25/2021==
+
==Build 4.7.6 - 12/3/2024==
  
 
===Dispatch Module===
 
===Dispatch Module===
  
 
Order Maintenance
 
Order Maintenance
:Fix exception "EDatabaseException: At End of Table" when deleting an item with two or more detail records.
+
:'''When a contact is selected, populate the order phone number from the contact mobile number (if specified) or the contact phone number.'''
:Do not allow the "Ticket Bal" field to be changed.
+
:'''Add "Show when order accessed" checkbox to Dispatch Warning tab.'''
 +
:'''Carry "Show when order accessed" field from job when copying an order and changing the job on an order.'''
  
 
===Ticketing Module===
 
===Ticketing Module===
  
 
Order Maintenance
 
Order Maintenance
:Fix exception "EDatabaseException: At End of Table" when deleting an item with two or more detail records.
+
:'''When a contact is selected, populate the order phone number from the contact mobile number (if specified) or the contact phone number.'''
  
 
===Accounts Receivable Module===
 
===Accounts Receivable Module===
  
A/R Inquiry
+
Credit Card Pre-Approval
:Do not scale fonts on the History screen when resized.
+
:'''Add "Comment" grid column.'''
:'''Add splitter control to allow ticket history grid to be expanded.'''
+
 
 +
Customer Maintenance<BR>
 +
Job Price Maintenance
 +
:'''Add "Auto Hold Tck" checkbox.'''
 +
 
 +
Customer Maintenance
 +
:'''Add "Alt Address" tab to allow entry of an alternate address (informational only.)'''
 +
 
 +
Import Tickets
 +
:'''Place imported ticket on hold based on the new "Auto Hold Tck" options in Customer/Job Maintenance.'''
 +
 
 +
Job Price Maintenance
 +
:Move "Plant Mix Type" to Dispatch tab.
 +
:'''Add "Show when order accessed" checkbox to Dispatch Warning tab.'''
 +
:Change "Show Dispatch Warning" checkbox description to "Show when job used in order."
 +
:'''Show "File #" on screen (if quote has a File # and is booked as a job.)'''
 +
:'''Add new "Job Search" dialog when F4 pressed in Job Id field.'''
 +
:'''Add blue background (indicating F4 search) to the Job Id field.'''
  
Job Price Maintenance<BR>
+
===Inventory Module===
Ticket Maintenance<BR>
 
Zone Maintenance
 
:Fix exception "EDatabaseException: At End of Table" when deleting an item with two or more detail records.
 
  
Unit of Measure Maintenance
+
On Order Maintenance
:'''Add Batch U/M field.'''
+
:Fix inability to edit "Qty On Order" field for stocked products (introduced in 4.6.)
  
 
===Quote Module===
 
===Quote Module===
  
 
Quote Maintenance
 
Quote Maintenance
:Fix exception "EDatabaseException: At End of Table" when deleting an item with two or more detail records.
+
:'''Generate unique File # when adding a new quote.'''
 +
:'''Show "File #" on screen (if quote has a File #.)'''
 +
:'''Add ability to search on File #, Comment 1 and Comment 2 to F4 Quote Search.'''
 +
:Replaced calendar control on F4 Quote Search dialog to resolve issues with highlighting days containing quotes.
 +
:'''When booking a job, copy the "File #" field from the quote to the new job.'''
  
 
===Accounts Payable Module===
 
===Accounts Payable Module===
  
A/P Inquiry
+
Federal & State 1099 Export
:'''Allow the History form to be resized/maximized.'''
+
:'''No changes for 2024 (ready for 2024 e-filing.)'''
:Do not scale the fonts on the History form when resized.
 
:'''Add splitter controls to allow payment and receipt history grids to be expanded.'''
 
  
 
===Purchase Order Module===
 
===Purchase Order Module===
  
 
P.O. Receipt Maintenance
 
P.O. Receipt Maintenance
:Fix exception "EDatabaseException: At End of Table" when deleting an item with two or more detail records.
+
:Fix EAccessViolation exception when deleting a receipt.
 +
 
 +
===General Ledger Module===
 +
 
 +
Import Payroll Transactions
 +
:Fix exception "EDatabaseError: Expression expected but nothing found" when importing C/M transactions where none of the G/L transactions reference C/M bank accounts.
 +
:Fix summarization logic for C/M impound, invoice and other transactions to process each record.
 +
:When summarizing C/M process all transactions other than Check/DirDep (to include Other transaction types.)
 +
:'''Add system options for Earn and Other G/L Item Categories.'''
 +
:'''Add system option to control G/L consolidation by G/L item category (default is to consolidate all item categories except Check/DirDep/Earn.)'''
 +
:Fix overlapping checkbox "Show Trx Description 2" (introduced in 4.7.4.)
  
 
===Payroll Module===
 
===Payroll Module===
  
Timecard Maintenance
+
ACA 1094/1095 Export
:Fix exception "EDatabaseException: At End of Table" when deleting an item with two or more detail records.
+
:'''No changes for 2024 (ready for 2024 e-filing.)'''
 +
 
 +
Federal & State W-2 Export
 +
:'''Add support for Box 12 code "II" (ready for 2024 e-filing.)'''
 +
 
 +
Federal W-2C (Corrections) Export
 +
:'''Add support for Box 12 code "II" (ready for 2024 e-filing.)'''
 +
 
 +
Tax Library
 +
:'''Updated to version 2024-R12b (KY, ME, MI states.)'''
  
 
===General===
 
===General===
  
Form Reports
+
DataScope<BR>
:Properly establish form settings (such as Detail section height) when the form is changed during the run.
+
Query Export
 +
:'''Add "Quotes" option to the "Restricted to Module" dropdown list on the Save Query dialog.'''
  
Setup
+
PDF Viewer
:Fix so new "cog" icon is used when updating existing Keystone installations.
+
:'''Save/restore form state, size and position from run to run.'''
 +
:'''Show currently loaded PDF filename in form caption.'''
  
 
System Menu
 
System Menu
:Do not delete the local cache folders at startup.
+
:'''When building query menu, add Quotes option to the retricted to module logic.'''
 +
:Take user security roles into account when filtering the query list by module.
 +
 
 +
System Option Maintenance
 +
:'''Add new options under G/L->Import Payroll Options: ISolved GL Category (Earn), ISolved GL Category (Other), ISolved GL Consolidation by Item Category.'''
 +
 
 +
===Services===
 +
 
 +
Keystone REST Server (KServer)
 +
:'''Online Dashboard API: New API added to support Python dashboard.'''
 +
:Windows Client A/R Lookup API: Modify query in "rdmARJobPrice/cdsKey" endpoint to support new F4 Job Search dialog in Job Price Maintenance.
 +
:Windows Client Quote Lookup API: Modify query in "rdmQTQuote/cdsKey" endpoint to support File #, Comment 1 and Comment 2 fields in F4 Quote Search dialog in Quote Maintenance.
 +
 
 +
==Build 4.7.5 - 11/9/2024==
 +
 
 +
===Payroll Module===
 +
 
 +
Tax Library
 +
:'''Updated to version 2024-R12 (Social Security wage base for 2025.)'''
 +
 
 +
==Build 4.7.4 - 11/1/2024==
 +
 
 +
===Dispatch Module===
 +
 
 +
Mix Design Maintenance
 +
:Filter product lookup to include only Mix type products.
 +
 
 +
Order Maintenance
 +
:Replace exception message when using the "Lookup Tax Authority by GPS" option with a user-friendly message.
 +
:Fix automatic product handling to avoid adding automatic products where the product is marked Inactive in Product Maintenance.
 +
:Prevent new orders from being added for inactive customers.
 +
:'''Highlight loads for a future date with a yellow background.'''
 +
:'''When a load override time is prior to the order delivery time, prompt user to choose to schedule at the earliest possible time today or to schedule for tomorrow.'''
 +
:Update the load override time when recalculating loads if necessary.
 +
 
 +
Schedule
 +
:Move "View Order" button to bottom-most position on the Order popup dialog.
 +
 
 +
Ticket Maintenance<BR>
 +
Ticket Printing
 +
:Fix automatic product handling to avoid adding automatic products where the product is marked Inactive in Product Maintenance.
 +
 
 +
===Ticketing Module===
 +
 
 +
Order Maintenance
 +
:Replace exception message when using the "Lookup Tax Authority by GPS" option with a user-friendly message.
 +
:Fix automatic product handling to avoid adding automatic products where the product is marked Inactive in Product Maintenance.
 +
:Prevent new orders from being added for inactive customers.
 +
 
 +
Ticket Maintenance<BR>
 +
Ticket Printing
 +
:Fix automatic product handling to avoid adding automatic products where the product is marked Inactive in Product Maintenance.
 +
 
 +
===Accounts Receivable Module===
 +
 
 +
Customer Maintenance
 +
:'''Add "Web Orders" checkbox to Contacts grid.'''
 +
 
 +
Import Tickets
 +
:Fix automatic product handling to avoid adding automatic products where the product is marked Inactive in Product Maintenance.
 +
 
 +
Job Price Maintenance
 +
:Replace exception message when using the "Lookup Tax Authority by GPS" option with a user-friendly message.
 +
 
 +
Open Ticket Stack
 +
:'''When the Customer Id is changed on a ticket, ask if the ticket should be re-priced.'''
 +
:'''Require a Void Reason when a ticket is voided.'''
 +
 
 +
Print Invoices<BR>
 +
Re-Print Invoices
 +
:'''Add ability to print Order Contact and Phone Number on invoice.'''
 +
 
 +
Ticket Maintenance
 +
:Fix automatic product handling to avoid adding automatic products where the product is marked Inactive in Product Maintenance.
 +
:'''When the Customer Id is changed on the ticket, ask if the ticket should be re-priced.'''
 +
:'''Require a Void Reason when a ticket is voided.'''
 +
 
 +
===Quote Module===
 +
 
 +
Print Quotes
 +
:'''Add ability to print the product's Description 1 and 2 fields on the quote form.'''
 +
 
 +
===Accounts Payable Module===
 +
 
 +
A/P Inquiry
 +
:'''Add "Last Ck#" grid column.'''
 +
 
 +
Select Invoice for Payment
 +
:If user does not have security role permission for C/M, do not show the C/M account balance.
 +
 
 +
===General Ledger Module===
 +
 
 +
G/L Batch List
 +
:'''Add user checkbox for "Show Trx Description 2".'''
 +
 
 +
Import Payroll Transactions
 +
:'''New option added to the G/L Entry/Inquiry menu (used to import transactions from iSolved payroll.)'''
 +
 
 +
===Payroll Module===
 +
 
 +
Tax Library
 +
:'''Updated to version 2024-R11a.'''
 +
 
 +
Timecard Maintenance
 +
:Fix EAccessViolation exception when deleting a paycheck.
  
Windows Client
+
===General===
:When Base-64 encoding do not insert CR/LF every 76 characters.
+
 
 +
DataScope<BR>
 +
Query Export
 +
:Take user roles into account when filtering the query list by module.
 +
 
 +
System Option Maintenance
 +
:'''Add "Import Payroll Options" section to G/L options.'''
  
 
===Services===
 
===Services===
  
 
Application Server
 
Application Server
:'''When an active load status is received from a device for a truck that is not currently on an active load, change the status to Travel.'''
+
:Update G/L, C/M and J/C post batch logic to handle imported iSolved transaction batches.
:'''When a truck is currently on an active load and the status received from a device is earlier than the current status, change the status to Travel.'''
+
:rdmARTicket: eliminate need for separate transaction for qryClearInvSort, qryGenInvSort and qryTktInvSort queries.
:'''When upgrading the database version, keep track of the last successfully run SQL statement within the script. In case of a restart, begin the script at the next SQL statement after the last successfully run statement within the script.'''
 
  
 
Device Server
 
Device Server
:Further changes to PennDOT E-Ticket interface (in progress.)
+
:'''Digital Fleet ticket XML export: add "usage_desc" field.'''
:When sending order route to Keystone Online, fix incorrect JSON string encoding for the route data.
 
  
Keystone REST Server (KServer)
+
Keystone REST Server
:When Base-64 encoding do not insert CR/LF every 76 characters.
+
:A/R Lookup API: Modify query in "rdmARProduct/cdsAutoProductLookup" endpoint to ignore products marked inactive.
 +
:A/R Lookup API: Modify endpoints to add filter parameters: rdmARProduct/cdsLookupFirst, rdmARProduct/cdsLookupLast, rdmARProduct/cdsLookupNext, rdmARProduct/cdsLookupPrior.
 +
:Online Customer Portal API: Modify "ContactLookup" and "ContactList" endpoints to add "SecOrders" boolean field.
  
==Build 4.0 - 10/14/2021==
+
==Build 4.7.3 - 10/17/2024==
  
===New Features===
+
===Payroll Module===
  
Keystone Map
+
Tax Library
:We have developed a completely new map option which will (optionally) allow fastest/shortest routing using HERE truck routing in place of Google Maps routing. This new map requires Microsoft's Edge Chromium browser. Please contact your IT department or GivenHansco support for assistance.
+
:'''Updated to version 2024-R11 (IN counties.)'''
  
Generic Reports w/Export
+
===General===
:As of this version we have moved over 35 Keystone reports to our new KServer-based generic report option. In addition to reducing the load on the Application Server, the generic report option provides Export capability to Excel, Text and HTML files (for most reports.)
 
  
PennDOT E-Tickets
+
System Map
:Pennsylvania will be requiring concrete tickets for PA state jobs to be submitted to the new PennDOT E-Ticketing system. We are currently developing an interface for this and expect to deliver the completed interface by the end of 4Q 2021.
+
:Fix issue where an empty white screen appears when viewing the map.
  
Parent Jobs
+
System Menu
:We have added the ability to establish "parent jobs" for pricing purposes. Previously if you had several jobs that shared the same pricing, you would have to enter the same pricing information in each of the jobs. Now you can enter the pricing information once in a parent job, and link the other jobs to the same parent job.
+
:Fix issue where some anti-virus software (Sonicwall Gateway is one example) may block the transfer of the pending Keystone update to local workstations.
  
Automatic Cloud Backup
+
==Build 4.7.2 - 10/11/2024==
:The automatic scheduled backup program now backs up to the cloud in addition to the local file.
 
 
 
Read-Only Data
 
:As of this version we have identified and moved over 35 data sources out of the Application Server and into KServer. This reduces the load on the Application Server and improves overall system stability.
 
  
 
===Dispatch Module===
 
===Dispatch Module===
 
Driver Time/Yardage Analysis Report
 
:Fix inaccuracy in totals due to unnecessary rounding during detail processing.
 
  
 
Order Maintenance
 
Order Maintenance
:'''Add event when Customer PO field is changed.'''
+
:'''Add ability to initiate sending an email when clicking the new email icon next to an email address on the Contacts tab.'''
:'''Add event when Tax Authority field is changed.'''
 
:'''Add indicator to Price Source if the price is a pending price.'''
 
:'''Pass vehicle parameters (length, width, height, gross weight) to map.'''
 
:'''Retrieve route data from map and save with the order.'''
 
:When copying an order, do not try to do base product translation for comment lines.
 
:Fix issue where job contacts are deleted from the order's job when the Job Id on the order is changed/removed.
 
:Fix issue where customer and job contacts are deleted from the order's customer and job when the order is deleted.
 
:'''Add ability to disable the "Advanced" copy button on the Copy Order dialog (contact support if you need this feature.)'''
 
:When the Print button is clicked, save any pending changes prior to printing.
 
:The Backspace key may now be used to clear the "Cement" drop-down.
 
  
 
Schedule
 
Schedule
:'''Pass vehicle parameters (length, width, height, gross weight) to map.'''
+
:Fix "Quick Ticket" logic to incorporate necessary changes for "split order" functionality.
:'''Retrieve route data from map and save with the order.'''
+
:Fix "Quick Ticket" logic to properly set the load number in the ticket.
:'''Add Options->User Layout menu option to restore user's custom grid layout.'''
+
:Fix "Quick Ticket" logic to properly set order fields so that voiding the ticket works correctly.
:Fix issue where sometimes the truck would not clock in when using Find Truck and then the Clock In option.
+
:Fix order load alert messages not working (introduced in 4.5.6.2.)
:Fix "ERESTException: HTTP/1.1 500 Internal Server Error" when clicking the Edit button while shipping a load.
+
:'''Add new system option "Split Orders by Load Plant" which controls whether split orders are available or not.'''
:'''Add "Will-Call Order" button to order right-click popup menu.'''
+
:'''Add Plant Id to status pop-up.'''
:'''Add "Show Map" button to order right-click popup menu.'''
+
:'''Add optional "OrdPlt" field to schedule grid (Plant Id from order.)'''
:Reload document list when user right-clicks on a truck/ticket.
 
:Disable "View Doc" button if there are no documents available for the ticket.
 
:Reload document grid when user selects "Edit Ticket" from the right-click truck status menu.
 
:Schedule totals now display correctly when there are shipped loads scheduled for a different day.
 
:No longer allows "Mark Order as Complete" function when no loads have been shipped on the order.
 
 
 
Ticket Maintenance
 
:'''Add "Ticket Notes" tab.'''
 
:Do not display "The date is in an unopened period" when accepting a ticket with a payment date in a closed period.
 
  
 
Ticket Printing
 
Ticket Printing
:When creating a ticket from an order, do not try to do base product translation for comment lines.
+
:Fix exception "Field MM_ADJUST_QTY_FLAG not found" when sending mix design containing mix modifier with ticket.
:'''Add option to allow the Customer ID to be changed for an existing ticket (contact support if you need this feature.)'''
+
:When loading mix design containing mix modifier properly handle the case where the Adjust flag on the mix modifier component is checked.
:On the ticket stub screen, do not show the Mix On Board product if the Qty On Board is zero.
 
:'''Add "Ticket Notes" tab.'''
 
  
 
===Ticketing Module===
 
===Ticketing Module===
  
 
Order Maintenance
 
Order Maintenance
:'''Add indicator to Price Source if the price is a pending price.'''
+
:'''Add ability to initiate sending an email when clicking the new email icon next to an email address on the Contacts tab.'''
:'''Pass vehicle parameters (length, width, height, gross weight) to map.'''
 
:'''Retrieve route data from map and save with the order.'''
 
:Fix issue where job contacts are deleted from the order's job when the Job Id on the order is changed/removed.
 
:Fix issue where customer and job contacts are deleted from the order's customer and job when the order is deleted.
 
:When the Print button is clicked, save any pending changes prior to printing.
 
  
 
Order Stack
 
Order Stack
:'''Significantly improved start-up time.'''
+
: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.
:'''Now defaults to showing the last month's worth of orders.'''
 
:'''Add "Order Lookback Date" to Refresh Options screen to control visibility of old orders.'''
 
:'''Add Options->User Layout menu option to restore user's custom grid layout.'''
 
:'''Save "Show Delivery Instructions" option from run to run.'''
 
  
Ticket Maintenance
+
===Accounts Receivable Module===
:'''Add "Ticket Notes" tab.'''
+
 
:Do not display "The date is in an unopened period" when accepting a ticket with a payment date in a closed period.
+
A/R Inquiry<BR>
 +
Cash Posting<BR>
 +
Customer Maintenance<BR>
 +
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.
  
Ticket Printing
+
Prepare Remote Ticketing Data
:When creating a ticket from an order, do not try to do base product translation for comment lines.
+
:'''Add client-side log messages.'''
:'''Add "Ticket Notes" tab.'''
 
  
===Accounts Receivable Module===
+
Print Invoices
 +
:Modify invoice generation logic to include sequence number when generating sort sequence for the invoicing procedure. (Fixes issues introduced in 4.7.)
  
A/R Inquiry
+
Sales Tax Report
:'''Add "Session No" as an optional field on the invoice grid.'''
+
: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.
:'''Add Options->User Layout menu option to restore user's custom grid layout.'''
+
: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.
  
A/R Inquiry<BR>
+
===Quote Module===
Cash Posting
 
:'''Add "Order Id" and "Ship To 1" as optional columns on the main invoice grid.'''
 
:'''Indicate "Portal CC" and "Portal ACH" pay types in the "Check No" column on the main invoice grid.'''
 
:'''Add "PP Status", "PP Status Date", "PP Batch Id", "PP Merch Id", "PP Ref No" and "PP Auth Code" as optional columns on the main invoice grid.'''
 
:'''Add "Price Source" column to ticket history grid.'''
 
  
Aged Trial Balance
+
Prospect Maintenance<BR>
:'''Print plant/division subtotals when printing Control Total and plant/division subtotals boxes checked.'''
+
Quote Maintenance
 +
:'''Add ability to initiate sending an email when clicking the new email icon next to an email address on the Contacts tab.'''
  
Automatic Products
+
===Accounts Payable Module===
:Fix issue where a "not range" (ex: ~01-09) automatic product was not being processed correctly (introduced in 3.6.)
 
  
Cash Posting
+
Vendor Maintenance
:'''Add Options->User Layout menu option to restore user's custom grid layout.'''
+
:'''Add ability to initiate sending an email when clicking the new email icon next to an email address on the Contacts tab.'''
  
Cash Posting Register<BR>
+
===General Ledger Module===
MTD Cash Posting Register
 
:'''On the Bank Deposit add customer portal payment totals (Portal CC and Portal ACH.)'''
 
:'''Indicate "Portal CC" and "Portal ACH" pay types in the "Check No" column on the main report and the Bank Deposit report.'''
 
:'''Add "PP Ref No" column to the main report and the Bank Deposit report.'''
 
  
Customer Maintenance
+
Batch List
:'''Add "Tax Exempt Exp Date" field.'''
+
:'''Print transaction second description line if present.'''
:'''Add "Web CCPay" checkbox to Contacts grid.'''
 
:'''Disable "Web Invoices" and "Web CCPay" checkboxes if there is no default PP Cash G/L account specified.'''
 
:No longer allows a customer with orders to be deleted.
 
  
Default G/L Accounts
+
===Payroll Module===
:'''Add "PP Cash" default G/L account.'''
 
  
Division Maintenance
+
Tax Library
:'''Add "A/R PP Cash" default G/L account.'''
+
:'''Updated to version 2024-R10.'''
  
Edit Open Ticket Times
+
===General===
:'''Add Options->User Layout menu option to restore user's custom grid layout.'''
 
  
Email Invoices
+
Company Database
:Fix recent invoice sessions not showing in Session dropdown list.
+
:Updated to version 25.02.
  
Email Invoices<BR>
+
System Menu
Email Orders<BR>
+
:When releasing locked tickets, clear the Z$ARTGENINVSORT table for the invoice sessions that are released.
Email Statements
+
:When retrieving pending web update, eliminate possibility of endless loop which consumes a large amount of resources in KServer.
:Change caption on OK button to "Send".
 
  
Handwritten Invoice Entry
+
Windows Client
:'''Add "Ticket Notes" tab.'''
+
: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.
  
Import Tickets<BR>
+
===Services===
Open Ticket Stack<BR>
 
Pre-Billing Audit List<BR>
 
Price Exception Report<BR>
 
Print Invoices<BR>
 
Quick Ticket Entry<BR>
 
Ticket Batch List<BR>
 
Ticket Maintenance<BR>
 
Void Invoice
 
:'''Add indicator to Price Source if the price is a pending price.'''
 
  
Invoice Job Corrections
+
Application Server
:'''Add Options->User Layout menu option to restore user's custom grid layout.'''
+
:When printing invoices, clear the Z$ARTGENINVSORT table for the current session before generating the invoice sort records.
  
Job Price Maintenance
+
Keystone REST Server (KServer)
:'''Pass vehicle parameters (length, width, height, gross weight) to map.'''
+
:Fix possible memory leak in ActnReadFileChunk and ActnWriteFileChunk methods.
:'''Retrieve route data from map and save with the order.'''
+
Online Customer Portal API: Modify "invoice" endpoint invoice query to properly calculate NON_TAXABLE_1, 2, and 3.
:Fix issue where customer contacts are deleted from the job's customer when the job is deleted.
+
:Windows Client A/R API: Modify query in "rdmARProductStructure/cdsProdStructure" endpoint to include MM_ADJUST_QTY_FLAG.
:'''Add DOT tab to enter state-specific DOT information.'''
+
:Windows Client A/R API: Moved query for "rdmARCashRegister/cdsDepositHistory" endpoint into stand-alone SQL file.
:'''Add "Parent Job" button to establish parent job relationship.'''
+
:Windows Client Dispatch API v2: Modify "rdmDISchedule/cdsGetSchedData" endpoint to add "SPLIT_ORDERS" parameter.
  
Open Ticket Stack
+
==Build 4.7.1 - 9/13/2024==
:'''Add Options->User Layout menu option to restore user's custom grid layout.'''
 
:Fix EAccessViolation exception when attempting to print a ticket from the edit ticket window.
 
:When repricing tickets, only replace the Customer P.O. on the ticket if the job has a Customer P.O. specified.
 
  
Plant Maintenance
+
===Dispatch Module===
:'''Add "PP Cash" default G/L account.'''
 
:'''Add DOT tab to enter state-specific DOT information.'''
 
  
Product Class List
+
Order Maintenance
:'''Product Class selection is now a checklist.'''
+
: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.)
  
Product Maintenance
+
===Accounts Receivable Module===
:'''Add "SubType" (ingredient subtype) field to product maintenance screen.'''
 
:'''Add DOT tab to enter state-specific DOT information.'''
 
  
Product Sales by Customer Report
+
Cash Posting
:Widen Qty and Amount columns to accomodate larger totals.
+
:Adjust position of Post Allow/Post Cash/Post Disc dialog box to be below/above the invoice being posted to.
  
Quick Ticket Entry
+
Customer Maintenance
:'''Add Options->User Layout menu option to restore user's custom grid layout.'''
+
:'''Add system option to require Tax Id number to be entered for tax exempt customer (default ON.)'''
  
 
Re-Print Tickets
 
Re-Print Tickets
:Fix report sequence not working.
+
:Fix exception "cdsReport: Field SALES_LIST_PRICE not found" (introduced in 4.6.99.18.)
  
Setup Pending Prices
+
===General===
:Change "Apply" button caption to "Post".
 
:'''Added hints to Post and Clear buttons.'''
 
:'''Add Options->User Layout menu option to restore user's custom grid layout.'''
 
  
Summary Sales Report
+
Company Database
:'''Product Class selection is now a checklist.'''
+
:Fix conversion from version 24.09 to handle issues when adding new foreign key constraints to ARTCSHDT and ARTINV tables.
  
Ticket History Inquiry
+
Reports
:'''Add "Ticket Notes" tab.'''
+
:Some reports were not respecting the default font/bold printer options.
  
Ticket Maintenance
+
===Services===
:Change field order on Payment tab to match field order in Cash Posting.
+
 
:Never mark a new ticket as "Priced".
+
Keystone REST Server (KServer)
:'''Display warning when attempting to reprice a priced ticket.'''
+
:'''Add "FormatCurr" function.'''
:'''Add ability to change the Customer ID for an existing ticket.'''
+
:Fix "StringReplace" function to handle NULL string parameters correctly.
:'''Add "Ticket Notes" tab.'''
+
:'''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.'''
  
Unit of Measure Maintenance
+
Print Orders
:'''Add DOT tab to enter state-specific DOT information.'''
+
:'''Add handling for "mix multiplier" auto qty products.'''
  
Void Invoice
+
Re-Print Tickets<BR>
:'''Performance improvement when loading the invoice list.'''
+
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.'''
  
===Quote Module===
+
Re-Print Tickets<BR>
 +
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.
  
Quote Maintenance
+
Schedule
:'''When booking/rebooking a job and selecting the "Create Order from Quote" option, the appropriate Order Maintenance (Dispatch/Ticketing) will be launched with the order just created.'''
+
:Do not reset the truck available time if only the custom status is changed.
:'''Pass vehicle parameters (length, width, height, gross weight) to map.'''
+
:Do not reset the truck to clocked out status after shipping and then voiding a load.
:'''Retrieve route data from map and save with the order.'''
+
:Performance improvement when scrolling or clicking the order grid.
:Fix issue where customer contacts are deleted from the quote's customer when the quote is deleted.
+
:'''Add "Plt Name" as an optional grid field.'''
:Fix issue where prospect contacts are deleted from the quote's prospect when the quote is deleted.
+
: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.
:'''Add DOT tab to enter state-specific DOT information.'''
+
: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.)'''
  
===Accounts Payable Module===
+
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.)
  
A/P Inquiry
+
Truck Demand Graph
:'''Add "Session No" as an optional field on the invoice grid.'''
+
:Change calculation of departure time for additional Plus load to be the End Pour time of the last load.
:'''Add Options->User Layout menu option to restore user's custom grid layout.'''
 
  
Aged Trial Balance
+
===Ticketing Module===
:Fix exception "EDatabaseError cdsReport: Field 'SEQUENCE_CODE' not found" when using the "Sequence" report sequence option (introduced in 3.6.29.2.)
 
  
Cash Flow Analysis
+
Order Maintenance
:'''Vendor Class and Division selection are now checklists.'''
+
:'''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.
  
Invoice Vouchering
+
Order Stack
:When checking for duplicate invoices, ignore invoices in A/P recurring batch templates.
+
:'''Add "Qty Ord" as an optional grid field.'''
:'''Add security option to control whether duplicate invoice numbers can be posted.'''
 
:Only show P.O. numbers in the P.O. dropdown that have unlinked P.O. receipts.
 
:'''Add Options->User Layout menu option to restore user's custom grid layout.'''
 
:Will now ask to save changes when using the X to close the window if you have fully distributed the current invoice.
 
:Prevent changes to the batch after posting and clicking the Cancel button the printer dialog.
 
  
Invoices for Payment List
+
Re-Print Tickets<BR>
:'''Vendor Class and Division selection are now checklists.'''
+
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.'''
  
MTD Check Register
+
Re-Print Tickets<BR>
:Fix issue where only uncleared checks were shown on the report.
+
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.
  
Select Invoices for Payment
+
Ticket Printing
:'''Add Options->User Layout menu option to restore user's custom grid layout.'''
+
:Fix endless printing when a ticket form CHAINs to another form (introduced in 4.6.2.2.)
  
Vendor Maintenance
+
===Accounts Receivable Module===
:'''Add Warning tab which will pop-up when the vendor is selected during Invoice Vouchering.'''
 
  
Void Check
+
A/R Inquiry
:When asked "Are you sure you want to void...?" if you use the X to close the window or press ESC key it will no longer proceed with the void.
+
:'''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.
  
Void Invoice
+
Comparative Customer Sales Report
:'''Performance improvement when loading the invoice list.'''
+
:'''Add product class selection.'''
:When asked "Are you sure you want to void...?" if you use the X to close the window or press ESC key it will no longer proceed with the void.
 
  
===Cash Management Module===
+
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.
  
Bank Account List
+
Customer Price Maintenance
:Fix exception when selecting on Bank Name.
+
:Show only those events related to customer prices.
  
Cash Flow Summary Report
+
Edit Ticket Times
:Include void and reversal transactions.
+
:'''Set associated status reason to "user edit" when one of the eight ticket times is changed.'''
:'''Indicate whether total amounts include void/reversal transactions.'''
+
:'''Display green background on any of the eight ticket times when the associated status reason is "user edit".'''
:'''Add C/M account segment selection.'''
+
:'''Display associated status reason description as a hint for all of the eight ticket times.'''
:'''Add "Source Trx" summarization option (detail.)'''
 
  
Statement Reconciliation
+
Import Tickets
:'''Add Options->User Layout menu option to restore user's custom grid layout.'''
+
:Handle exceptions when calculating sales tax during ticket import.
  
===General Ledger Module===
+
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.)'''
  
Account Maintenance
+
Print Invoices
:'''Add system option to require NRMCA Group to be entered for new G/L accounts.'''
+
:'''Add new invoice separation options: Customer Id, Job Id, Order Id and Customer Id, Job Id, Ship To.'''
  
Detail Inquiry
+
Print Statements
:Fix Credit Amt total calculating incorrectly on the Transaction History popup grid.
+
:'''Add Order Id and the four Ship To fields as available fields on the form.'''
  
Journal Entry
+
Product Maintenance
:Fix issue where batch could be posted that was out of balance.
+
: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.
  
===Payroll Module===
+
Product Sales by Customer Report<BR>
 +
Product Sales Report
 +
:'''Add "Separate by Plant" checkbox which prints separate sections for each plant and does not print grand total.'''
  
Email Direct Deposit Stubs
+
Re-Print Tickets
:Change caption on OK button to "Send".
+
:'''Add ability to print the 8 load time source fields on tickets.'''
:Eliminate blank page at end of check stub.
 
  
Print Direct Deposit Stubs<BR>
+
Sales Tax Rate Maintenance
Print Paychecks
+
:'''Add "Geo State" and "Geo Id" fields to support tax authority lookup by GPS coordinates.'''
:Eliminate blank page at end of check run.
 
  
Tax Library
+
Ticket Inquiry
:'''Updated to 2021-R11 version (ID, KS, NY states.)'''
+
:'''Show Invoice Number at bottom left of screen for sales history tickets.'''
  
===General===
+
Ticket Maintenance
 +
:'''Use job/customer specific ticket form when printing ticket if specified.'''
  
Batch Maintenance
+
===Accounts Payable Module===
:After posting a batch, the "Print another batch report?" dialog the button captions have been changed to "Reprint" and "Close" (the X button is treated as "Close".)
 
  
Company Database
+
Import Invoices
:'''Significantly improve performance of Stonemont QC batch result list query.'''
+
:Set the payment method for imported invoices from the vendor.
  
Generic Report
+
Re-Print ACH Stubs<BR>
:When exporting use field names instead of field labels.
+
Re-Print Checks
 +
:'''Add Division selection.'''
  
Keystone Map
+
Vendor Maintenance
:'''New version which (optionally) supports HERE routing (fastest/shortest) and geocoding.'''
+
:Change "Rename Vendor" dialog box to ask for the closing period Month/Year like Month End Processing.
:'''Allow manual dragging of route segments on the Route tab.'''
 
:'''Add "Undo" button on Route tab to un-do the last manual route change.'''
 
:'''Add "Show Traffic" checkbox on Route tab to show traffic data.'''
 
:'''Show start and end addresses on the directions portion of the Route tab.'''
 
:'''When calculating a route, use truck vehicle parameters received from the caller.'''
 
  
Reports
+
===Cash Management Module===
:'''Performance improvement: Generate report intermediate output to memory stream instead of disk file.'''
 
  
System Backup Utility
+
Statement Reconciliation
:'''When run as a Windows task the default is now to backup to the client and the cloud.'''
+
: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.
  
System Menu
+
===Payroll Module===
:Retry in case of error when downloading web update.
 
  
Windows Client
+
Tax Library
:'''Add support for Windows 11.'''
+
:'''Updated to version 2024-R9.'''
:'''Add support for Windows Server 2022.'''
 
:Fixed issue where client-side cache would not be updated properly after restarting KServer.
 
:Eliminate unnecessary refreshing of sales tax rates.
 
:Eliminate unnecessary KServer calls when refreshing/closing certain datasets.
 
:Fix "XltBaseProduct" method to ignore blank product ID.
 
:'''Store local cache files in a common folder instead of a user-specific folder (this should improve performance and resource usage on terminal servers.)'''
 
:When loading default or user's custom grid layout, scale the grid columns based on the current form dimensions to avoid "scrunched up" columns if the form is maximized.
 
:At startup apply field security options to ALL grid tabs, not just the active tab as previously.
 
:Fix error "Exception EFCreateError: Cannot create file "". The filename, directory name, or volume label syntax is incorrect" at startup (Remote Desktop users only.)
 
  
 
===Services===
 
===Services===
  
 
Application Server
 
Application Server
:'''When an order route is added or updated send an order route notification through KServer.'''
+
:'''Record the status reason code when setting one of the eight ticket times when the load status is changed.'''
:When validating batch weights, use DRIVER_ID instead of DRIVER_NAME to validate the driver.
 
:'''When validating batch weight ingredients populate the new VAL_INGREDIENT_SUBTYPE field.'''
 
:Fix issue where editing a Dispatch ticket did not update the Load Size in the projected loads table.
 
:'''When validating batch weights, validate the ingredient type, ingredient U/M and driver code.'''
 
:Reverted to 2GB memory limit which should improve reliability.
 
  
 
Device Aggregator
 
Device Aggregator
:When processing batch weights, truncate fields that are too long to avoid generating string overflow exceptions.
+
:Do not record batch results if there are no batch results present from the batch device.
:Log unhandled exceptions only once.
 
:'''Send Ingredient SubType to batch weight notification devices.'''
 
:'''When processing batch results, bring in Total Water fields (Keystone Batch only.)'''
 
:'''When preparing batch results to be sent to Batch Weights notification devices, include validated ingredient type and U/M data as well as DOT-specific U/M data.'''
 
  
 
Device Server
 
Device Server
:'''Add Order Route Notification device for Keystone Online.'''
+
:When processing batch results from a ULINK device, ignore an ingredient if it's name is empty.
:'''Use Ingredient Subtype to separate admixtures into the desired categories (PennDOT e-ticket.)'''
 
:Eliminate unnecessary log error message when sending dispatch events to Keystone Online.
 
:'''For batch controls, add support for Total Water fields (Keystone Batch only.)'''
 
:'''Consolidated Event/Notify device types into single Notification device type.'''
 
  
 
Keystone REST Server (KServer)
 
Keystone REST Server (KServer)
:Retry in case of error when sending and receiving cloud data.
+
:'''Add HaulHub/DOT support for these states: ID, KY, TN, WI.'''
:'''Add ability to send updated order route information to Keystone Online when an order route is added or updated.'''
+
:'''Add new optional boolean parameter to "StringReplace" function for replacing all occurrences of the pattern.'''
:Fixed issue where client-side cache would not be updated properly after restarting KServer.
+
:'''External AICrete API: New API for interfacing with AICrete.'''
:Eliminate unnecessary client-side local caches.
+
:Online Customer Portal API: Modify "ContactInfo" endpoint to add "SecOrders" boolean field.
:Fix issue with server cache version less than client-side local cache version.
+
:Online Customer Portal API: Modify "CustomerInvoices" endpoint to eliminate "UMTotals" array and replace with discrete fields in the invoice object (significant performance improvement.)
:'''Add support for absolute/relative redirect URI.'''
+
:Windows Client A/R API: Modify "rdmARCashRegister/cdsDepositHistory" endpoint to include SESSION_NO and TRANS_NO fields from ARTCSHHD table.
:'''Group Keystone session numbers by Session Id once per day.'''
+
:Windows Client A/R API: Fix "rdmARCashRegister/cdsDepositHistory" query to properly return A/R check information for combined deposits.
:'''Send MD5 content hash when writing cloud backup data to enable cloud service validation.'''
+
:Windows Client A/R API: Modify query in "rdmARAllTickets/cdsMaster" endpoint to include INVOICE_NO and INVOICE_DATE fields for sales history tickets.
:'''Added request/response log information related to local caching.'''
+
: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.)
:Fix task manager RunTask method to delay starting the background task until it has been properly initialized (notifications of new dispatch tickets were not being sent to tablets.)
+
:Windows Client Device API v2: Modify "TicketProducts" query in "VehicleStatusUpdate" endpoint to pull ticket detail from all three ticket tables (plant, office, sales.)
:'''Add handling for URL parameters that are separately URL encoded.'''
+
:Windows Client Dispatch API v2: Fix query in "rdmDISchedule/cdsDIAvailTrucks" endpoint to return LOCK_ORDER_PLANT_NO field.
:'''Support different document paths based on Company ID when storing e-tickets.'''
+
 
:Improve reliability of cloud backups.
+
===General===
:Improve handling of date/time string parameters.
+
 
:'''Consolidated Event/Notify device types into single Notification device type.'''
+
Setup
:'''Backoffice API: Add "PP Cash G/L" account handling to CustomerPayment endpoint.'''
+
:'''Now supports installing on Windows 11 for ARM (experimental.)'''
:'''Customer Portal API: Support credit card payments for one or more Keystone invoices (including discount handling.)'''
+
 
:Customer Portal API: CustomerInvoices will now properly include invoices with an empty Job Id.
+
System Option Maintenance
:Dispatch API v2: CustomerInvoices will now properly include invoices with an empty Job Id.
+
:'''Add search window to help locate system options.'''
:'''Driver API: Optimize "getdocfilename" query in notifyordercomplete endpoint.'''
 
:Driver API: Fix ticketproducts query in truckticketinfo endpoint to calculate the Qty Delivered based on previous tickets instead of using the original order Qty Delivered at the time of ticketing (show correct Order Qty Delv on e-tickets for edited tickets.)
 
:'''FX API: Significant performance improvement for "kpi" and "kpibymo" endpoints: optimize kpislslyr, kpisysytd, kpisysmtd, kpitck, kpiptk and kpiday queries.'''
 
:'''FX API: Add "trucksinstatus" endpoint.'''
 
:FX API: Fix "trucksbystatus" query to include only loads for the specified time period.
 
:'''Keystone Online Customer Portal API: Add "PP Cash G/L" account handling to CustomerPayments endpoint.'''
 
:'''Keystone Online Reports API: New API to support reports for Keystone Online.'''
 
:Stonemont QC API: Adjust redirect URIs to be relative.
 
:Version API: Fix time zone issue with server statistics.
 
:'''Windows Client A/P API: Several queries moved from Application Server to KServer.'''
 
:'''Windows Client A/P Lookup API: Several queries moved from Application Server to KServer.'''
 
:Windows Client A/P Report API: Fix "APAgedTrialBalance" query to include vendor Sequence Code field.
 
:'''Windows Client A/R API: Several queries moved from Application Server to KServer.'''
 
:'''Windows Client A/R API: Improve performance of quoted job lookup lists.'''
 
:'''Windows Client A/R API: Improve performance of XltBaseProduct endpoint.'''
 
:'''Windows Client A/R Lookup API: Several queries moved from Application Server to KServer.'''
 
:'''Windows Client A/R Lookup API: Add Product Ingredient Subtype lookup endpoint.'''
 
:Windows Client A/R Methods API: Fix XltBaseProduct endpoint to handle product codes containing slashes.
 
:Windows Client A/R Methods API: Fix XltBaseProduct endpoint to use the correct company when querying products.
 
:'''Windows Client Device API v2: Add "trxsync" endpoint that is run at startup and once an hour.'''
 
:'''Windows Client Dispatch Lookup API: Several queries moved from Application Server to KServer.'''
 
:Windows Client System Database API: Fix "logupdate" endpoint to apply proper base-64 decoding to update memo field.
 
  
 
----
 
----
 +
 +
[[Release Notes for Keystone 4.6.x]]
 +
 +
[[Release Notes for Keystone 4.5.x]]
 +
 +
[[Release Notes for Keystone 4.4.x]]
 +
 +
[[Release Notes for Keystone 4.3.x]]
 +
 +
[[Release Notes for Keystone 4.2.x]]
 +
 +
[[Release Notes for Keystone 4.1.x]]
 +
 +
[[Release Notes for Keystone 4.0.x]]
  
 
[[Release Notes for Keystone 3.6.x]]
 
[[Release Notes for Keystone 3.6.x]]

Latest revision as of 01:39, 4 January 2025


NOTE: Items in bold type are NEW features.

Build 4.7.10 - 1/3/2025

Payroll Module

Tax Library

Updated to version 2025-R1c (LA state.)

Build 4.7.9 - 12/28/2024

Payroll Module

Tax Library

Updated to version 2025-R1b (MT, NC, VT states.)

Build 4.7.8 - 12/23/2024

Payroll Module

Tax Library

Updated to version 2025-R1a (Federal, AR, HI, IN, MN, RI, WV states.)

Build 4.7.7 - 12/13/2024

Payroll Module

Tax Library

Updated to version 2025-R1 (Federal-preliminary.)

Build 4.7.6 - 12/3/2024

Dispatch Module

Order Maintenance

When a contact is selected, populate the order phone number from the contact mobile number (if specified) or the contact phone number.
Add "Show when order accessed" checkbox to Dispatch Warning tab.
Carry "Show when order accessed" field from job when copying an order and changing the job on an order.

Ticketing Module

Order Maintenance

When a contact is selected, populate the order phone number from the contact mobile number (if specified) or the contact phone number.

Accounts Receivable Module

Credit Card Pre-Approval

Add "Comment" grid column.

Customer Maintenance
Job Price Maintenance

Add "Auto Hold Tck" checkbox.

Customer Maintenance

Add "Alt Address" tab to allow entry of an alternate address (informational only.)

Import Tickets

Place imported ticket on hold based on the new "Auto Hold Tck" options in Customer/Job Maintenance.

Job Price Maintenance

Move "Plant Mix Type" to Dispatch tab.
Add "Show when order accessed" checkbox to Dispatch Warning tab.
Change "Show Dispatch Warning" checkbox description to "Show when job used in order."
Show "File #" on screen (if quote has a File # and is booked as a job.)
Add new "Job Search" dialog when F4 pressed in Job Id field.
Add blue background (indicating F4 search) to the Job Id field.

Inventory Module

On Order Maintenance

Fix inability to edit "Qty On Order" field for stocked products (introduced in 4.6.)

Quote Module

Quote Maintenance

Generate unique File # when adding a new quote.
Show "File #" on screen (if quote has a File #.)
Add ability to search on File #, Comment 1 and Comment 2 to F4 Quote Search.
Replaced calendar control on F4 Quote Search dialog to resolve issues with highlighting days containing quotes.
When booking a job, copy the "File #" field from the quote to the new job.

Accounts Payable Module

Federal & State 1099 Export

No changes for 2024 (ready for 2024 e-filing.)

Purchase Order Module

P.O. Receipt Maintenance

Fix EAccessViolation exception when deleting a receipt.

General Ledger Module

Import Payroll Transactions

Fix exception "EDatabaseError: Expression expected but nothing found" when importing C/M transactions where none of the G/L transactions reference C/M bank accounts.
Fix summarization logic for C/M impound, invoice and other transactions to process each record.
When summarizing C/M process all transactions other than Check/DirDep (to include Other transaction types.)
Add system options for Earn and Other G/L Item Categories.
Add system option to control G/L consolidation by G/L item category (default is to consolidate all item categories except Check/DirDep/Earn.)
Fix overlapping checkbox "Show Trx Description 2" (introduced in 4.7.4.)

Payroll Module

ACA 1094/1095 Export

No changes for 2024 (ready for 2024 e-filing.)

Federal & State W-2 Export

Add support for Box 12 code "II" (ready for 2024 e-filing.)

Federal W-2C (Corrections) Export

Add support for Box 12 code "II" (ready for 2024 e-filing.)

Tax Library

Updated to version 2024-R12b (KY, ME, MI states.)

General

DataScope
Query Export

Add "Quotes" option to the "Restricted to Module" dropdown list on the Save Query dialog.

PDF Viewer

Save/restore form state, size and position from run to run.
Show currently loaded PDF filename in form caption.

System Menu

When building query menu, add Quotes option to the retricted to module logic.
Take user security roles into account when filtering the query list by module.

System Option Maintenance

Add new options under G/L->Import Payroll Options: ISolved GL Category (Earn), ISolved GL Category (Other), ISolved GL Consolidation by Item Category.

Services

Keystone REST Server (KServer)

Online Dashboard API: New API added to support Python dashboard.
Windows Client A/R Lookup API: Modify query in "rdmARJobPrice/cdsKey" endpoint to support new F4 Job Search dialog in Job Price Maintenance.
Windows Client Quote Lookup API: Modify query in "rdmQTQuote/cdsKey" endpoint to support File #, Comment 1 and Comment 2 fields in F4 Quote Search dialog in Quote Maintenance.

Build 4.7.5 - 11/9/2024

Payroll Module

Tax Library

Updated to version 2024-R12 (Social Security wage base for 2025.)

Build 4.7.4 - 11/1/2024

Dispatch Module

Mix Design Maintenance

Filter product lookup to include only Mix type products.

Order Maintenance

Replace exception message when using the "Lookup Tax Authority by GPS" option with a user-friendly message.
Fix automatic product handling to avoid adding automatic products where the product is marked Inactive in Product Maintenance.
Prevent new orders from being added for inactive customers.
Highlight loads for a future date with a yellow background.
When a load override time is prior to the order delivery time, prompt user to choose to schedule at the earliest possible time today or to schedule for tomorrow.
Update the load override time when recalculating loads if necessary.

Schedule

Move "View Order" button to bottom-most position on the Order popup dialog.

Ticket Maintenance
Ticket Printing

Fix automatic product handling to avoid adding automatic products where the product is marked Inactive in Product Maintenance.

Ticketing Module

Order Maintenance

Replace exception message when using the "Lookup Tax Authority by GPS" option with a user-friendly message.
Fix automatic product handling to avoid adding automatic products where the product is marked Inactive in Product Maintenance.
Prevent new orders from being added for inactive customers.

Ticket Maintenance
Ticket Printing

Fix automatic product handling to avoid adding automatic products where the product is marked Inactive in Product Maintenance.

Accounts Receivable Module

Customer Maintenance

Add "Web Orders" checkbox to Contacts grid.

Import Tickets

Fix automatic product handling to avoid adding automatic products where the product is marked Inactive in Product Maintenance.

Job Price Maintenance

Replace exception message when using the "Lookup Tax Authority by GPS" option with a user-friendly message.

Open Ticket Stack

When the Customer Id is changed on a ticket, ask if the ticket should be re-priced.
Require a Void Reason when a ticket is voided.

Print Invoices
Re-Print Invoices

Add ability to print Order Contact and Phone Number on invoice.

Ticket Maintenance

Fix automatic product handling to avoid adding automatic products where the product is marked Inactive in Product Maintenance.
When the Customer Id is changed on the ticket, ask if the ticket should be re-priced.
Require a Void Reason when a ticket is voided.

Quote Module

Print Quotes

Add ability to print the product's Description 1 and 2 fields on the quote form.

Accounts Payable Module

A/P Inquiry

Add "Last Ck#" grid column.

Select Invoice for Payment

If user does not have security role permission for C/M, do not show the C/M account balance.

General Ledger Module

G/L Batch List

Add user checkbox for "Show Trx Description 2".

Import Payroll Transactions

New option added to the G/L Entry/Inquiry menu (used to import transactions from iSolved payroll.)

Payroll Module

Tax Library

Updated to version 2024-R11a.

Timecard Maintenance

Fix EAccessViolation exception when deleting a paycheck.

General

DataScope
Query Export

Take user roles into account when filtering the query list by module.

System Option Maintenance

Add "Import Payroll Options" section to G/L options.

Services

Application Server

Update G/L, C/M and J/C post batch logic to handle imported iSolved transaction batches.
rdmARTicket: eliminate need for separate transaction for qryClearInvSort, qryGenInvSort and qryTktInvSort queries.

Device Server

Digital Fleet ticket XML export: add "usage_desc" field.

Keystone REST Server

A/R Lookup API: Modify query in "rdmARProduct/cdsAutoProductLookup" endpoint to ignore products marked inactive.
A/R Lookup API: Modify endpoints to add filter parameters: rdmARProduct/cdsLookupFirst, rdmARProduct/cdsLookupLast, rdmARProduct/cdsLookupNext, rdmARProduct/cdsLookupPrior.
Online Customer Portal API: Modify "ContactLookup" and "ContactList" endpoints to add "SecOrders" boolean field.

Build 4.7.3 - 10/17/2024

Payroll Module

Tax Library

Updated to version 2024-R11 (IN counties.)

General

System Map

Fix issue where an empty white screen appears when viewing the map.

System Menu

Fix issue where some anti-virus software (Sonicwall Gateway is one example) may block the transfer of the pending Keystone update to local workstations.

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.

General

Setup

Now supports installing on Windows 11 for ARM (experimental.)

System Option Maintenance

Add search window to help locate system options.

Release Notes for Keystone 4.6.x

Release Notes for Keystone 4.5.x

Release Notes for Keystone 4.4.x

Release Notes for Keystone 4.3.x

Release Notes for Keystone 4.2.x

Release Notes for Keystone 4.1.x

Release Notes for Keystone 4.0.x

Release Notes for Keystone 3.6.x

Release Notes for Keystone 3.5.x

Release Notes for Keystone 3.4.x

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