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:
- It is included in at least one Stocktaking record(s) for the specified date.
- 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.
- 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 Template | Prints (from Stocktaking record | |
| |
| Counted Sum | Sum 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 Total | Sum 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 Template | Prints (from Stocktaking row) | |
| |
| Description 1 | Description from the Item record |
| Difference | Counted - In Stock |
| In stock | Quantity of the Item in stock |
| Item Code | Item |
| Price | Weighted Average from the Item record |
| Quantity, summarised | Counted |
| Sum, Price | Value in stock based on the Counted quantity (i.e. Counted * Weighted Average from the Item record) |
| Sum Stocked | Value in stock based on the stock level (i.e. In Stock * Weighted Average from the Item record) |
| Transaction Date | Date from the specification window (if you specified one) or Trans. Date (otherwise) (dates will be printed in each row) |
| Unit | Unit from the Item record |
| Unit Price | Base 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:
Introduction to Forms in the Stock Module
