Here you define how the transaction reports, based on the transaction records file, are to print.For each report the parameters you must give include the print style (type of printing), the data items to print, and any sorting sequence for the final report.
The setup for each report follows a standard pattern, as illustrated by the All Transactions report.
Up to eight report styles can be defined on your system through the CONFIG user (see the Configuration Guide). These control the length/width of page to print. The styles available are listed at the bottom right of the screen.
Here you can select up to ten items to print across the page for each report. The data items available for selection are listed to the right of the screen – you can also, however, use the F4-Select key to select items for the report.
Here you can select a data item to break the report and provide totals for, for example you could select to provide totals per analysis code. The item set here must also be set as the first sort item below.
Reports are normally printed in transaction entry order. You may specify a different sorting sequence for a report here by giving the item numbers in the file of the data item on which you wish to sort.The first item chosen is the senior sort item, with each subsequent one being junior.
You have the option to choose an ascending sort sequence (normal choice) or descending value. You might use descending value if sorting on a numeric value.
Multi Location Stock
If using multi-location stock then reports are printed location by location. Any sorting sequence defined here occurs within the location.
The OPTIONS button allows you to configure the page size, font and margins of the printed report and operates as discussed in Stock Reports above.
This report lists all stock transactions in the order they were entered (subject to any sort settings).
This report lists all sales issues (type 1) and reservations (type 6) transactions.
This report lists all purchase orders (type 2); purchase deliveries (type 3) and goods received (type 4) transactions.
This report lists all stock adjustments (type 5) and stock take adjustments (type 8).
This report lists all stock and warehouse transfer transactions (type 7)
This report lists all assembly build transactions (type 9)
This report lists all selling and cost price change transactions (type A)
This report analyses the stock transactions – either the sales transactions, purchases or adjustments analysis code recorded on the transaction showing the value of stock for each analysis code. For this report the only configuration options are the print style and the following:
This is the quantity item to use – typically this is quantity item.
This is the value item to use – typically this is the cost price as it is recorded for all transactions but you may want to use the selling price instead if only running the analysis report on sales transactions.
Article ID: 508
Created On: Tue, Jun 19, 2012 at 11:19 AM
Last Updated On: Thu, Jun 22, 2023 at 10:54 PM
Online URL: https://kb.datafile.co.uk/article/transaction-reports-stock-control-508.html