12.10.19

The following 12.10.19 stability notes are additional changes made after the parent release 12.10.6 and prior stability releases. For a summary of all changes, please see the 12.10.6 summary notes. Notes are listed in order of our project tracking numbers.

B-44035 - Remote Client - RDP Add-in (Support Only)

This item applies to our hosted customers using the Remote Client Service for printing and certain other network communication in place of a VPN (Virtual Private Network) connection. When checking for a Virtual Channel being available, we will now check against the shared variable SPTrace.isRemoteSession as well as the SystemInformation.TerminalServerSession to determine if the connection is an RDP connection. This ensures that we reliably determine an RDP session. It is suspected that RDS issues in hosting cause the SystemInformation.TerminalServerSession call to return false at times causing the software to use the IIS communication instead of RDP. (12.10.19) B-44035 TFS-150789-P

B-44037 - Remote Client - Printer Page Settings

Change for verifying the selected printer has the proper page settings for generating an Active Report when using the Remote Client. We will now check to see if the requested printer exists in the ClientPrinters collection. If it does not we will return false which will trigger the Active Report to generate using the Active Report virtual printer. This scenario happens in the Hosted environment, where the Terminal Server default printer used for the Active Report does not exist on the Remote Client PC. In this case we were unnecessarily logging an error that the printer does not exist. (12.10.19) B-44037 TFS-150799-P

B-44046 - SpruceWeb - Tokens

Tokens now has its own DODataObject user that implements IDisposable for connection cleanup. SpruceWeb now has it's own DODataObjectUser that implements IDisposable for connection cleanup. SpruceWeb now has more logging for the remote client. (12.10.19) B-44046 TFS-150833-P

B-44301 - Windows 10 Creator Update - Slowness

Code changes were made to work around issues identified with the Windows 10 Creator Update and .NET Framework 4.7.1. (12.10.19) B-44301 TFS-151488-P

B-44331 - Remote Client Service - Screen Print

Remote Client now supports File > Print type functions (such as the screen print from the cash drawer register utility). Created a new method in PrintHelper to call the RemoteClient to print an image. (12.10.19) B-44331 TFS-151393-P

B-44689 - Vendor EDI - Orgill - Mapping Overrides - Purchase Order Send

There are two (2) new mapping overrides for Purchase Order submission with Orgill, Inc.: PO Send w/Retail and PO Send w/Price0. In either case, an additional DT2 record is created in the data for each item ordered. This record includes either the suggested list or store retail (level 0 price) for the item. The price is found in positions 4-12 of the DT2 record. The format can be manually selected from the Transmit, EDI tab of the Process (F12) form when processing a Purchase Order. To permanently use the override for ALL orders, select the desired override from the Mapping Overrides form for the Orgill EDI vendor from the Branch Setup form's EDI tab (Main Menu > Maintenance > Database > Branches).

If the override is set as the default, users won't have to select it from the Purchasing, Order Entry transaction. Even though the Transmit, EDI tab will still list "regular order" as the selection, the override will be used when creating purchase order data. (12.10.19) B-44689 TFS-152006-P

B-42809 - Maintenance / Database / Parameters - Receivables - Invoice Reprint Type for Statements

The "Invoice Reprint Type" selection will now be used for "single file" statements as well as the standard separate file option. Single file combines the invoices and statement pages in one print job per customer. There is no longer a need to manually update these parameters for "single file" directly in the database by support. (12.10.19) B-42809 TFS-152534-P

D-37845 - Help - Printing

Change to use the printHelper class for printing Help. Will resolve some issues printing Help from the cloud when using remote client. SPDebugOpt of HelpNoPrint to disable and use native print method. When using the Remote Client Service, this will only work when printing using the RDP method to print, but not when using IIS method (via an Alias).

Added some additional checks to see if the form is closing when handling key press and other events to avoid potential errors when the application is closed independently of the help but after commands are issued. (12.10.19) D-37845 TFS-151396

D-39397 - Item Returns Utility

The item return utility was not handling "return to stock" correctly when the vendor return originated in inventory adjustment due to a code error. If more than one adjustment document existed for the item in question, the quantity adjustment was being applied incorrectly. (12.10.19) D-39397 TFS-151186-P

D-39818 - Delivery / Manifest - Square Footage

The square footage was not being summed properly on the delivery manifest document. This has been corrected. Now, the delivery manifest square footage total will match the sum of square footage for the linked documents. (12.10.19) D-39818 TFS-152202-P

D-39921 - Vendor Quote - Email Attachment

Vendor Quote documents were Emailing with a PDF file name of "-1.PDF" instead of using the document number of the quote. This has been corrected. (12.10.19) D-39921 TFS-150805-P

D-39999 - Point of Sale / Orders / Dispatch Copy - Weight Decimal Display

