# Pull your Simphony reports into your own systems

> Read the Daily Operations report, guest checks and the checks with voids or discounts from Reporting and Analytics with one API call each. A workflow can collect the previous business day for every location each morning and email you the totals.

Page: https://fous.com/automate/oracle-micros-simphony-reporting-and-analytics
Updated: 2026-11-12

Works with your own Oracle MICROS Simphony Reporting & Analytics account. Fous is an independent product.

## What you can build on Reporting and Analytics

### Get the Daily Operations report

Runs the Daily Operations report for one location and business date and reads its sales and labor figures and its Adjustments section.

- Takes: Location, business date
- Returns: Net sales, check count, total discounts, voids, manager voids, returns, error corrects, cancels, labor cost, labor cost percent

### Search guest checks

Uses Reports > Guest Checks to find the checks at one location that match a business date range and other criteria, and opens each Check Detail.

- Takes: Location, business dates (up to 7 days), check number, check employee, check total (optional)
- Returns: Check number, business date, check employee, revenue center, order type, tender type, discounts, check total

### Get checks with voids or discounts

Opens All Checks with Voids, All Checks with Manager Voids or All Checks with a Discount for one location and business date.

- Takes: Location, business date, kind (voids, manager voids or discount)
- Returns: Check number, check employee, item or discount name, amount, check total

### Run a report from My Reports or Library

Opens a report from My Reports or Library, such as Labor Summary or Time Card Summary, runs it for the locations and dates given and reads its table.

- Takes: Report name, locations, start date, end date
- Returns: Report name, location, date range, the report's rows with its column names

## Automate Reporting and Analytics with a workflow

A [workflow](/product/workflows) runs your methods as one process, with nobody at the screen. A schedule or a call from your own system starts it, the steps run in order, and the result arrives in your inbox or in the systems you already use.

### Previous business day's Daily Operations, every location

Starts: Every day at 7:00 in your time zone

1. For each location you name, get the Daily Operations report for the previous business date.
2. Keep net sales, check count, total discounts, voids and labor cost percent.
3. Email you one table with a row per location.

### Manager voids and discounts, sent to loss prevention

Starts: Every day at 8:00

1. For each location, get the checks with manager voids and the checks with a discount for the previous business date.
2. Keep the checks above the amount you set.
3. Post each check, with location, check employee and amount, to your loss prevention webhook.

### Weekly Labor Summary, sent to your payroll system

Starts: Every Monday at 6:00

1. Run the Labor Summary report for the previous Monday to Sunday for each location.
2. Group the rows by location in an AI step.
3. Post the result to your payroll system's webhook.

You can run a workflow by hand on every plan, Free included. Schedules and webhook triggers come with the paid plans, from $29 a month.

## Once built, one call from your code

Once you have built a [method](/product/methods), it is one POST to /v1/runs from your backend, or a tool an AI agent calls over MCP. This is what “Get the Daily Operations report” would look like.

Example request:

```
curl https://api.fous.com/v1/runs \
  -H "Authorization: Bearer $FOUS_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "method": "oraclemicros.com/get_daily_operations",
    "input": {
      "location": "Northwind Grill Downtown",
      "business_date": "2026-11-11"
    }
  }'
```

Example response:

```
{
  "status": "completed",
  "data": {
    "location": "Northwind Grill Downtown",
    "business_date": "2026-11-11",
    "net_sales": 18420.55,
    "check_count": 612,
    "total_discounts": 486.2,
    "voids": {
      "count": 9,
      "amount": 131.4
    },
    "manager_voids": {
      "count": 3,
      "amount": 58.75
    },
    "returns": {
      "count": 1,
      "amount": 12.5
    },
    "error_corrects": {
      "count": 14,
      "amount": 96.3
    },
    "cancels": {
      "count": 2,
      "amount": 21
    },
    "labor_cost": 4973.55,
    "labor_cost_percent": 27
  }
}
```

