Guide: Oracle Simphony - SFTP

How do core concepts map to Tenzo?

Key: ✅ Supported   🚸 Work in Progress   ❌ Not supported

Location	✅ GLID - Store Name
Order Type	✅ OT - Name
Revenue Center	✅ SUM - Revenue Center Name
Product Item	✅ MNPR - Menu Item Name
Product Category	✅ MNPR - Family Group Name
Product Division	✅ MNPR - Major Group Name
Tender Type	✅ TND - Tender Name
Employee	✅ CMI - Tender Employee First & Last Name
Customer	❌ Not supported
Discount	✅ DSC - Discount Name
TicketItemDiscounts	❌ Not supported
TicketDiscounts	✅ CDSC - Discount Name
TicketItemModifiers	❌ Not supported
Guest Count	✅ CHDR - Number of Guests
Transaction length	✅ CHDR -  Check Open & Close Time
Delivery Timings	❌ Not supported
KDS Bump Time	❌ Not supported
Ticket Voids	✅ CHDR - Void Total
Ticket Item Voids	✅ CMI - Is Void Flag
Table	✅ CHDR - Table Reference
Service Charge	✅ CHDR - Service Charge Total
Tips	✅ CHDR - Tip Total
Price	✅ Price from menu items

Data Ingestion

Requirements

The requirements for the Oracle Simphony - General Ledger integration are:

• Oracle Reporting and Analytics version 18.2.9 or higher (e.g. 20.1).

The version number can be found at the bottom left of your Reporting & Analytics WebApp:

How do I connect this data to Tenzo?

Oracle Simphony can be connected directly inside of the Tenzo app.   

If you have an Enterprise Account, you can talk to your Customer Success Manager, who will connect this for you.

How do I compare Oracle Simphony data to data in Tenzo?

The Tenzo Sales module matches the Daily Operations report in Oracle.

In Tenzo you need to have Tax included in the settings:

Tenzo matches to the Daily Operations report in Simphony. This can be found by navigating to Library, then searching for Daily Operations.

There can be reports with the same name. The correct report is the one with reportGroup=1 in the URL:

In this report Tenzo matches the Net Sales number:

Note: The difference between Net Sales and Gross Sales in Oracle is Item Discounts. The Net Sales number includes tax.

Exceptions

Tenzo displays data on the day the transaction is opened. Occasionally there may be transactions which are closed a few days later so there could be a mismatch in this instance, although this is rare.

This can also be true with discounts. Tenzo records data on the day the transaction is opened. If there is a discount applied the next day then the original transaction will still be present on the original day. The discount will be applied on the day after. When reviewing both days together, the transaction will have the aggregated discount applied.