Go to primary content
Oracle® Retail Xstore Point of Service Reports Guide
Release 18.0
F10772-03
Next
Contents
List of Figures
List of Tables
Title and Copyright Information
Send Us Your Comments
Preface
Audience
Documentation Accessibility
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