An example with invented data, not a ready-made endpoint. The method exists in your organization once you build it, and its name, inputs and fields follow your request.

## Reporting and Analytics’s own options

Oracle documents a Business Intelligence REST API that reads the Reporting and Analytics database: daily and quarter-hour totals, guest checks, labor, kitchen, cash management and fiscal data. It needs an API account added in Reporting and Analytics. Self-service exports deliver files by SFTP or HTTPS, and Report Mail emails scheduled reports.

| Option | What it covers | What it takes |
| --- | --- | --- |
| Business Intelligence API | Daily and quarter-hour totals, guest checks, time cards, kitchen performance, cash management and fiscal transactions, by location. | An API account added by a user with the Manage API Accounts privilege, scoped to an organizational level or chosen locations. |
| Self-service exports | A query you configure, run on a schedule or on demand, delivered as a file to an endpoint through SFTP or an HTTPS post. | An export configuration, a location group, a delivery profile and an export schedule set up on the Exports tab. |
| Report Mail | Runs a report at a set date and time and emails it to a person or role. Chart visualizations are not included. | A report mail schedule set up in Reporting and Analytics. |
| Reporting and Analytics by hand | Reports from My Reports or Library, exported to Excel (.xlsx), CSV or PDF, and the Guest Checks search. | A user account with the data permissions each report needs, such as Sales and Operations or Labor. |

