The Items-on-Hand Valuation Report is provides the cost basis value of inventory stock on-hand as of a specified date.

1. On the Site Map screen, click Inventory Control > Reports > Items-on-Hand Valuation. The Items-on-Hand Valuation Report screen displays.
2. If you have only one asset G/L code, leave the fields Warehouse, Category, Item code, and Location fields set to ALL. If you have multiple asset G/L codes, complete thesefields accordingly for the selected G/L code.
3. In the As of date field, enter the applicable backdate if you are balancing to a previous General Ledger date; this option is only available if you run the Summary or Standard cost report types. Otherwise, press Enter to accept the current Inventory Control processing date.
4. In the Report type section, select the Summary option to print an overview if you are balancing to the General Ledger. Select the Detail option to identify specific prices paid if you use FIFO or LIFO.
5. In the Quantity selection section, accept the Positive/negative default option unless another option is deemed necessary by your standard business practices.
6. In the Discontinued status section, accept the All items default option unless another option is deemed necessary by your standard business practices.
7. Click the Preview button and then go to the past screen of the report. The Total cost column should equal your General Ledger balance. If the numbers don't equal, use the Item History Report as a resource for determining the balancing issue.