June 2023 Mosaic Release Notes

Application updates from April 20, 2023 – May 21, 2023

Release to production: June 7, 2023

Release notes statement 

New functionality added to Mosaic, is controlled by feature flags to ensure readiness prior to use in production environments. Throughout release notes the phrase “If enabled” is used to designate capabilities that may be turned on or off. Such options may be released for a limited audience or dependent upon additional updates. These options will still be referenced in release notes to make clients aware all new application capabilities. 

Buyer’s Guide

Texas Book Company (TBC) Buyers Guide Integration: Mosaic now supports the parsing and importing of buyers guide information from the Texas Book Company (TBC) to replace the now deprecated Nebraska Book Company (NBC) buyers guide.
Added support for additional buyers guide formats in Mosaic. Introduced the ability for course materials managers to access up-to-date buyers guide information from different sources. Mosaic now allows the selection of a Guide Source from the Administrator > Buyers Guide menu. This enhancement progresses Mosaic toward also supporting a Missouri Textbook Exchange (MBS) buyer’s guide.

Sales Events

These updates provide store managers with an improved interface for creating and managing sales events, ensuring more efficient control and visibility over discounted items.

A new "Sales Events" link has been added to the Administrator menu, allowing for navigation to a new Sales Events landing page. This landing page allows creation of new sales events, the ability to edit existing sales events, the ability to search sales events, and the ability to filter results by status and date range.
Introduced Add/Edit Sales Event functionality including fields for Sales Event Name, Sales Location, Discount Type, Amount, Start Date, End Date, and Sales Event Price Rounding. Added Product Attachments card for managing associated products in bulk. Implemented grid view with sortable fields for quick review of product details. Automated the calculation of Event Price based on Discount Type and Amount with a Price Override field for manual price adjustments. Incorporated toggle for activating or deactivating sales events and per product enforcement.
Added a “Filter by DCC” checkbox to the "Add Product" modal on the Sales Events page. When the checkbox is checked, the DCC tree is displayed, allowing users to select specific DCCs to filter the product list to only the items that belong to the selected DCCs
Small UI changes have been made to the Edit > General Merchandise page to set up for expanded sales events functionality: The previous Sales Event modal invoked from the Edit > GM page has been changed to be view-only. The "Edit" button in the modal replaced with "View" button as a result.

Data Exchange

The execution of scheduled data import and export jobs has been enabled. You can specify the data source and destination, as well as the frequency of the transfer. The scheduler will execute the job automatically at the designated time, with the ability to monitor job progress via a Job Log and receive notifications in case of errors or failures as you continue to use Mosaic.
The "Last Run" column in the Data Exchange Job Log has been renamed to "Run Date" for accurate representation. Job message details in the UI are now sorted by default chronologically by CreateDate and Job ID. The exported CSV file now uses the "Run Date" column instead of "Last Run" for consistency.
Data Exchange Job names are limited to 50 characters and can only contain alphanumeric characters, dashes, underscores, and spaces.

Purchase Orders

Purchase unit logic has been updated, and suppliers that have products and purchase units set up on the Supplier tab of Edit General Merchandise page will now increase/decrease the SOH by the purchase units specified upon receiving.
- This change fixed an issue where the stock on hand (SOH) was not correctly adjusted when receiving a purchase order if purchase unit was greater than 1. For example, when a product with a purchase unit of 12 is added to a purchase order for a supplier, the quantity ordered now adjusts the SOH by 12 per unit.
- The cost association for products sold as 1 is now correctly reflected in the purchase unit.
- If a supplier is not set up for a product, or a product has no purchase unit specified , the default purchase unit is set to 1.
To help clients better communicate with their suppliers, purchase orders now contain a reference number to the right of the page, under the shipping information. This reference number is alphanumeric and can be set in the Edit Purchase Order screen.

Product Management

On pages with product search capabilities, implemented a fix to ensure catalog number search criteria presents all products associated with the catalog number are correctly displayed in the search results.
Added "Last sold: <date, time>" information to the Edit Book and GM product pages in the Product Maintenance section. The Edit Book page now displays the Last Sold Date alongside each type of book in the user interface. The Edit GM page includes the Last Sold date in the product grid after the Sales Event information.
When editing a long description under the Online Profile in Product Maintenance screens, users will now see an HTML-friendly WYSIWYG (What You See Is What You Get) editor. This editor allows you to easily format and style the text of your long descriptions.

Tag Printing

Redesigned the Print Label capability for improved workflow efficiency:
- Added a product description heading to Print Label modal to provide clear identification of the tag(s) being worked
- Introduced an "Add Qty" box for all products, allowing users to bulk-enter a tag quantity for all SKUs, common or matrix.
- Implemented a grid displaying products associated with the selected family, maintaining the same sort order as the edit GM matrix screen.
- For each SKU the Print Label grid includes the default barcode, variant options, and a quantity box to enable SKU level printing.
- Improved tab navigation within the quantity fields for easier data entry.
- Added ‘Cancel’ and ‘Print’ buttons for managing tag printing actions.
Added support for displaying variants on barcode price tag stickers. Removed the store name from the GM tag type to save space and improve readability. Now, if variants exist for a product, they will be listed on the price tag. The maximum length for each variant is now 25 characters, allowing for 12 characters for Variant 1 and 12 characters for Variant 2. Special characters are also now allowed for variants.

Emailed Receipts

When a receipt was emailed from the register with a Mosaic backend, the item description was displaying "Unknown" instead of the item details. This has been fixed so that the correct item details is displayed on the receipt.
Fixed an issue where emailed receipts were not displaying the Date and Time of the transaction correctly. Previously, the receipt only showed a " )" instead of the actual Date and Time. Now the Date and Time of the transaction will be accurately displayed in the emailed receipts.

Bug Fixes and Miscellaneous Improvements

introduced a barcoded representation of the web order number at the top right corner of the pick list so users can scan the web order number from picklist using a barcode scanner. The barcode supports letters and numbers, and scanning the barcode returns the same value as the printed web order number. Other small visual enhancements were made to accommodate the barcode addition and improve visual clarity and organization of the picklist.
Fixed an issue where importing the Customer AR file failed when certain fields with a decimal value greater than .01 were present (specifically Customer Balance and Credit Limit). Previously decimal values caused an import failure or truncation.
The Customer Balance and Credit Limit fields shown with accounts are now formatted as currency for improved readability.
Fixed an issue where tax rates were duplicating in the view of the Mosaic tax rates page for localities with names containing "City," "State," or "County. While this bug did not result in any incorrect tax calculations, the fix ensures accurate rates are being displayed in Mosaic.
Added a Customer Active / Inactive flag under Mosaic > Edit Customer Profile. Store managers can now mark customers as "Inactive" to control various areas of Mosaic and POS. Customers are active by default. In Edit Web Orders, inactive customers are displayed as "Customer is inactive" in bold red, and the "Work order" button is disabled until the customer is activated. In future development, PrismPOS will use the customer flag to control behavior too.
To streamline new tenant setup, non-customer facing processes were streamlined via application updates.