Weighted Average
This page describes the Weighted Average report in the Stock module.
---
The Weighted Average report is a simple list of records in the Weighted Average setting.
- Item No
- Paste Special
Item register
- Range Reporting Alpha
- If you need a particular Item to be listed in the report, enter its Item Number here. You can also enter a range of Item Numbers, separated by a colon (:). If you leave the field blank, every Item with at least one connected record in the Weighted Average setting will be included in the report.
- Item Group
- Paste Special
Item Group register, Sales Ledger
- If you need the report to list the Items that belong to a particular Item Group, enter that Item Group here.
- Item Classification
- Paste Special
Item Classifications setting, Sales Ledger
- If you need the report to list the Items that have a particular Item Classification, enter that Classification here. If you enter a number of Classifications separated by commas, the report will only include Items featuring all the Classifications that you have listed. If you enter a number of Classifications separated by plus signs (+), all Items featuring at least one of the Classifications listed will be included in the report. If you enter a Classification preceded by an exclamation mark (!), the report will include Items featuring any Classification except the one listed.
- For example:
- 1,2
- Includes Items with Classifications 1 and 2 (including Items with Classifications 1, 2 and 3).
- 1+2
- Includes Items with Classifications 1 or 2.
- !2
- Includes all Items except those with Classification 2.
- 1,!2
- Includes Items with Classification 1 but excludes those with Classification 2 (i.e. Items with Classifications 1 and 2 will not be included). Note the comma before the exclamation mark in this example.
- !1,!2
- Includes all Items except those with Classification 1 or 2 or both. Again, note the comma.
- !(1,2)
- Includes all Items except those with Classifications 1 and 2 (Items with Classifications 1, 2 and 3 will not be included).
- !1+2
- Includes Items without Classification 1 and those with Classification 2 (Items with Classifications 1 and 2 will be included).
- (1,2)+(3,4)
- Includes Items with Classifications 1 and 2, and those with Classifications 3 and 4.
- 1*
- Includes Items with Classifications beginning with 1 (e.g. 1, 10, 100).
- 1*,!1
- Includes Items with Classifications beginning with 1 but not 1 itself.
- *1
- Includes Items with Classifications ending with 1 (e.g. 1, 01, 001).
- 1*,*1
- Includes Items with Classifications beginning and ending with 1.
---
Go back to:
Introduction to Reports in the Stock Module
