Language:


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: