Stock Valuation Year End Roll-Up

The end-of-year process is used to post the required rollup data for stock valuation for all items and stores. This closes the item's quantity and value for the specified fiscal year. The consolidated inventory totals are used for the stock valuation (PWAC) reports.

Note:

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 (0).

Overview

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.

End-Of-Year Processing

To access Stock Valuation Year End Roll-up, select Roll-up Stock Valuation from the Data Management menu.

Perform the following steps to post the required rollup data for stock valuation for all items and stores.

1. Enter the Fiscal year that is being closed.

2. Click Roll-up Data.

   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 2011 has been consolidated, you can only consolidate 2012.)

   • Cannot be less than the last consolidated year. (If 2012 has been consolidated you cannot select 2010, but you can select 2012.)

   • 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=2014

   Documents exist in the database for 2009, 2010, 2011, 2012, and 2013

   No consolidations have been done to date

   If 2012 is selected as the closing year, the system will prompt to close previous years (2009, 2010, 2011) first before continuing.