Language:


Stocktaking Comparison

This form allows you to print a hard copy of any record entered in the Stocktaking register.

If you specify a Stocktaking No. in the 'Specify Stocktaking Comparison' window (illustrated below), the contents of that Stocktaking record will be printed, and anything else that you enter in the specification window will be ignored.

Otherwise, an Item will be included in the document if it meets the criteria that you enter in the specification window and that satisfies any of the following requirements:

  1. It is included in at least one Stocktaking record(s) for the specified date.

  2. It is included in a Stocktaking record that is later than the specified date. If you do not specify a date, this means any Stocktaking record.

  3. It is not included in any Stocktaking records for the specified date or later, but it is recorded in your database as being in stock on the specified date.

Item
Paste Special    Item register
Range Reporting    Alpha
Enter an Item Number (or range of numbers) if you need specific Item(s) to be included in the document. Use a colon (:) to separate the first and last numbers in the range.

Only Stocked Items in the range will be included in the document (not Plain, Service or Structured Items). An Item will not be included if its stock level and Counted quantity are both zero.

Location
Paste Special    Locations setting, Stock module
To produce a report for one stock Location, specify that Location here. The document will be compiled from Stocktaking records with this Location specified in the header, and from Stocktaking rows in which this Location has been specified.

Group
Paste Special    Item Group register, Sales Ledger
Range Reporting    Alpha
Enter an Item Group Code if you need the document to cover the Stocked Items that belong to a particular Item Group. You can also enter a range of Item Groups, but as the field will only accept five characters you may need to enter an alphabetical range (e.g. "A:M").

Date
Paste Special    Choose date
Specify the date for which the Stocktaking comparison is to be carried out.

If an Item is included in a Stocktaking record for the specified date, the document will compare its stock level on that date with the Counted quantity in that Stocktaking record and will display any discrepancies between those figures.

If an Item is not included in a Stocktaking record for the specified date, but it is included in a later one, its Counted quantity will be taken from that later record.

If you do not specify a date here, an Item's Counted quantity will be taken from the earliest Stocktaking record in which it has been included.

Use the Function options below to determine how an Item that is in stock but that has not been included in any Stocktaking record will be included in the document.

Stocktaking No.
If you need to print a particular Stocktaking record, enter its No. here. If you do so, every other field and option in that you may specify in the window will be ignored.

Function
Select one of these options to specify how an Item that is in stock but that has not been included in any Stocktaking record will be included in the document.
Standard
If you choose this option, the Item will be included in the document with a blank Counted quantity. this option assumes that the reason you didn't enter the Item in a Stocktaking record was because you counted no units during the stocktake.

If Item not on last Stocktaking assume 0 in Stock
If you choose this option, the In Stock and Counted quantities for the Item will both be said to be zero, so the Item will not be in the document.

Skip Item if Item not on last Stocktaking
This is similar to the second option described above.
You can use the fields listed below when you design the Form Template to be used by the Stocktaking Comparison form.

Header Fields (these print once per document)
Field in Form TemplatePrints (from Stocktaking record
Counted SumSum of the values in the "Sum, Price" row field (i.e. total value in stock based on the Counted quantities)
Counted Total Sum of the values in the "Quantity, summarised" row field (i.e. total Counted quantity)
Difference TotalSum of (Difference * Price) from each row (i.e. total value of the difference between Counted quantities and stock levels)
In stock Total Sum of the values in the "In stock" row field (i.e. total quantity in stock)
Total FIFO Sum of the values in the "Sum Stocked" row field (i.e. total value in stock based on stock levels)
Row Fields (these print once per row, so remember to specify a Line Height and to set the Format to "Matrix")
Field in Form TemplatePrints (from Stocktaking row)
Description 1Description from the Item record
DifferenceCounted - In Stock
In stock Quantity of the Item in stock
Item CodeItem
PriceWeighted Average from the Item record
Quantity, summarisedCounted
Sum, PriceValue in stock based on the Counted quantity (i.e. Counted * Weighted Average from the Item record)
Sum StockedValue in stock based on the stock level (i.e. In Stock * Weighted Average from the Item record)
Transaction DateDate from the specification window (if you specified one) or Trans. Date (otherwise) (dates will be printed in each row)
UnitUnit from the Item record
Unit PriceBase Price

Please refer here for details of the standard fields that you can also include in the Form Template.

---

Forms in the Stock module:

Go back to: