Stock Revaluation Journal
This page describes the Stock Revaluation Journal report in the Stock module.
---
The Stock Revaluation Journal report lists selected records from the Stock Revaluation register.
When printed to screen, the Stock Revaluation Journal has the Standard ERP Drill-down feature. Click (Windows/macOS) or tap (iOS/Android) on any Stock Revaluation Number in the report to open an individual Stock Revaluation record.
- Serial No.
- Range Reporting
Numeric
Enter a Stock Revaluation Number or a range of Numbers separated by a colon (:) here if you would like specific Stock Revaluations to be shown in the report.
- Period
- Paste Special
Reporting Periods setting, System module
- Enter the start and end dates of the period to be covered by the report. A Stock Revaluation record will be included in the report if its Transaction Date falls in the period specified here.
- Location
- Paste Special
Locations setting, Stock module
- Range Reporting Alpha
- Entering a Location in the field will restrict the report to Stock Revaluation records with that Location specified in the header. You can also enter a range of Locations separated by a colon (:).
- Variance Account
- Paste Special
Account register, Nominal Ledger/System module
- Range Reporting Alpha
- To report on Stock Revaluations with a particular Variance Account, enter the Account Number here. This refers to the Variance Accounts entered in the headers of the Stock Revaluation records, not to those that might have been entered in the rows.
- Tag/Object
- Paste Special
Tag/Object register, Nominal Ledger/System module
- To report on Stock Revaluations that use a particular Tag/Object, specify that Tag/Object here. If you enter a number of Tags/Objects separated by commas, the report will only include Stock Revaluations featuring all the Tags/Objects that you have listed. If you enter a number of Tags/Objects separated by plus signs (+), Stock Revaluations featuring at least one of the Tags/Objects listed will be shown in the report. If you enter a Tag/Object preceded by an exclamation mark (!), Stock Revaluations featuring any Tag/Object except the one listed will be included in the report.
- For example:
- 1,2
- Includes Stock Revaluations with Tags/Objects 1 and 2 (including those with Tags/Objects 1, 2 and 3).
- 1+2
- Includes Stock Revaluations with Tags/Objects 1 or 2.
- !2
- Includes all Stock Revaluations except those with Tag/Object 2.
- 1,!2
- Includes Stock Revaluations with Tag/Object 1 but excludes those with Tag/Object 2 (i.e. Stock Revaluations with Tags/Objects 1 and 2 will not be included). Note the comma before the exclamation mark in this example.
- !1,!2
- Includes all Stock Revaluations except those with Tag/Object 1 or 2 or both. Again, note the comma.
- !(1,2)
- Includes all Stock Revaluations except those with Tag/Object 1 and 2 (Stock Revaluations with Tags/Objects 1, 2 and 3 will not be included).
- !1+2
- Includes Stock Revaluations without Tag/Object 1 and those with Tag/Object 2 (Stock Revaluations with Tags/Objects 1 and 2 will be included).
- (1,2)+(3,4)
- Includes Stock Revaluations with Tags/Objects 1 and 2, and those with Tags/Objects 3 and 4.
- 1*
- Includes Stock Revaluations with Tags/Objects beginning with 1 (e.g. 1, 10, 100).
- 1*,!1
- Includes Stock Revaluations with Tags/Objects beginning with 1 but not 1 itself.
- *1
- Includes Stock Revaluations with Tags/Objects ending with 1 (e.g. 1, 01, 001).
- 1*,*1
- Includes Stock Revaluations with Tags/Objects beginning and ending with 1.
- This refers to the Tags/Objects entered in the headers of the Stock Revaluation records, not to those that might have been entered in the rows.
- Function
- Select one of these options to specify the level of detail that you need to be shown in the report.
- Overview
- This choice produces a report with one row per Stock Revaluation record, showing Serial Number and Date, Location, Variance Account, Objects and Comment. The Location, Variance Account and Objects will be taken from the header of each record.
- Detailed
- As well as the information shown in the Overview, this report lists each Item in each Stock Revaluation record, showing the Item Number, Serial Number and Name, Variance Account, Objects, Quantity, Old and New Total Values and the Difference. You can use this report as an archive file instead of printing a copy of each Stock Revaluation record.
- Status
- Specify here whether Stock Revaluations that have been marked as OK, Stock Revaluations that have not been marked as OK or both are to be included in the report.
- Show Quantity 2
- If you select this option, an extra column will be added to the Detailed version of the report, displaying stock quantities using a second unit of measurement. Quantity 2 figures will only be shown for Items that have a Unit 2 and a Unit Coefficient specified on their 'Stock' cards. Please refer to the description of the Unit 2 and a Unit Coefficient fields here for more details.
---
Go back to:
|
Introduction to Reports in the Stock Module