We are now displaying the weight out to two (2) decimal places on the Dispatch Copy of customer order documents to be consistent with the other weight displays on order document styles. (12.10.19) D-39999 TFS-151895-P

D-40148 - Inventory / Inquiry / Tracking - RockSolid MAX

Tracking display in RockSolid MAX mode was not displaying the on-hand, but was only listing the Change Qty. This was due to a property that determined whether or not all document types were being included. Problem was that some document types just don't apply to RockSolid MAX, so they aren't included by default. We changed the Check_Selections method to ignore the two (2) document selections that don't apply when the SPRockSolid sysparam is set (true). Now, the display shows the on-hand as it should regardless of product brand. (12.10.19) D-40148 TFS-152038-P

D-40208 - Cash Drawer Tally - Print

Changed the Cash Drawer Tally to use the new Print > File method when using the Remote Client. Now using new print image method of the Remote Client. (12.10.19) D-40208 TFS-151394-P

D-41683 - Installed Sales - Contract Void

When voiding an Installed Sale Contract, we now mark the contract as "complete." (12.10.19) D-41683 TFS-150938

D-41700 - Payables / Disbursements - Printing Checks via Remote Client Service

The printing of disbursements may involve a single printer with multiple trays where one tray holds pre-printed check forms and the another plain or colored paper for additional voucher pages when needed. There was an issue when printing the checks and vouchers through the Remote Client Service. Additional page settings are now being passed to correct the issue. (12.10.19) D-41700 TFS-152108-P

D-41770 - Invoice POS Assured Utility

Updated the Point of Sale, Utilities menu to only show Invoice POS Assured Sales when POS Assured is enabled in Parameters. (12.10.19) D-41770 TFS-151528-P

D-41799 - Totals Report

Cost corrections total from same period last year were being added into cost corrections for current period in error. This only happens when the month option is being used for selection (MM/YY). Date range can be used as a work around until this fix is applied. (12.10.19) D-41799 TFS-151138-P

D-41835 - Inventory, Adjustments, Qty Adjustment

There are three (3) distinct options available when the Qty Adjustment (radio button) is selected: Item, Transfer out, and Work Order. We no longer allow a mix of regular item adjustments along with Transfer Out and Work Order reversal. Each option is now isolated. Once any of the three (3) options is selected, the remaining two (2) are now hidden until processing is completed or the user cancels the transaction. Additionally, the Transfer Out option prevents user changes to the items being reversed. (12.10.19) D-41835 TFS-151388-P

D-41877 - Point of Sale / Installed Sales / Use Tax

Installed sales contracts were not recording the "use" tax totals with the Installed Sale contract (header), so the Installed Sales report which referenced the "use" tax was not displaying totals for the amount. The contract is now being updated with these amounts so that the Installed Sales report can properly report them. (12.10.19) D-41877 TFS-152680-P

D-41942 - Point of Sale / Reports / Management / Credit Management

The Credit Management report, when scheduled, was not setting the date range based the menu marker date preset selection. This has been corrected. (12.10.19) D-41942 TFS-151597-P

D-41953 - Point of Sale - Footage Document Styles (Orders & Invoices)

Logic for calculating square footage measures were missing references to the item's Pricing UM. Board footage calculations did not have the same issue. This would only manifest for "Sheet Goods" type items where the only valid square footage measure was the Pricing measure (and none of the others were).  (12.10.19) D-41953 TFS-151547-P

D-41970 - Verifone Point - Reconcile

In some cases, the approved amount shown wasn't exactly matching the transaction amount and could be off by a penny (.01). EMV approved amount off by a penny from actual Approved Amount. This change will simply display the actual approved amount instead of the EMV_9F02 element. SPDebugOpt argument to switch back to original code of EMV9F02. (12.10.19) D-41970 TFS-151642-P

D-41982 - TSYS Cayan Bankcard Receipts

TSYS Cayan card receipt document data was being saved in a raw data format. For future receipt data, we now format the data in a readable form so that they can be more easily viewed from the Documents form Viewer. We must keep receipt data for certain bankcard transactions. (12.10.19) D-41982 TFS-151689-P

D-41990 - Point of Sale / Orders - Quotes Document Selection

Code was changed to skip the column header adjustment when the only record in selection list is the "<< New >>" selection. Error could occur if a user entered a non-existent quote document ID and then clicked the down arrow followed by clicking column header for job name. (12.10.19) D-41990 TFS-151680-P

D-41993 - Item Returns Document

Enabled the IN Vendor Returns document type for RockSolid MAX users. These documents can be created by processing in the Item Returns utility which is available to RockSolid MAX users, but the document type was excluded. (12.10.19) D-41993 TFS-151677-P

D-42000 - Maintenance > Task Scheduler

