RP Prism 2.5.4.1307 Release Notes
Prism 2.5.4.1307 Release Notes PDF
This topic includes information related to the bug fixes and new features released in Prism 2.5.4.1307.
NOTES
- Windows 10, 11 users: Launch the Prism Proxy using the Run as Administrator option.
- Clear the cache before trying to log in.
- The Prism App (Windows and Android) performs the same functions handled by the Prism Proxy. Do not use the Prism Proxy when using the Prism App.
- MySQL versions 8.4.8 (Long-Term Support release) and 9.6 (current release) work with Prism 2.5.4. See the Prism MySQL 8.0 to 9.6 Upgrade Process document.
SYSTEM REQUIREMENTS
Oracle 19c upgrade requires more memory and other resources than 12c. Read the RP Prism Oracle 19c Upgrade document before running the Oracle 19c upgrade.
NEW FEATURES AND ENHANCEMENTS
New Client
- New Home Screen/Landing Page (30632)
- Sales quotes (30300)
- Export grid data (30678)
- Encode URL query parameters (30602)
- Check In/Out (29963)
- Search by 'Sale Note' 'Return Note' fields (29576)
- Improved Error Surfacing (30472)
- "Go to TTK" to manage user sessions (30164)
- Support for scanner on Android (30128)
Legacy Client
- MySQL 8.4.8 (and 9.6) Support (26047)
- Coupon Code Type and Length (26427)
- Require All BOGO Rewards (30240)
- Cache Replication Subscription Information (30620)
- Copy Employees (28713)
- Transaction Lookup By Bill to/Ship To Customer (28325)
- Filter Inventory by Markdown Date (29484)
- Document Sequence Number for Special Orders (30569)
- Store Code column in Transfer Verification (28638)
- Set Max Gift Card Number Length Independently for Centrals/Non-Centrals (29563)
For more information about the new features and enhancements, see the What's New topic.
TECHNICAL/ARCHITECTURE CHANGES
- A new item type (quote item) is added to the item type field in the document table. DOCUMENT_ITEM.ITEM_TYPE=6 (Quote Item).
ANDROID APP FIXES (2 ISSUES)
| Issue ID | Title Description | Build Found | Solution |
|---|---|---|---|
| 30519 | Make Port entry field number only. | 2.5.3 | The Port field only accepts numbers. |
| 30128 | Scanner support for camera on Android | 2.5.3 | A camera barcode scan icon is now added to the Item Lookup input on the Android app. It opens a preview with a scan box. This enables users to scan item barcodes using the Android device camera |
WINDOWS APP FIXES (2 ISSUES)
| Issue ID | Title Description | Build Found | Solution |
|---|---|---|---|
| 30164 | Unable to manage sessions in Prism Windows App when seat limit Is reached | 2.5.2.1538 | When a Windows App login results in an 'Out of Seats' error message, the user now has an option to go into Tech Toolkit. |
| 29918 | Prism App uninstall fails to remove all associated files | 2.5.2.1513 | All Prism App components and folders are now removed when the user uninstalls the Prism App. |
GENERAL FIXES (74 ISSUES)
The following list outlines key issues that have been addressed with this release. This list is not intended to reflect all possible fixes done during the given period, but those that are deemed important for review and specific to this release.
| Issue ID | Title/Description | Build Found | Solution |
|---|---|---|---|
| Accounting Link | |||
| 20522 |
GL_FLAG and AP_FLAG carried over to REVERSING document when a voucher or when a slip is reversed. |
2.5.0.1483 | Confirmed that slips and vouchers that are read into the General Ledger (GL_FLAG) and subsequently reversed do not retain the GL_FLAG value on the new reversing documents. For vouchers specifically also confirmed that the Accounts Payable (AP_FLAG) and Purchase Clearing (PC_FLAG) are not carried over |
| Adjustment Memos | |||
| 29874 | Inactive items can be added and adjusted on adjustment memo without warning. | 2.5.1.33 | Inactive items can no longer be added to quantity memos. |
| API | |||
| 28435 | Auto-verify does not work when creating slip/voucher using API. | 2.5.3.2066 | The API calls have been modified so that users can properly generate slips from vouchers via the API when "Verify Transfers Upon Voucher Update" is enabled. |
| Batch Receiving | |||
| 28991 | The Receive Marked option is attempting to update marked ASNs in subsidiaries other than the user's current sub and those marked ASNs are set to pending (vou_class = 0, status = 3). | 2.2.1.136 | Receiving a marked ASN will only receive the ASN in the currently selected subsidiary. |
| Centrals | |||
| 30721 | When Central Returns is enabled, a package item with a discount cannot be returned. | 2.5.3.2061 | When Central Returns is enabled, a package item with a discount can be returned without any issues. |
| 30594 | Clearing the Centrals Gift Card Rollback tables still allows pending transactions to be updated, even though the temporary record with the tender is gone. | 2.5.3.2030 | When issue #29278 was implemented, it was possible that a pending transaction (2 days old) with a non-updated Centrals Gift Card Tender had the tender deleted from the Centrals Rollback table. In that event, it was still possible that the pending transaction with the orphaned Centrals Tender was updated. An error message has been added to prevent that. |
| Customer Loyalty | |||
| 29953 | Multi subsidiary loyalty program redemption and error on tender. | 2.5.2.1515 |
Items are now correctly displayed in the Gift Items list for each subsidiary. Additionally, if the cashier attempts to add Item A to the transaction, the system no longer throws any errors. |
| Customers | |||
| 30915 | The New Customer button in New Transaction > Options > Add Items from Wishlist does nothing. | 2.5.4.1152 | New Customer button has been removed from wishlist lookup in the legacy client. |
| Document Designer | |||
| 30574 | Cancel Date does not print on default PO Active design. | 2.5.2.1554 | Cancel Date now appears on default PO Active design. |
| 30372 | No datasets available for Disbursement designs. |
2.5.2.1548 | Users can now view and utilize datasets in Disbursements and Customer Wishlist areas within Doc Designer. |
| 30371 | Disbursement Doc Design fails to preview. |
2.5.2.1538 | Users can now successfully preview/print Disbursements 40col & Disbursements 8x11 designs. |
| EFT - Adyen | |||
| 30921 | 2.5 Prism Server installation overwrites customizations.js file. | 2.5.3.2072 | Code has been changed so that over the top installation will not affect the customization files. |
| Employees | |||
| 28713 | Add ability to copy employee. | 2.4.1.1061 | Users can now copy an employee record. The What's New document lists the information that is and is not copied. |
| General System | |||
| 30678 | Add Export functionality for data from grids to Excel. | Feature | The ability to Export Grid Data has been added to Legacy Prism and the New Client for the following areas. The Data can be exported in CSV, TSV, EXCEL, and PDF. See the What's New document for a list of areas where the Export button is available. |
| 30632 | Home screen for new client. | Feature |
When users launch and log in to the app, they are taken to a new Home Screen. The Home Screen has links to the other areas of the application. Previously, a blank (live) transaction form was displayed. This provides a better experience for touchscreen users. |
| 30602 | Request to encode/decode all our URI query strings to avoid Web Application Firewall (WAF) dropping request that contain logical operators (AND/OR/NOT) in query string. | 2.5.3.2059 | Added URI query‑string encoding/decoding to prevent WAF from blocking requests containing logical operators. |
| 30472 | Improve error surfacing in the new client. | Feature | Errors are properly generated with links to server error response, parsed and raw. |
| 30454 | Memory leak in POSV1 related to logging off process (easily visible when using Centrals) | 2.4.1.1079 | Implemented reference‑counted cleanup for cached security sessions so the cached security sessions are only removed from memory when no threads are using the sessions. |
| 30164 | Unable to manage sessions in Prism Windows App when seat limit is reached. | 2.5.2.1538 | When a Windows App login results in an 'Out of Seats' error message, the user now has an option to go into Tech Toolkit within the Windows App. |
| 29576 | Add ability to search documents by Sale Notes, Return Notes and Lost Sale Notes. | 2.4.1.1013 |
Sale Notes and Return Notes are available in the new client grids. Lost Sale Notes will be added if/when Lost Sales are implemented in Prism. |
| 28402 | When switching between subsidiaries in any back-office module, store specific filters (store name, store number, etc.) do not refresh to reflect the current SBS and only show the initial SBS when the filter was added. | 2.2.1.136 | Users can change subsidiary in back-office document lookups. Store specific filters will show stores that coincide with the selected subsidiary. |
| 28166 | Enable export of filtered results to PDF, Excel, and CSV Formats | 2.4.1.1013 |
The ability to export grid data has been added to legacy client and new client for the following areas: |
| Installation | |||
| 26047 | Prism Server will not complete install on MySQL 8.0.35 or MySQL 8.2. | 2.2.1 | Prism can now be installed on MySQL v8.4.8 LTS or MySQL 9.6.0 installations. A MySQL upgrade procedure is available to update a Prism MySQL 8.0 DB to 8.4.8 or 9.6. |
| Inventory | |||
| 30720 | Scale SID not applied to every item in style so the item grid for the style is not ordered according to the scale. | 2.5.2.1538 | When a Scale is assigned to an existing Style, the item-grid for the Style will be ordered according to the scale. |
| 30562 | Text UDF 6-15 and Long Text UDF 1-2 do not save when creating a new style. | 2.5.2.1554 | All UDFs defined during style creation now save correctly to the style and all the items within the style. |
| 30280 | FST_PRICE doesn't record the price of the first time an item is created. | 2.5.2.1515 | When a new inventory item is created, the price now populates the FST_PRICE field in the INVN_SBS_ITEM table. |
| 29861 | Size and Attribute fields in Inventory enforce uppercase input. | 2.5.1.33 | Attribute and Size now allow for uppercase and lowercase in items and styles. |
| 29484 | Add Markdown Date as a filter in Inventory Lookup. | 2.4.1.1013 | Markdown Date has been added to the grid formats for Inventory Lookup and Advanced Item-Lookup for POS and back-office documents. |
| 26706 | Add Unit/Case to the Inventory Grid formats. | 2.2.1.134 | Units/Case has been added as a filter in Inventory Lookup, Advanced Item Lookup, and in Min/Max Review Item Lookup. The filter and column can be added through Grid Formats Legacy options. |
| Permissions | |||
| 30130 | Users without "Transfer Slip - Create Slip" permission can still create slips using "Generate Slips" option on transfer orders. | 2.5.2.1538 |
Users who do not have permission to create slips will no longer be able to generate slips from a transfer order. |
| Physical Inventory | |||
| 30639 | Unable to send PI sheet to HQ from POA in three-tier enterprise. | 2.5.3.2059 | A PI can now be sent again after it has been sent once already. This can happen going upstream or downstream in an enterprise. |
| 30630 | PI records cannot store quantity values greater than seven digits | 2.5.1.33 | The per‑item quantity limit remains seven digits; however, total Zone/PI quantities now support NUMBER(16,4). 16 digits with 4 decimals. |
| 30131 | "Multiple Items Found" toast appears but only one item displayed. | 2.5.2.15115 | The Multiple Items modal within the Add-Counts page in Physical Inventory now shows all matching items (active or Inactive.) The inactive items are clearly marked as inactive, and the user is free to pick which item they intended to add to the PI. All item imports with multiple matches are added to the bad-scans page where the user is free to resolve bad scans using item lookup. |
| 29559 | Items not being found for PI sheet filter when filtering by department name that has a '"/" character. | 2.5.1.22 | Departments containing "/" within their names no longer cause a department to be excluded from the results when creating a Physical Inventory using Department Name, Class Name, and Subclass Name filters. |
| Point of Sale | |||
| 30287 | Copy document issue with spread discount | 2.5.2.1538 | No more errors when copying the document with spread discount. |
| 29899 | Central balance is called excessively. The system calls central customer credit balance every item added to the receipt. | 2.4.1.1089 | The system no longer calls the Central Customer Store Credit Balance endpoint each time an item is added to the transaction. |
| 28319 | Users are unable to return a document with just fee on it. | 2.4.1.1024 | Transaction Details is refreshed after returning to the transaction without selecting an item in the "return item" modal. This allows users to return a document that includes a fee but no items. |
| Point of Sale - Associates | |||
| 30223 | Cashier ID does not update to newly logged-in cashier after session timeout on new receipt screen. | 2.5.2.1538 | POS - Cashier ID correctly updates the newly logged-in cashier after session timeout on new receipt screen. |
| POS - Items | |||
| 30764 | Return that references original receipt uses incorrect price level. | 2.5.3.2061 | Return with original receipt reference uses correct price level now. |
| 30001 | Possible to add duplicate serial numbers to a receipt. | 2.5.2.1515 | Users can no longer add duplicate serial numbers. |
| 29165 | Unable to void item when "Restrict Transactions to a single item type" is enabled | 2.5.0.1482 | Now users can void an item when "Restrict Transaction to a single item type" preference is enabled. |
| POS - Orders | |||
| 30090 | Committed records are not removed when an order with unfilled quantities is closed. | 2.5.2.1515 | Committed records are correctly removed when an order is closed containing unfilled quantities. |
| 28656 | Unfilled quantities on closed orders are still showing as committed. | 2.4.1.1055 | Now unfilled quantities on closed orders do not show as committed. |
| 28325 | Add a filter option to the Transaction Lookup filter screen to search based on Ship To Customer. | 2.4.1.1013 | The "Ship To Customer" filter option has been successfully added to Transaction Lookup, and it is working as expected. Transactions are now correctly filtered using both Bill To and Ship To customers. |
| POS - Tender | |||
| 30866 | When using the Quick Tender theme, tender buttons overlay transaction details with odd number of active tenders | 2.5.3.2071 | Quick Tender buttons now show correctly. |
| Preferences | |||
| 30569 | There is no sequencing for Special Order in the Admin Console | 2.5.3.2011 | This release of Prism introduces a separate Document Sequence number for Special Orders. As for other orders, this sequence can be set in Admin Console at different levels (subsidiary, Store or Workstation) to differentiate this sequence from other order sequences. Please see the documentation for more details. |
| 29563 | (Centrals) Gift Cards: The max length of Centrals Gift Card numbers and Gift Card numbers in Preferences is tied together and it should not be. | 2.5.1.25 | The preference for the max field length (max # of digits) for Central Gift Card has been un-linked for the same preference in (EFT) Gift Cards, allowing the user to set different fields lengths for Gift Cards and Centrals Gift Cards. This preference can be found in Admin Console > Node Preferences > Transactions > Tenders > Requirements, Centrals Gift Card/Gift Card. |
| Promotions | |||
| 30806 | Coupon promotion not spreading discount correctly. | 2.5.3.2066 |
Spread discount is now working correctly. |
| 30240 | When a BOGO promo is applied, Prism should not apply any discount until all qualifying items have been scanned (e.g., Buy 3, Get 2, apply discount only after the 5th item is scanned). | 2.5.2.1538 | A new configuration option, "Require All BOGO Rewards," has been added to provide greater control over how Buy‑One‑Get‑One (BOGO) promotions. See the What's New document for details. |
| 30144 | Unable to use Promotion with DCS filter after upgrade. | 2.5.2.1515 | Promotions with DCS filter are working correctly after upgrading from version 1.14.7 to 2.5.4. |
| 28694 | Tiered Discounts have a limit of 9,999,999 | 2.4.1.1034 | Max values in Transaction Tiered Reward Options have been expanded to accommodate currencies like the Indonesia Rupiah. The Subtotal field has been expanded to allow 99,999,999,999.9999 The Value field of Tiered Discount Reward rules have been expanded to allow 99,999,999,999.9999. The Max Discount Amount has also been expanded to allow 99,999,999,999.9999. |
| 26427 | When auto generating coupon codes, define the length and generate either numeric/alpha numeric or alpha character coupon codes. | 2.1.2.569 | When creating a new coupon set, there are two new options: 1) Coupon Type: Numeric (default), Alphabetic, or Alphanumeric. 2) Code length: Determines how many characters the generated code will be. |
| Purchasing | |||
| 30697 | Order Date, Ship Date and Cancel Date fields revert back one day when using the calendar to set a date in the future month. | 2.5.3.2059 | The selected calendar date will remain exactly as chosen. |
| 30676 | Recalculate SRO is picking up PO order values off of POs that are not saved yet. | 2.5.3.2061 | Confirmed the SRO values are unaffected by purchase orders that have not been saved, including POs in progress and POs that are on hold. |
| 30197 | Selected calendar date for PO Order Date/Ship Date/Cancel Date will revert to the day prior. | 2.5.2.1515 | Now when selecting a calendar date for PO Order Date/Ship Date/Cancel Date, it will not revert to the day prior. |
| 30035 | Advanced Inventory Lookup fails when "Restrict to One Vendor per PO/Voucher" Is enabled and Vendor Code contains special character. | 2.5.2.1515 | Advanced Inventory Lookup works correctly when "Restrict to One Vendor per PO/Voucher" is enabled and Vendor Code contains a special character. |
| Receiving | |||
| 31015 | Reverting a voucher to an ASN does not reverse the quantity. | 2.5.3.2072 | When the Preference 'After voucher is updated go to' is set to 'Former Voucher' in System Preferences > Node Preferences > Purchasing > Vouchers, the 'Cancel button is disabled. Previously, it was inadvertently left enabled. |
| 30953 | Unable to spread cost on Vouchers | 2.5.3.2072 | The problem with spreading cost on vouchers was related to an error in the SQL install scripts. The problem has been corrected. |
| 29984 | When generating a voucher from an ASN with 200 line items, quantity changes made on pages beyond page 2 are not retained and the Total and Subtotal fields do not update in real-time as quantities are modified | 2.5.2.1515 | Quantity changes now correctly affect doc totals on voucher with a large number of items. Changes to quantities remain saved through pagination. |
| 29880 | Price not transferred to ASN/Voucher when item is added via Search instead of PO Items. | 2.5.1.33 | When an item is added to an ASN or VOUCHER that has a referenced PO, it takes on the price/cost that were on it on the PO. |
| Replication | |||
| 30620 | Make replication use memory cache | 2.4.0.2005 | Improvements have been made to replication in order to enhance performance. The key change was to load the subscriber list into memory. The impact is that subscriber memory cache is refreshed (by default) at 5-minute intervals. Changes to subscribers in the Connection Manager will not take effect until the next time the subscriber cache is refreshed, or Prism Replication Service restarts. See the What's New topic for more information. |
| Sales Quotes | |||
| 30300 | Add support for sales quotes. | Feature | This Prism release introduces sales quotes in both the new and legacy client. Please refer to the What's New topic. |
| Tag Printing | |||
| 30662 | The printing tags are not in order if the listed items on the document are sorted | 2.5.3.2061 | Tag printing now honors the order the items are currently sorted to in the document. |
| Touch POS | |||
| 30286 | Touch POS doesn't ask for quantity on decimal quantity items | 2.5.2.1548 | User is now correctly prompted for decimal quantity when adding a decimal quantity item in Touch‑Menu POS. The number of decimal places shown in the Qty‑Entry modal is now handled correctly. The system uses the lesser of the following two values:
|
| Transfers | |||
| 30424 | On Hand and Available Qty check issue on transfer slip | 2.5.2.1550 | On hand quantity checks and available quantity checks on slips now correctly trigger when the qty is exceeded. The user is presented with options to proceed with the added amount, revert to the on hand/available quantity or to cancel. |
| 30118 | TO No will remain populated on slip record when TO does not exist | 2.5.2.1515 | Whenever a user enters an invalid TO# into the TO No field on a transfer slip, the field is now cleared and the user is notified. |
| 29896 | Cursor moves to top of TO allocation grid when assigning qty to items | 2.5.1.22 | The user is now able to move freely within the allocation grid while editing and changing values therein. |
| 29583 | Transfer slip quantity checks are not accurate, and canceling out does not remove the item. | 2.5.1.22 | On-hand quantity checks on slips now correctly trigger when the quantity is exceeded. The user is presented with options to proceed with the added amount, revert to the on-hand quantity, or cancel. |
| 29514 | File import bypasses on-hand quantity validation on transfer slip for users without bypass permission. | 2.5.0.1488 | The system now checks when a transfer slip is updated, triggering for bypass_qty checking permission if the qty of any item on the slip exceeds the onhand or available quantity. |
| 28798 | Pending slips are shown in Transfer Slip Lookup via the Options button. | 2.4.1.1061 | Slip lookup via the Options button now behaves the same as slip lookup from the main menu (no longer shows incomplete slips). Pending or held slips are only shown in Pending Slip Lookup. |
| 28638 | Add Store Code field in Transfer Verification | 2.4.1.1055 | From Store Code and To Store Code have been added to the Transfer Slips pane of Transfer Verification. |
| Wishlists | |||
| 30913 | Wishlist Registry: Cannot add decimal qty item to wishlist | 2.5.4.1190 | Decimal items can now be added to wishlists. |
| 30693 | ‘Add Items From Wishlist' via Options button disabled. | 2.5.3.2067 | The 'Add Items From Wishlist' button via the Options button is now enabled when a user belongs to a group with the permission 'Customers - Access Wishlist' set to ALLOW. |
| X/Z-Out | |||
| 30823 | 'Disable display of negative Discount %' setting causing Price and Dip_Price to not match when item is manually given price discount | 2.5.3.2071 | When the setting 'Disable display of negative Discount %' is enabled and the listed item is manually given a price discount, the Price and Dip_Price fields on rps.document_item table now match correctly. X/Z-Out report now displaying correct values |