On-Demand Reports Page

The On-Demand Reports page allows the user to select from a list of reports, run the report, and obtain results when the report finishes running.  

Many of the reports require the user to enter additional information that further refines the report. After the report runs, the results are displayed. The report can be exported in several formats. The available formats include: PDF, Microsoft Excel, CSV, RTF, and RPT. 

Report Content

Independent Retailers

 

Reports contain information for your retailer location.

Corporate Account Users Assigned to a Single Location

Reports contain information for the location assigned to your user ID. You cannot run a report for another location, nor can you run a corporate-level report.

Corporate Account Users Assigned to Multiple Locations

If you select a location in the Menu bar, all reports will contain information for only the selected location.

If you do not select a location in the Menu bar, reports will function in one of two ways:

  • If you are running a report that displays a parameter that allows you to select one or more of your assigned locations, the report will run for only the location(s) you selected.

  • If you are running a report that does not display a parameter that allows you to select locations, the report will contain all your assigned locations.

The corporate locations that appear in these reports may include all corporate locations or only specific locations assigned to your user ID.

Oklahoma Lottery Users

If you select a location in the Menu bar, all reports will contain information for only the selected location.

If you select a corporation in the Menu bar, but do not select a location, reports will function in one of two ways:

  • If you are running a report that displays a parameter that allows you to select locations within the corporation, the report will run for only the locations you selected.

  • If you are running a report that does not display a parameter that allows you to select locations, the report will run for all the corporation's locations.

info.gif

The locations you see are assigned through your user name. If you have questions about the locations you are authorized to work with in the gemRetailer intelligence portal, contact the individual within your corporate account or location who manages user administration for the Oklahoma Lottery's gemRetailer.

What You Can Do

Run the 13 Week Sales Report

Run the Activations and Settlements Report

Run the Active Packs Report

Run the Adjustments Report

Run the EFT Settlement Report

Run the Delivered Books Report

Run the Inventory Details Report

Run the Inventory Reconciliation Report

Run the Inventory Summary By Game Report

Run the Issued Packs Report

Run the Packs of Concern Report

Run the Returned Packs Report

Run the Sales Activity Comparison Report

Run the Sales, Cashes, and Commissions Report

Run the Scratch Games Report

Run the Scratch Pack Settlement Report

Run the Scratch Ticket Distribution Report

Run the Winners Report

Export an On-Demand Report