Task Scheduler wouldn't allow changes to scheduled reports using the Schedule (F7) function. Code that enables key was commented out improperly while attempting to restrict changes to EOD, EOM, Billing, etc. Schedule (F7) will only be enabled while in Calendar (F5) mode for reports, not where checklists can be changed. (12.10.19) D-42000 TFS-151684-P

D-42076 - Point of Sale / Cash Ticket Printing

The cash ticket printer output was not checking whether the "print" check box was selected (checked) at time of processing. This would cause a cash ticket to print regardless of whether printing was selected if the printer designated was a cash-ticket type. (12.10.19) D-42076 TFS-151831-P

D-42120 - Purchasing / Vendor EDI / Orgill - File Maintenance - Manufacturer's Number

The manufacturers code (model number) for the Orgill catalog was only allowing 7-characters, so some model numbers were being truncated. We have expanded the length of the field to allow up to 16-characters. (12.10.19) D-42120 TFS-152006-P

D-42125 - Point of Sale / Reports / Invoices & Tickets Report

Due to changes to permit the invoicing of Open Tickets to non-charge customers using the new "Invoice Ticket" (F8) function, changes were made to filter out any "open ticket" documents where the status is not open. Tickets that are invoiced using the new function are not removed or directly converted to invoices; however, the status of the document is changed. Corresponding changes were made to the Item Tracking inquiry. (12.10.19) D-42125 TFS-152103-P

D-42126 - Inventory / Inquiry / Tracking - Cash Invoiced Tickets

The Tracking inquiry was including Open Tickets (aka. Advice Notes) where the ticket had been invoiced for a system or cash-only using the new "Invoice Ticket" (F8) function. In these cases, the ticket is not converted to a regular invoice. Instead, a new "cash" sale invoice is generated and the original ticket is no longer updated. The Tracking inquiry has been changed to only include "open" tickets to avoid issues with the on-hand calculation for tracking history. (12.10.19) D-42126 TFS-151989-P

D-42150 - Point of Sale / Payouts / Refund Acct Balance by Refund Check

The Refund Acct Balance option in Point of Sale / Payouts was using the Payables Accrual account improperly if the user choose "Refund Check." Now, the debit adjustment (AR) and billing invoice (AP) will use the "refund checks" account mapped to sequence #28 in the Point of Sale system journal mapping. The offset selection is not used for "backroom check" refunds, only cash-type refunds. The selection control is hidden when the user selects "backroom check." (12.10.19) D-42150 TFS-152040-P

An additional change was made to more clearly indicate that the "debit" account selection is not used when choosing the "backroom check" option from the Payouts, Refund Acct Balance option. The debit account selection control has been moved below the radio buttons and is now disabled to show a message that the selection is "not available." (12.10.19) D-42150 TFS-152102-P

D-42185 - Point of Sale / Order-Quote Selection - Sorting by Date

An exception would occur if users sorted the selection listing of quotes or orders in reverse order by date and then clicked the "more" option. This has been corrected. (12.10.19) D-42185 TFS-152130

D-42213 - Data Connections

We corrected a problem where the database connection could be nothing and cause an exception for the user data object necessary for establishing a data connection. This was primarily occurring with applications that integrate with SpruceWeb (web services). (12.10.19) D-42213 TFS-152262-P

D-42227 - Job Maintenance - Job Selection

We have made corrections to address a sequence where the user enters in a very high project number that does not exist. This would produce a selection list with only a "<<New>>" option. If the user then clicked the job name column header to sort the empty list, an exception would occur. (12.10.19) D-42227 TFS-152240-P

D-42399 - Point of Sale / Open Tickets - Use Tax

Use Tax Code Totals were not being updated correctly for Tickets linked to installed sales when invoiced. This has been corrected. Tax totals are not updated until invoicing. Tickets associated with installed sales contracts are invoiced automatically when the contract is closed; however, they can also be manually invoiced. (12.10.19) D-42399 TFS-152521-P

R-47318 - Point of Sale / Installed - Canada Real Property Tax

On hand quantities were being doubled on returns linked to installed sales when real property tax was indicated. This was due to an unintended consequence to correcting "R-42416 - PST real property tax not calculated properly" issue. For real property, PST tax is paid on the materials by the merchant. While the tax was being correctly calculated on the material cost on the ticket, the cost on the ticket did not necessarily reflect the current weighted average of the items. Returns with real property wound up calling the routine to adjust on-hand twice, once from PSTicketsData and once from BusinessLogicCloseout. This has been corrected. (12.10.19) R-47318 TFS-152230

R-47762 - Point of Sale / Order-Quote Selection Sorting by User

We now allow sorting the selection list for Orders-Quotes by user. (12.10.19) R-47762 TFS-152524-P

Corrections to for the recently added sort by order user id. Second field in order changed from to DocIDInternal for both ascending and descending user id sort. (12.10.19) R-47762 TFS-152526-P