Transaction Reports
The Not Yet Printed and Fast Report options show the standard output window, where the destination of the report can be selected, and if the Currency Module has been purchased, which combination of values to print.
The Outstanding Orders and Variance Report have special selection windows, which are explained below.
The other Transaction Reports all display similar selection windows.
The Current Batch, Current Period, All Transactions and Wide Report all display the following options, these affect how the report is printed and what is printed on the report :-
Full Details Expands the basic report so that Serial Numbers, Sub Analysis, Batch Reference and Cost Codes are displayed (if relevant) for each Movement.
Full Descriptions Expands the report by adding an extra line for each Movement to display the full Stock Name. If Full Details is also selected, then if Project & Cost Codes are printed, the Project Record full Names will also be printed.
Notes Expands the report to include any entries made in the text field on the Detail window.
Show Sales value (Out only) available if Sales is selected.
The All Movements menu enables individual Movement types to be de-selected so that for example Opening Balances do not appear on the report, .
If using Currency, a selection is also available for which values are to be printed on the report.
Current Batch report - the Sort & Subtotal on Account is not relevant to the Current Batch report. This is because this report only looks at batched stock movements raised in the stock module not at ones generated by batched Sales and Purchase orders. Using the Sort & Subtotal on Account on the report produces a report total for Unanalysed.
For other Stock Transaction reports this Sort & Subtotal on Account does sort by Customer and Supplier account.
Show Subtotals Only will be available if a Subtotal option is selected on the Sort Order/Subtotal window.
Show Additional Details is an extra option available for the Wide Report, to add further details to the report.
The Outstanding Orders report has the following options available :-
This pull down menu allows the selection of whether to print Sales or Purchase Orders.
Full Descriptions Expands the report by adding extra lines for the full Stock and Customer/Supplier Account Name.
New Page for each Record This option will start printing a new page for every Record printed on the report.
For more information on reports, please refer to the Help topic: Introduction to Reports.
Outstanding Orders report
This report lists outstanding Sales and Purchase Orders for Stock items.
Optional data may be added to the report, and the normal Searching, Sorting and Sub-totalling options are available.
This pull down menu allows the selection of whether to print Sales or Purchase Orders.
Full Descriptions Expands the report by adding extra lines for the full Stock and Customer/Supplier Account Name.
New Page for each Record This option will start printing a new page for every Record printed on the report.
Variance Report
The Variance report shows the difference between the Delivered value and the Invoiced value on Purchase Orders.
This report is only available if the System option Update Stock to Nominal has been selected. The report will enable you to reconcile Stock valuations to Balance Sheet Accounts.
The report shows the price adjustments posted as Stock movements, these are sorted and subtotalled.
Based On Stock This menu enables you to select to prepare the report based on Stock or on Sub Analysis.
If Sub Analysis is chosen the report will show the concatenation of Stock code and Sub Analysis code.
The report is prepared for a selected Period Range.
The transactions will be Sorted and Subtotalled by:
the Stock Code (or Sub Analysis code),
then by the default POP Analysis code,
then by the Nominal code set as the Debit account on the default analysis.
The movements are shown as positive for increases in price and negative for decreases in price. The total net is shown as a positive if price has increased more then it has decreased.
Against the sub total for the Stock (or Sub Analysis), further information is displayed about the quantity of physical Stock moved out compared to the physical Stock moved in for the period defined on the search window.
At the Nominal code level the report also displays the Balance Sheet value as at the end of the period range selected.
