Home > Reports > Screen Shots/Explanations > Stock Valuation Report

Stock Valuation Report

oragball.gif (997 bytes) What Is It?

The report prints stock valuations for each selected item within a location. Stock Value is calculated by multiplying the Stock On Hand by the stock cost (as determined by the Stock Valuation Method on the Stock Control tab of System Settings). If you are using a Stock Valuation Method of FIFO then the report also shows the expected rebates and the nett stock value.

The rate of sale and its stock cover is also reported for each item. Note, the stock cover is for the specific item only and does not take into account linked items.

The items are grouped by department, category and group. Within each group the items are sorted by family group then description. Total values are given at group, category, department and report levels.

The Stock Valuation By Supplier Report prints the same information grouped by supplier then department, category and group. The Stock Valuation Summary Report prints similar information in a summarised format.

Supports selection of data by PDA import. New sort parameter has been added to allow sorting by Department or Supplier.

oragball.gif (997 bytes) Commands

Client - REQUESTREPORTINVENTORY.EXE STOCKVALUATIONREP

Server - REPORTINVENTORY.EXE

oragball.gif (997 bytes) What Are The Report Parameters?

Location

The location for which performance details are required. If a location group is entered, a separate report is generated for each location within the group. This must be entered.

Dept/Cat/Group/SubGroup

All items in the nominated department, category, group and subgroup are selected. You can enter just a department and you get all items in that department.

Brand

The brand of the items to be reported. This does not do an exact search, it does a wildcard search on the first 15 characters of the brand.

Family Group

Only items in this family group are printed. This does not have to be entered.

Classification

Only items which are the same classification as this field are printed. This does not have to be entered.

Supplier

The supplier of the items to be reported. This is based on the supplier with the best cost stored against the location range.

Manufacturer

The manufacturer of the items to be reported. This is based on the manufacturer recorded against the location range.

PDA Import#

The number of the import transactions created on the PDA. This allows you to scan a number of items then get a report based on those items.

Report Items With No Stock

If checked on then items with a stock on hand of zero are printed.

Report Items With Stock

If checked on then items with stock on hand greater than zero are printed.

Report Items With Negative Stock

If checked on then items with stock on hand less than zero are printed.

Calculate Rate Of Sale And Stock Cover

If checked on, the report shows the rate of sale and stock cover for each item. If checked off, the details are not printed and the report runs much faster.

Group By

Department, Supplier, Manufacturer or Brand.

oragball.gif (997 bytes) Paper Requirements

This report prints on A4 paper in Portrait mode.

oragball.gif (997 bytes) Sample Report

Figure: Example Stock Valuation Report

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)