WAC and PWAC Reports

WAC and PWAC Stock Valuation Reports can be run from Oracle Retail Xstore Office. To create the report follow the steps below:

1. Navigate: Oracle Retail Xstore Office Home screen > Reports > All Reports.

2. From the Reports screen navigation panel, select Stock Valuation Reports.

   Figure A-1 Xstore Office - Report Menu Options

   
   

   

   
   

3. 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

4. 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

5. 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.

Example: WAC Stock Valuation Summary Report

Figure A-2 Sample: WAC Stock Valuation Summary Report

Example: WAC Stock Valuation Detail Report

Figure A-3 Sample: WAC Stock Valuation Detail Report

Example: PWAC Stock Valuation Summary Report

Figure A-4 Sample: PWAC Stock Valuation Summary Report

Example: PWAC Stock Valuation Detail Report

Figure A-5 Sample: PWAC Stock Valuation Detail Report