Stock Valuation
Use this report to show the value of stock items. You can produce the
report in product, warehouse and category sequence and choose whether
you want the costing based on the stock cost, stock last cost, warehouse
cost or warehouse last cost. The report includes information about the
in-stock quantity, cost price selling price and value. Options for the
report determine whether negative or zero quantity stocks are included
and whether the FIFO stock is valued by transaction cost.
Valuation Methods
This report calculates the stock value using the First In First Out
(FIFO) method where possible. This method uses the transaction prices
to calculate a valuation. The FIFO valuation on the report will match
the valuation held in the Nominal Ledger for the relevant period in most
situations. However, in those situations where an item has slipped into
negative stock the valuation on this report may be different.
For items that are linked to Stock
Profiles that are not marked to use the FIFO method, the valuation
is calculated using the cost prices on the stock item or relevant warehouse.
The non FIFO valuation should also match the valuation held in the Nominal
Ledger for the relevant period. However, if the cost price on the stock
item or relevant warehouse has changed the valuations will be different.
This is because the Nominal Ledger is updated using the cost price at
the time of receipt, whereas this report uses the cost price on the stock
item or relevant warehouse on the Produce Report As
At date.
Example
1: FIFO stock
Example
2: Non FIFO stock with standard costing
Example
3: Non FIFO stock with average costing
Traceable stock items can be valued at either the actual cost or an
average cost. Stock items that have
been issued for a works order in the Bill of Materials application, and
landed costs can also be included on the report. More
about Landed Costs
This report can be viewed
on screen, saved as a PDF document or printed. In Opera 3 it can also
be saved as an Excel spreadsheet.
To Print the Stock Valuation Report
Open the Stock folder
and then click Reports
or click the Supply Chain Management
tab on the 
Ribbon Bar and then
click Stock
- Reports.
Click Stock
Valuation.
In the Sequence
list, select the sequence option you want. You can produce the report
in product, warehouse or category sequence, then, depending on the
sequence you have selected, use the From
and To lists
to define the range of records you want included in the print run.
In the Costing
list, select the costing to be used for the report. You can use the
stock cost, stock last cost, warehouse cost or last warehouse cost.
Choose the options from the following:
To include negative stock
in the report, tick Show
Negative Stock.
To include zero quantity
stock in the report, tick Show
Zero Quantity in Stock.
To value FIFO stock by
transaction cost, tick FIFO
Stock By Transaction Cost.
To include traceable stock
at actual cost, tick Traceable
By Actual Cost. Refer to the Traceability
Help topic for information.
To
include work in progress components that have been issued to works
orders in the Bill of Materials application, tick Include
Work In Progress.
To include landed costs
for the stock items that have those costs applied to them, tick
Include Landed Costs. This option is enabled if the Landed Costs
option is selected on the System
- Maintenance - Company Profiles form.
If the FIFO
Stock By Transaction Cost option is ticked, the landed
cost for FIFO stock is calculated from the balance of each
receipt transaction for the stock item.
The landed cost for
non FIFO stock (including serial or batch traceable stock)
is calculated using the Average Landed
Cost price or the Standard Landed
Cost price for the stock record or its warehouse record,
if applicable. This depends on the costing option you choose
from the Costing box.
Click OK.
On the Publisher
form, click the tab to select the output device you want to use and
then complete any settings or options you want to apply to the output
device. To process the output, click Publish.
To
save this report as a Microsoft Excel spreadsheet, select Excel
Report from the Report Layout
box on the Publisher
form.
To save this report as a spreadsheet with combined unit
costs and landed costs, select Excel
Report from the Report Layout box on
the Publisher form.
To save the report as a spreadsheet with separate unit costs and landed
costs, select Extended Excel Report
from the Report Layout box.