¶¶Òõ

Skip to main content

Back of House: Office Enterprise

403.0 | Office Enterprise

Implementation Date: June 6, 2023

Supplemental Information

HASP is not required.

File Names

  • HDSOE_installer.exe (Install)

    SHA256: A641142FC1F6591D5E11AC9155362C4729FA2805F4DF0101EB71243E21F553CB

  • Update.msi (Upgrade)

    SHA256: 6F36646C8BF4FEC347105A99846F385F92BB8C3660397A224E565E7B237DAFF6

File Locations

External FTP:

  • /Public_HTML/ReleaseSoftware/HDSOE-Back-End/HDXOE/HDXOE_403_00_Install_And_Upgrade_Set/

BranFiles Network:

  • \\bran-files01.sicom.local\ReleaseSoftware\HDSOE-Back-End\HDXOE\HDXOE_403_00_Install_And_Upgrade_Set\

G-Drive:

  • https://drive.google.com/drive/folders/1fJ4Am8cCzgl6S7jCHUiuLVZiKsKlwX40?usp=share_link

Special Notes

  1. If the label for the SEARCH Windows for Item Availability is not added during a fresh database installation of Office Enterprise 403.0, run Product_updates_1398889.xml.

  2. If the Daily Cash Schedule (DCS) Report is not added to the Reports menu during a fresh database installation of Office Enterprise 403.0, run Product_updates_1404447.xml.

  3. Sites using the Daily Cash Schedule (DCS) Report will not see the report under the Reports menu when logged in as a Manager. Run Product_updates_1404447.xml after an upgrade / installation is completed.

  4. After upgrading OE to 403.0, the HDX Reprocess Service needs to be manually started.

Release schedule upon RA Approval:

  • RBI Labs: May 23, 2023

  • Pilot: May 25, 2023

    • 100794 Prince Edward Island

    • 102016 Ontario

    • 102636 Ontario

  • Rollout (Canada-wide):

    • June 6, 2023 - All regions (update.msi, update.msi.done)

    • June 7, 2023 - All regions (Product_updates_1404447.xml)

Improvements

FPFD-3608

Item Availability now sorts the Item List by PLU Name and searches by PLU Name.

FPFD-3609

The Search window for Excluded and Available Items is now properly labeled when the Item Availability - OTHER tab is accessed.

FPFD-3613

The user is now able to successfully generate the Daily Cash Schedule report after a clean database installation.

FPFD-3785

The TLog reprocess service is updated to only reprocess POS devices.

FPFD-3786

On a clean database installation, the Database Maintenance module now properly creates the RBIEXPORT tables in the XXXXX_HDSOfficeSales databases.

FPFD-3787

The Database Maintenance module is updated to prevent the addition of incorrect strings for Item Availability during a database update.

Required Product Updates

  • Product_updates_1398889.xml - Adds the Item Availability Search Button strings (if missing).

  • Product_updates_1398891.xml - Adds / updates the Daily Cash Schedule (DCS) Report if it is missing or if it generates a MENU CALL error.

Database / Additional Fields Required

Adds the RBIEXPORT and RBIEXPORTLOG tables to the XXXXX_HDSOfficeSales database (if missing).

402.0 | Office Enterprise

Implementation Date: March 23, 2023

Supplemental Information

HASP is not required.

File Names

  • HDSOE_installer.exe (installer)

  • Update.msi (upgrade)

Special Notes

  1. Fingerprints POS 2.113.0 (or greater) is required.

  2. This build is subject to RA Approval.

  3. RBI has not approved release of this build to Pilot or Production, so this build cannot be transferred to the External FTP, Branfiles Network or G-Drive locations.

Released to:

  • RBI Lab 30250 (March 3, 2023)

  • RBI Lab 31994 - 31999 (March 3, 2023)

  • RBI Lab 31901 - 31909 (March 21, 2023)

Improvements

FPFD-3501

Office Enterprise Retrieve stream now returns the new loyalty reimbursement columns to OE sales tables.

FPFD-3502

Office Enterprise Daily Cash Schedule report now includes loyalty redemption transactions.

FPFD-3505

Office Enterprise Employee Sales Summary now includes a breakdown of loyalty redemption transactions.

FPFD-3636

Added table orderOnlineCoupons to xxxx_HDSOfficeSales database (Office Enterprise databases).

FPFD-3643

Update to Retrieve stream to not log the DB password when logging is set to verbose (0).

FPFD-3668

Added strings for Daily Schedule Report to Office Enterprise Database Maintenance.

Required Product Updates

The following Product Updates may be necessary to support the Item Availability module:

FPFD-3701

Product_updates_1360774.xml: Addresses error related to the Apply button on the Other tab of Item Availability.

FPFD-3715

Product_updates_1360826.xml: Addresses issue with NULL values in tbl_staircasing.

FPFD-3716

Product_updates_1360828.xml: Removes departments with ID "-".

Database / Additional Fields Required

RDSofficeSales Database

DaySummaryTable

  • loyaltyReimbursementAmount

  • loyaltyNonReimbursementAmount

  • voidloyaltyReimbursementAmount

  • voidloyaltyNonReimbursementAmount

  • refundloyaltyReimbursementAmount

  • refundloyaltyNonReimbursementAmount

  • voidrefundloyaltyReimbursementAmount

  • voidrefundloyaltyNonReimbursementAmount

ShiftSummary Table

  • loyaltyReimbursementAmount

  • loyaltyNonReimbursementAmount

  • voidloyaltyReimbursementAmount

  • voidloyaltyNonReimbursementAmount

TempEmpSummary table (when used)

  • loyaltyReimbursementAmount

  • loyaltyNonReimbursementAmount

  • voidloyaltyReimbursementAmount

  • voidloyaltyNonReimbursementAmount

  • refundloyaltyReimbursementAmount

  • refundloyaltyNonReimbursementAmount

  • voidrefundloyaltyReimbursementAmount

  • voidrefundloyaltyNonReimbursementAmount

Transactions Table:

  • loyaltyReimbursementAmount

  • loyaltyNonReimbursementAmount

XXXXX_HDSofficeSales Database

EmpShiftSummary Table:

  • loyaltyReimbursementAmount

  • loyaltyNonReimbursementAmount

  • voidloyaltyReimbursementAmount

  • voidloyaltyNonReimbursementAmount

  • refundloyaltyReimbursementAmount

  • refundloyaltyNonReimbursementAmount

  • voidrefundloyaltyReimbursementAmount

  • voidrefundloyaltyNonReimbursementAmount