Contents

List of Figures

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

• Audience
• Related Documents
• Customer Support
• Review Patch Documentation
• Improved Process for Oracle Retail Documentation Corrections
• Oracle Retail Documentation on the Oracle Technology Network
• Conventions

1 Introduction to Base Oracle Retail Xstore Point of Service Reports

• Report Menu Configuration and Security
• How to Access Reports
• How to Access Reports on Xstore Mobile
• About Net Sale Calculations
• About Gross Sale Calculations

2 Report Options

• Report Date Options
  • Understanding the Date Range Field
    • About Reporting Dates
  • Saving a Report with Date Criteria
  • Saving a Report with Fixed Dates
  • Saving a Report with Relative Dates
• Selecting Non-Date Report Criteria
• Running a Report
• On-Screen Report Navigation Options
• Report Run Rules
• Making Your Saved Reports Reusable
• Saving a Report
  • View Saved Reports
  • Report Printing Options

3 Daily Sales Reports

• Flash Sales Reports: Overview
• Flash Sales Summary Report
  • Criteria Selections for the Flash Sales Summary Report
• Flash Sales by Department Report
  • Criteria Selections for Flash Sales by Department Report
• Flash Sales by Hour Report
  • Criteria Selections for Flash Sales by Hour Report
• Flash Sales by Employee Report
  • Criteria Selections for Flash Sales by Employee Report
• Daily Sales Report
  • Criteria Selection for Daily Sales Report
• Daily Sales and Cash Report
  • Criteria Selections for Daily Sales and Cash Report

4 Sales Analysis Reports

• Employee Productivity Report
  • Criteria Selections for Employee Productivity Summary Report
• Sales by Hour Report
  • Criteria Selections for Sales by Hour Report
• Sales by Department Report
  • Criteria Selections for Sales by Department Report
• Sales by Department and Employee Report
  • Criteria Selections for Sales by Department and Employee Report
• Sales by Hour Analysis Report
  • Criteria Selections for Sales by Hour Analysis Report
• Tax Exemption Report
  • Criteria Selections for Tax Exemption Report
• Journal Report
  • Criteria Selections for Journal Report
• Line Void Report
  • Criteria Selection Options for Line Void Report
• Post Void Reports
  • Criteria Selections for Post Void Reports
• Transaction Cancel Reports
  • Criteria Selections for Transaction Cancel Reports
• Price Override Report
  • Criteria Selections for Price Override Report
• Suspended Transaction Reports
  • Criteria Selections for Suspended Transaction Reports
• Sales Goals Report
  • Criteria Selections for Sales Goals Report
• Merchandise Sales Analysis Report
  • Criteria Selections for Merchandise Sales Analysis Report

5 Store Accounting Reports

• Cash Drawer Reconciliation Report
  • Criteria Selections for Cash Drawer Reconciliation Report
• Associate Reconciliation Report
  • Criteria Selections for Associate Reconciliation Report
• Cash Drawer Audit Report
  • Criteria Selections for Cash Drawer Audit Report
• Cash Drawer Report
  • Criteria Selections for Cash Drawer Report
• Paid In/Paid Out Report
  • Criteria Selections for Paid In/Paid Out Report
• No Sale Report
  • Criteria Selections for No Sale Report
• Credit Card Report
  • Criteria Selections for Credit Card Report
• Gift Certificate Report
  • Criteria Selections for Gift Certificate Report

6 Product-Oriented Report

• Best Sellers Report
  • Criteria Selections for Best Sellers Report
• Returned Merchandise Report
  • Criteria Selections for Returned Merchandise Report
• Price Change Report
  • Criteria Selections for the Price Change Report

7 Order Tracking Reports

• Special Orders Report
  • Criteria Selections for Special Orders Report
• Order Status Report
  • Criteria Selections for Order Status Report
• Unfulfillable Order Status Report
  • Criteria Selections for Unfulfillable Order Status Report

8 Layaway Reports

• Layaway Aging Reports
  • Criteria Selections for Layaway Aging Reports
• Layaway Account Activity Reports
  • Criteria Selections for Account Activity Reports

9 Labor Management Reports

• Payroll Reports
  • Payroll Summary Report
    • Criteria Selections for Payroll Summary Report
  • Payroll Detail by Employee Report
    • Criteria Selections for Payroll Detail by Employee Report
• Posted Timecard Report
  • Criteria Selections for Posted Timecard Report
• Open Timecard Report
  • Criteria Selections for Open Timecard Report
• Employee Performance Report
  • Criteria Selections for the Employee Performance Report
• Employee Schedule Report
  • Criteria Selections for Employee Schedule Report
• Employee Time Off Summary Report
  • Criteria Selections for Employee Time Off Summary Report
• Employee Tasks Report
  • Criteria Selections for the Employee Tasks Report

10 Inventory Reports

• Inventory Movement Report
  • Criteria Selections for Inventory Movement Report
• Inventory Stock Cost Report
  • Criteria Selections for Inventory Stock Cost Report
• Shipping/Receiving Exception Reports
  • Criteria Selections for Shipping/Receiving Exception Reports
• Shipping Manifest Report
  • Criteria Selections for Shipping Manifest Report
• Receiving Report
  • Selections for Receiving Report
• Restock Report
  • Criteria Selections for Restock Report
• Item List Report
  • Criteria Selections for Item List Report
• Inventory Movement Pending Report
  • Criteria Selections for Inventory Movement Pending Report
• Inventory Movement History Report
  • Criteria Selections for Inventory Movement History Report
• Inventory Adjustment Report
  • Criteria Selections for Inventory Adjustment Report
• Open Product Request Summary Report
  • Criteria Selections for Open Product Request Summary Report
• Replenishment Product Request Report
  • Criteria Selections for Replenishment Product Request Report
• Replenishment Order Worksheet
  • Criteria Selections for Replenishment Order Worksheet
• Shelf Labels
• Store Layout
• Inventory Count Sheet
• Inventory Count Variance Reports

11 Consumer Reports

• Customer List Report
  • Criteria Selections for Customer List Report
• Loyalty Account History Report
  • Criteria Selections for Loyalty Account History Report
• Customer Account Activity Summary Report
  • Criteria Selections for CCA Reports

12 Store Locations Reports

• Store Locations Report
  • Criteria Selections for Store Locations Report

13 Gift Registry Report

• Gift Registry Report
  • Criteria Selections for Gift Registry Report

14 Wish List Report

• Wish List Report
  • Criteria Selections for Wish List Report

15 Pick List Report

• Pick List Report
  • Criteria Selections for Pick List Report

16 Airport Report

• Airport Sales Tax Report
  • Criteria Selections for Airport Sales Tax Report

A Appendix: Oracle Retail Xstore Office Reports

• Stock Valuation Overview
  • Period Weighted Average Cost (PWAC)
  • Weighted Average Cost (WAC)
• WAC and PWAC Reports
  • Example: WAC Stock Valuation Summary Report
  • Example: WAC Stock Valuation Detail Report
  • Example: PWAC Stock Valuation Summary Report
  • Example: PWAC Stock Valuation Detail Report
• Roll-up Stock Valuation
• Airport Authority Report
• Dashboard
  • Dashboard Report Example