Why:
Also known as the Inventory Value Report, this option displays details of the inventory value of stock held at a specific branch. It reports on all product code and product groups held within the Parts Master File.
A separate report is produced for each product code registered within the Parts Master File, a total inventory value for the branch is displayed on each report.
Each report displays a summary value of the product code and a summary value including WIP.
The summary value is split between each relevant obsolescence code.
This option allows you to create a report detailing stock inventory values, by replacement and average cost or retail price including obsolescence details.
Additional reports may also be produced, if requested, detailing rate of turnover, parts W.I.P. and sales totals for the last 12 months.
Where:
From the Part View, select Reports > Stock Valuation.
How to Report on Stock Valuation:
Make selections for the following criteria.
|
Criteria |
Purpose / Description |
|
Branch code |
|
|
Product code |
Select value you wish to report on or leave blank for all. |
|
Supplier code |
A search facility is available here. |
|
Price to Use |
Replacement - Shows replacement costs corresponding to current purchase prices as quoted by your supplier. Average Cost - Shows average cost as an average value for the remaining parts in stock (which may have come from several deliveries made at different prices). Retail - Shows retail cost bought in from the supplier. |
|
Turnover Report Required |
Make a selection from the three options. (The system defaults to ‘1’ for ‘Turnover Report Required’. This default is controlled by parameter PRP 001 - Parts Rep PC130.) |
|
Obsolescence calculation |
Obsolescence calculation options may also be displayed, depending on a parameter setting (OBS008). The Obsolescence tab may be selected which will display a temporary obsolescence override screen, allowing you to amend the duration figures without having any effect on the live data. |
Related Topics:
Stock Valuation Imprest Report