Roll-up Stock Valuation

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:

  1. Navigate: From the Oracle Retail Xstore Office Home screen > Data Management > Roll-up Stock Valuation.

  2. If needed, change the Fiscal Year field.

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

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