Stock Take Variance

Report Options

Field

Description

Report sequence

Stock code

Select this to print the report in stock code sequence.

Bin location

Select this to print the report in bin location sequence.

If Multiple Bins is not enabled (Inventory Setup) then the report is generated in default bin sequence. This is the bin location defined against the stock code's warehouse (Inventory Warehouse Maintenance for Stock Code) or the warehouse code itself if the bin is not defined.

Warehouse

Indicate the warehouse for which you want to print the report.

The warehouse must have a stock take in progress (Stock Take Selection).

Value stock at

Cost on warehouse file

Select this to value stock at the unit cost currently held against the warehouse.

If your Costing method is set to FIFO or LIFO (Inventory Setup or Warehouses) then the last cost is used regardless of the cost against the warehouse file.

For all other costing methods against warehouses, the unit Cost is used (Inventory Warehouse Maintenance for Stock Code).

Cost on stock take file

Select this to value stock in the stock take file at the unit cost prevailing at the time the stock take selection was run, regardless of any cost changes that may have occurred since the stock take was selected.

If your costing method is set to FIFO or LIFO (Inventory Setup or Warehouses) then the last cost will have been used when the Stock Take Selection program was run. For all other costing methods, the unit cost will have been used.

Options

Only print exception lines

Select this to print stock codes only where the captured quantity differs from the original quantity on hand by a specific variance as configured within the Inventory Setup program.

Print lots

Select this if you want to print lot numbers on the report as well as revision and release information for ECC-controlled items

Exclude zero lots

Select this to exclude the following from the report:

lots that had a zero balance when you ran the Stock Take Selection program and currently have a zero balance (i.e. a zero quantity was captured against those lots)
revisions/releases that had a zero balance when you ran the Stock Take Selection program and currently have a zero balance (i.e. a zero quantity was captured against those revisions/releases)

Include if saved quantity is zero

Select this to include stock codes with an on hand quantity of zero at the time of running the stock take selection.

Include if quantity not captured

Select this to include stock codes for which a quantity has not been captured.

Print batch serial numbers

Select this to print the batch serial number on the report for each batch serialized item printed.

Print manual serial numbers

Select this to print the serial numbers on the report for each manual serialized item printed.

Exclude zero serial numbers

Select this to exclude serials that had a zero balance when you ran the Stock Take Selection program and currently have a zero balance (i.e. a zero quantity was captured against those serials)

Print FIFO total value

Select this to project the variance value in terms of FIFO valuation.

This option is only available if you selected the setup option: FIFO valuation (Inventory Setup).

Selection criteria

Field	Description
Stock code selection	Indicate the stock codes that must be included in the report.
Product class selection	Indicate the product class(es) for which stock codes must be included in the report.
Unit of measure selection	Indicate the unit(s) of measure for which stock codes must be included in the report.
Bin location selection	Indicate whether the bin location(s) for which stock codes must be included in the report.

Output Options

These options enable you to apply a theme to the report and to define multiple output destinations for the report once it has been compiled (SRS Output Options).

Report Details

The variance value printed at the end of the report represents the difference between the inventory value for the selected stock items at the time the Stock Take Selection program was run and the value of these stock items at the current time.

If you run the Stock Take Confirmation program immediately after running the Stock Take Variance report, then this variance is the amount posted to the General Ledger code defined against the Adjustment field of the Inventory Ledger Interface program. If the variance value is negative, then this represents a stock loss. Similarly if the value is positive, it represents a stock gain.

Nothing is printed on the report if you select to Only print exception lines and the Maximum permitted for stock take variance is set to zero (Inventory Setup).

Costs are not printed on the report if you are denied access to the field INV Show costs in inventory/WIP queries (Security Fields).

Notes and warnings

Prerequisites

Before using this program you use the Stock Take Capture program to capture the counted quantities.

Error messages

Failed to retrieve data from the database

This message is displayed when you try to run this report with Client-side reporting using XML as your reporting configuration (System Setup).

This is due to the size of the report.

Change your reporting configuration to Client-side reporting using SQL to print large reports.

Identifying variances

You need to print the Stock Take Variance report immediately before using the Stock Take Confirmation program to be able to identify the stock items responsible for the variance value which is ultimately posted to the General Ledger.

If you did not do this, then you can use the Inventory Movement report and select to print only the Adjustment transactions types for the date on which the stock take was confirmed. However, the Inventory Movement report will also include any other adjustments which may have been processed on that date.