The reports in this Appendix are only available in Oracle Retail Xstore Office, not Oracle Retail Xstore Point of Service.
Stock Valuation is a process that allows you to track the item stock value for receivables at the store for both corporate-created receiving documents and store-created receiving documents. This inventory valuation allows you to determine a monetary value for items that make up your inventory, and is dependent on a "year-end" process for the company. Stock valuation is based on the fiscal calendar.
All receiving documents must contain the items' cost to be used to calculate the stock valuation. (The cost is the amount charged to the franchisee/store.) When merchandise is received from the warehouse, the cost on the ASN/receiving document must be accepted or adjusted by the store in order to receive merchandise into inventory.
Note: Store to store transfers must be implemented through the corporate office. The corporate office will be responsible for crediting the shipping stores' cost for the stock, and for applying the proper cost value for each item on the receiving document for the receiving store.Some retailers may elect to carry the cost for corporate stores from the shipping store to the receiving store, but a corporate system will still be responsible for providing the cost per item to the receiving store. |
Prerequisites and Assumptions
The inv_cst_item_yearend table must be populated with data for the previous year. For new retailers with no previous years' data, a record must be added for the previous year with quantity zero This information is required to run the Year End Rollup.
Reports are available from Oracle Retail Xstore Office only.
For reporting, the Arial Unicode MS font must be installed on the system.
Two methods of stock valuation are supported:
PWAC - Period Weighted Average Cost
WAC - Weighted Average Cost
WAC is calculated using the fiscal year-end summary from the prior fiscal year, plus receivings from this fiscal year.
When calculating PWAC for a previous year, the system uses the fiscal year prior to the requested fiscal year, plus the receivables from the requested fiscal year up to the requested date. You cannot simply use the posted values for the requested year since that includes the entire year.
ASN documents are used in the calculations. The status of the ASN document (CLOSED, OPEN, or IN PROCESS) is disregarded.
WAC is calculated using the fiscal year-end summary from prior fiscal years (multiple), plus receivings from this fiscal year, up to the specified stock valuation date. Values from the item_cost_movements table are used to perform the calculations.
When calculating WAC for a previous year, the system uses the years prior to the requested year, plus the receivables from the requested year up to the requested date. You cannot simply use the posted values for the requested year since that includes the entire year.
ASN documents are used in the calculations. The status of the ASN document (CLOSED, OPEN or IN PROCESS) is disregarded.
WAC and PWAC Stock Valuation Reports can be run from Oracle Retail Xstore Office. To create the report follow the steps below:
Navigate: Oracle Retail Xstore Office Home screen > Reports > All Reports.
From the Reports screen navigation panel, select Stock Valuation Reports.
Select a Stock Valuation Report from the list.
WAC Reports:
WAC Stock Valuation Report
WAC Detail report
PWAC Reports:
PWAC Stock Valuation Report
PWAC Detail report
Enter report criteria.
The available Report Parameters are:
Location Hierarchy: If applicable, select a location hierarchy from the list.
Note: Location Hierarchy is not available for WAC and PWAC Detail Stock Valuation Reports. Values are calculated across the company. |
Valuation Date: Enter or select the date of the stock valuation
Department: Select a department Id from the list.
SubDepartment: Select a subdepartment Id from the list.
Class: Select a class Id from the list.
SubClass: Select a subclass Id from the list.
By Item, By Style, or select the All check box to run the report for all items. If running a report for an item or a style, you must specify the Item Id or Style Id in the text box.
Output Format: Select PDF, HTML, or CSV
Click Run Report. The report displays in a new tab. The report will be grouped and ordered by Location, Item: totals per location and grand total.
The end-of-year process is used to post the required roll-up data for stock valuation for all items and stores. This closes the item's quantity and value for the specified fiscal year. This data is used when running reports. To carry out the Roll-up Stock Valuation follow the steps below:
Navigate: From the Oracle Retail Xstore Office Home screen > Data Management > Roll-up Stock Valuation.
If needed, change the Fiscal Year field.
Click Roll-up Data in the Stock Valuation Roll-up section of the Year End Roll-up page.
The system will perform the following validation checks on the Fiscal Year entered:
Must be less than the current fiscal year.
Cannot be greater than the last consolidated year + 1. (The sequence must be respected; if 2009 has been consolidated, you can only consolidate 2010).
Cannot be less than the last consolidated year. (If 2010 has been consolidated you cannot select 2009, but you can select 2010).
If there are no previous consolidations, the system can accept any value less than the current year. (In this case, if there are any documents in the database for the year before the selected year, all documents will be consolidated in the selected year).
Example: Current year=2015
Documents exist in the database for 2010, 2011, 2012, 2013, and 2014
No consolidations have been done to date
If 2013 is selected as the closing year, the system will prompt to close previous years (2010, 2011, 2012) first before continuing.
Confirm that the inventory for all locations has been posted to Oracle Retail Xstore Office.
Note: Select Roll-up Stock Valuation to re-run the data for a closed year. |
The Airport Authority Report shows information about airport store sales.
To create an Airport Authority Report follow the steps below:
Click Reports in the Oracle Retail Xstore Office Home screen.
Click All Reports.
Open the Airport Reports folder.
Click Airport Authority Report.
Enter the Report Parameters:
Store Number (Nbr) – The store numbers to include in the report. Leave blank to include all stores.
Start Date – Earliest date for activity to include in the report.
Output Format – The format in which the report will be created.
Click the Run Report button.
The Report Tab displays. Depending on your output format, you may have to select the hyperlink: Click to Download Report.
Table A-1 Airport Authority Report Parameters
Parameter | Description |
---|---|
Date |
The date the item was sold. |
Flight |
The customer's flight number. |
Item ID |
The item identifier. |
SKU |
The item SKU. |
Item Description |
The item description. |
Final Destination |
The final destination of the customer's flight. |
Quantity |
The item quantity. |
Net Sales |
The item net sales. |
Use the dashboard report to view sale data for individual stores. The dashboard shows enterprise data for a single store, as a static page. If you want to refresh the data, you need to re-run the report.
The header displays the store number, the store name as well as the current business date.
The following data is displayed for the selected store:
Total Sales (Gross Sales, Net Sales, Returns, Discounts, Total Tax)
Sales by Department (top 10)
Sales by Hour
Number of Items (by hour)
Number of Transactions (by hour)
To create the Dashboard report follow the steps below:
In the Oracle Retail Xstore Office, select Reports and then select Dashboard.
In the Store # field, enter the number of the store you want to create the report for.
Then click Run Report.