Development changes and improvements LS One 2020
If a ticket from the support portal is attached to the work described here below, the ticket number (both development and support ticket number) are listed after the description. If no ticket numbers are listed, then either this change request came from the LS One roadmap and/or backlog or the request came to us through some other channel.
Diff report for 2019.1 SP4 to 2020
2019.1 to 2020 diff report download
Database changes
To view all database changes the update scripts for this release can be reviewed in the Development pack. The update scripts can be found at ..\DevPack\Source\Core\Datalayer\DatabaseUtil\SQLScripts\Update Database\LS One 2020
When the database is updated through the DatabaseUtil.dll the POSISINFO table is now also marked with the date and time when the update occurred.
Here is a list of database changes that you should beware of when merging existing customizations to LS One 2020
Safe drop, bank drop and tender declaration settings on the functionality profile
The following boolean fields in table POSFUNCTIONALITYPROFILE were renamed and their meaning inversed. (that one of these dialogs uses denomination means that it does not use the numpad)
When upgrading an existing database, existing values will be converted after the columns are renamed.
| Old column name | New column name |
|---|---|
| SAFEDROPUSESNUMPAD | SAFEDROPUSESDENOMINATION |
| SAFEDROPREVUSESNUMPAD | SAFEDROPREVUSESDENOMINATION |
| BANKDROPUSESNUMPAD | BANKDROPUSESDENOMINATION |
| BANKDROPREVUSESNUMPAD | BANKDROPREVUSESDENOMINATION |
| TENDERDECLUSESNUMPAD | TENDERDECLUSESDENOMINATION |
Database update script: 01009-00.sql
Increased field widths in TOURIST table (Tax free)
The following columns in table TOURIST were changed.
| Column | New type |
|---|---|
| ADDRESS |
NVARCHAR(250) |
| STREET | NVARCHAR(250) |
| CITY | NVARCHAR(250) |
| STATE | NVARCHAR(250) |
| COUNTY | NVARCHAR(250) |
| COUNTRY | NVARCHAR(250) |
| ZIPCODE | NVARCHAR(20) |
Database update script: 01012.sql
Search keywords added in RETAILITEM table
The table RETAILITEM now have a new column SEARCHKEYWORDS which is included in the item search instead of the EXTENDEDDESCRIPTION column. (Column EXTENDEDDESCRIPTION is unchanged just not included when searching for items).
Database update script: 01015-00.sql
Unit of measure added to items in periodic discounts
The solution for support issue LSTS-9509 (ONE-11528), adds a new column UNIT to table PERIODICSIDCOUNTLINE.
Also the type of column TARGETID in the same table is changed from NVARCHAR(30) to NVARCHAR(60).
Database update script: 01014-00.sql.
Removed operation Pay card
The operation Pay card (201) has been marked as removed in table OPERATIONS and can no longer be used in the POS button layouts.
Existing customizations that use the operation Pay card (201) need to be changed to use operation Authorize card (215).
When upgrading an existing database to LS One 2020, any use of operation Pay card in table RBOSTORETENDERTYPETABLE will be replaced by operation Authorize card (215) in column POSOPERATION.
Any use of operation Pay card in POS button layouts (table POSMENULINE) will be cleared when upgrading to LS One 2020.
Database update script: 01013-00.sql
Removed dialogs
When doing the redesign of the POS dialogs we decided to remove old and unused dialogs from the source code. Therefore the following dialogs are not a part of the development pack:
Services
CorporateCardService
- frmTenderRestriction - This dialog has been replaced with the TenderRestrictionDialog from TenderRestrictionService
DialogService:
- DateSelectionDialog
- frmSelectDate
- frmTenderCount
- LineControl
- SpinnerHostControl
DimensionService:
- frmDimensions
- frmDimensionsSelection
HospitalityService
- StaffTakeoverDialog
InfocodeService
- frmTouchBase
SalesOrderService
- Testing
Other
POSSharedDialogs
- NumpadDialog
POSProcesses
-
- frmLicensePassword
- frmLockTerminal
- frmMessageList
- frmOpaqueBackground
Other improvements
| Issue number | Support issue | Description | |
|---|---|---|---|
| ONE-11851 | LSTS-10286 | Fixed an issue causing an error when the database was missing SAP tables. | |
| ONE-12300 | LSTS-9880 | Added the ability for negative number input for the numeric range ConditionType on the SearchBar control. New constructor added with bool value allowNegative set to default false added. | |
| ONE-11663 | Operation PayCard is now obsolete. | ||
| ONE-11933 | OperationInfo property RequiresManagerPermission is now obsolete. | ||
| ONE-10481 | To better suppor logging, LibLog library has been made available in LSOne.Utilities assembly under LSOne.Utilities.Logging namespace. |
New controls
| Issue number | Description |
|---|---|
| ONE-11772 | Create new control: multiline text viewer |
| ONE-11744 | Created new scrollbar control and changed the old scrollbar in the list view with the new one. |
| ONE-11585 | Date picker touch - Created a new touch friendly calendar control and a dialog that allows the user to select a date. |
| ONE-11371 | Created a new button control with a type setting based on which the style of the button is chosen. Updated all buttons in touch scroll panels. |
| Customer control | |
| ONE-11377 | Created a custom text box control that allows ghost text and configurable font size regardless of control height. |