Read on November 12, 2026: [Adding a Business Intelligence API Account](https://docs.oracle.com/en/industries/food-beverage/back-office/20.1/rause/c_BI_API_permissions.htm), [Export Data from Reporting and Analytics](https://docs.oracle.com/en/industries/food-beverage/back-office/20.1/rause/c_export_data.htm), [Business Intelligence API Guide: All REST Endpoints](https://docs.oracle.com/en/industries/food-beverage/back-office/20.1/biapi/rest-endpoints.html).

## Signing in to Reporting and Analytics

Reporting and Analytics asks for your user name and enterprise name, then your password, or sends you to your company's own sign-in page when it uses single sign-on. Each company has its own address with its short name in it. With Fous you sign in through that page with your own account: the login is sealed with AES-256, code and AI agents never see it, and with password sign-in an expired session is signed back in.

## Worth knowing

- **Guest Checks searches cover 7 days at most**: The business date range in Reports > Guest Checks is limited to 7 days, and the discount name filter appears only after you pick a location.
- **Daily Operations has several versions**: Daily Operations has separate versions for quick service and table service restaurants, and for add-on and inclusive tax. Build the method on the version your locations use.
- **Permissions decide what a report shows**: Daily Operations needs the Sales and Operations and Labor permissions, and Guest Checks needs Sales and Operations. A method sees only what your user's permissions allow.
- **API accounts cannot sign in to the site**: A Business Intelligence API account gets an Invalid credentials error on the Reporting and Analytics sign-in page. It is scoped to a level or to locations, and a location list is not updated when locations are added.

## More in Food service, restaurants and alcohol

- [SGWS Proof](https://fous.com/automate/sgws-proof.md)
- [Provi](https://fous.com/automate/provi.md)
- [myCoke](https://fous.com/automate/mycoke.md)
- [BEES](https://fous.com/automate/bees.md)
- [METRO Online-Kundenkonto](https://fous.com/automate/metro-online-kundenkonto.md)
- [Sligro](https://fous.com/automate/sligro.md)
- [Deliveroo Partner Hub](https://fous.com/automate/deliveroo-partner-hub.md)
- [DoorDash Merchant Portal](https://fous.com/automate/doordash-merchant-portal.md)
- [foodpanda Partner Portal](https://fous.com/automate/foodpanda-partner-portal.md)
- [Glovo Manager Portal](https://fous.com/automate/glovo-manager-portal.md)
- [GrabMerchant](https://fous.com/automate/grabmerchant.md)
- [Grubhub for Restaurants](https://fous.com/automate/grubhub-for-restaurants.md)
- [iFood Portal do Parceiro](https://fous.com/automate/ifood-portal-do-parceiro.md)
- [Just Eat Partner Hub](https://fous.com/automate/just-eat-partner-hub.md)
- [PedidosYa Partner Portal](https://fous.com/automate/pedidosya-partner-portal.md)
- [Rappi Aliados](https://fous.com/automate/rappi-aliados.md)
- [Swiggy Partner](https://fous.com/automate/swiggy-partner.md)
- [Uber Eats Manager](https://fous.com/automate/uber-eats-manager.md)
- [Wolt Merchant Portal](https://fous.com/automate/wolt-merchant-portal.md)
- [Zomato Restaurant Partner](https://fous.com/automate/zomato-restaurant-partner.md)
- [饿了么商家版](https://fous.com/automate/ele-me-merchant-backend.md)
- [배민셀프서비스](https://fous.com/automate/baemin-self-service.md)
- [Gordon Ordering](https://fous.com/automate/gordon-ordering.md)
- [PFG CustomerFirst](https://fous.com/automate/pfg-customerfirst.md)
- [Sysco Shop](https://fous.com/automate/sysco-shop.md)
- [US Foods MOXē](https://fous.com/automate/us-foods-moxe.md)
- [Bidfood Direct](https://fous.com/automate/bidfood-direct.md)
- [Brakes](https://fous.com/automate/brakes.md)
- [Transgourmet Webshop](https://fous.com/automate/transgourmet-webshop.md)
- [レストランボード](https://fous.com/automate/restaurant-board.md)
- [OpenTable GuestCenter](https://fous.com/automate/opentable-guestcenter.md)
- [TheFork Manager](https://fous.com/automate/thefork-manager.md)
- [Restaurant365](https://fous.com/automate/restaurant365.md)
- [食べログ店舗管理画面](https://fous.com/automate/tabelog-owner-admin.md)
- [Toast Web](https://fous.com/automate/toast-web.md)
- [Insights C3M](https://fous.com/automate/insights-c3m.md)

Other industries: [Banno Business](/automate/banno-business), [NextGear Capital Account Portal](/automate/nextgear-capital-account-portal), [登記情報提供サービス](/automate/registry-information-service), [FBR IRIS](/automate/fbr-iris), [Alloggiati Web](/automate/alloggiati-web), [Portal Empresarial INFONAVIT](/automate/portal-empresarial-infonavit).

## Frequently asked questions

### Does Oracle MICROS Simphony Reporting & Analytics have an API?

Yes. Oracle documents the Business Intelligence REST API for totals, guest checks, labor, kitchen, cash management and fiscal data. You need an API account added in Reporting and Analytics by a user with the Manage API Accounts privilege. Self-service exports and Report Mail also send data out on a schedule.

### How do I export a report from Reporting and Analytics?

Open the report from My Reports or Library and export it to Excel (.xlsx), CSV or PDF, or print it. For a file on a schedule, set up a self-service export or Report Mail.

### Can I see voids and discounts for every location each morning?

Reporting and Analytics shows them per report: Daily Operations has the counts and amounts, and All Checks with Voids or All Checks with a Discount list the checks. With Fous, a workflow you build can loop over your locations each morning, run those methods and email you or post the result to a webhook.

### Can I find a guest's receipt in Reporting and Analytics?

Yes, through Reports > Guest Checks. Search by business date, check number, check total, employee name or the last 4 digits of a card where your payment setup supports it, then open the Check Detail report to download or print it.

### Is Fous affiliated with Oracle?

No. Fous is an independent product. You use it with your own Reporting and Analytics account, and a method reads and does only what that account can.

Fous is an independent product: it is not affiliated with, endorsed by or sponsored by the operator of Oracle MICROS Simphony Reporting & Analytics (Oracle). The name is used only to say which system this page is about. Something here wrong or out of date? Write to legal@fous.com.
