Quantum VS Help: File Maintenance

Previous  Next  

Running The Stock Variance Report

The final stage of the 'stock take' procedure - after you have entered Stock Count figures - is to run the Stock Variance Report, in which various options are available.

 

The main option is to run this report with one of the 'Complete Stock Take Cycle' options selected in the Print Option field, which will formally end the Stock Count for the given Stock Count Reference. This turns off the 'Stock Count Active' flag on any products included in the count, updating their stock figures on the system and making them available to sales documents again.

 

An alternative is to run this report with the 'Cancel The Stock Take' option selected in the Print Option field, which cancels the Stock Count for the given Stock Count Reference. This makes the included products available to sales documents again but without updating their stock figures on the system.

 

Running this report with one of the 'Variant Report' options selected in the Print Option field will generate/print a list of products where the actual counted stock figures differed from the stock figures on the system. A common scenario is as follows:

 

A further option is to run this report with the 'Products Not Counted Report Only' option selected in the Print Option field to generate/print a 'products not counted' report (without completing the Stock Count). This is commonly used when you wish to count certain products now and some later.

 

Note: The full stock take procedure is explained in Overview Of The Stock Take Procedure.

 

To run the Stock Variance Report:

 

1.      Open the Stock Control tab. See Opening The Stock Control Tab.

 

2.      Click Stock Variance Report on the left-hand menu:

 

FileM_StockVarianceReport.gif

 

3.      Enter your criteria by completing the fields as necessary, using the following as a guide:

 

Note: You may use your [Tab] key to move from one field to the next.

Field

Definition  (* = mandatory field)

 

Stock Count Reference *

 

Enter a reference for the Stock Count. This must consist of four alphanumeric characters (e.g. MMM6).

 

Print Option *

 

Select one of the following options depending on the action you wish to take:

 

  • Variant Report Only - to print a variance report without completing the stock take cycle.

  • Variant Report & Complete Stock Take Cycle - to print a variance report and also complete the stock take cycle.

  • Complete Stock Take Cycle Only - to complete the stock take cycle without printing a variance report.

  • Cancel The Stock Take - to cancel the stock take cycle.

  • Products Not Counted Report Only - to print a 'products not counted' report only.

 

Full Description

 

Check this field to print a full description in the report.

 

This not required if you have selected either of the following Print Options:

 

  • Complete Stock Take Cycle Only; or:

  • Cancel The Stock Take.

 

Zero Variance Levels

 

Check this field to include Zero Variance Lines in the report.

 

This not required if you have selected either of the following Print Options:

 

  • Complete Stock Take Cycle Only; or:

  • Cancel The Stock Take.

 

Nominal Code Totals

 

Check this field to include Totals By Nominal Code in the report.

 

This not required if you have selected either of the following Print Options:

 

  • Complete Stock Take Cycle Only; or:

  • Cancel The Stock Take.

 

Cost Type *

 

Use the drop-down menu to select the cost type to use in the report, from the following options:

 

  • Average

  • Buying

  • Branch Average

  • Standard Cost

  • FIFO Cost

 

This not required if you have selected either of the following Print Options:

 

  • Complete Stock Take Cycle Only; or:

  • Cancel The Stock Take.

 

Reset All Areas

 

Check this field to reset the Count Flag for all areas (i.e. turn off the 'Stock Count Active' flag on any products included in the Stock Take).

 

This not required if you have selected either of the following Print Options:

 

  • Variant Report Only; or:

  • Products Not Counted Report Only.

 

Receipt Cost

 

If enabled, variances for products which are 'Batch Traceable' are costed using the GRN Receipt Cost, whereas variances for non-'Batch Traceable' products are based on the Cost Type selected (see above).

 

 

4.      Click Start on the Toolbar - Sub Menu to run the report.

 

When the process has completed, the Information field will read 'Process Complete'. A URL will be shown, at which a report can be viewed and printed if necessary. The Started field lists the date and time on which the process was run.

 

Your next step depends on the Print Option chosen in the Stock Variance Report. Either:

 

NEXT: Running The Import Scanned Stock Count Data Process