Product Stocktake Variance Report

This report will list the average differences of product prices & quantities between the last n number of stocktakes where n is the threshold.

Click Reports on the Main Menu, followed by Product Reports then Product Stocktake Variance Report option. Alternatively, click Products on the Toolbar followed by Reports, Product Reports then Product Stocktake Variance Report option.

Figure : Product Stocktake Variance Report options

Options

Select the Department, Sub-Department, Supplier, Manufacturer, Storage Location, Product Group, Stocktake and the Threshold or number of stocktakes to compare.

Figure : Product Stocktake Variance sample report

Filters

The report will list the filters used including; Site, Department, Sub-Department, Supplier, Manufacturer, Storage Location, Product Group, Stocktake, Date and Time and Threshold.

Details

The product details listed for the stocktake include; Product, Barcode, Description, Expected Average price and Actual Average prices of an individual product,

Cost is the price of the item when recieved from the supplier and input a stock receipt in to amicus.

i.e. you recieve x items for $3 and input a stock reciept for that amount. The cost at sale is $3 per item.

',event)">Last Cost, Expected Count in the stocktake,

The worth is the number of the items in stock by the most recently recieved $$cost$$.

i.e. you receive 4 items at a cost of $2 and put in a stock receipt for that cost, then recieve 2 items at a cost of $5 and put in a stock receipt at theat cost.

Using $$FiFo$$,

The total cost is $8 (4x$2) (for the first 4 items)  plus $10 (2x$5) (for the second 2 items) = $18,

The total worth is $20 (4x$5) (for the first 4) plus $10 (2x$5)  (for the second 2 items) = $30,

Using $$LiFo$$,

The total cost is $8 (4x$2) (for the first 4 items)  plus $10 (2x$5) (for the second 2 items) = $18,

The total worth is $8 (4x$2) (for the first 4) plus $4 (2x$2)  (for the second 2 items) = $12,

',event)">Worth, actual Count after the stocktake, Variance between counts and the Change In Value.