Transaction Reports - Stock Control


Datafile Software

Transaction Reports - Stock Control

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.

Print Control

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.

Data Items

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.

Sub Total on Item

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.

Sorting Sequence

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

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.

All Transactions

This report lists all stock transactions in the order they were entered (subject to any sort settings).

Issues / Reservations

This report lists all sales issues (type 1) and reservations (type 6) transactions.

Purchases / Deliveries

This report lists all purchase orders (type 2); purchase deliveries (type 3) and goods received (type 4) transactions.

Adjustments

This report lists all stock adjustments (type 5) and stock take adjustments (type 8).

Transfers

This report lists all stock and warehouse transfer transactions (type 7)

Assemblies

This report lists all assembly build transactions (type 9)

Cost/Price Changes

This report lists all selling and cost price change transactions (type A)

Analysis Summary

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:

Analyse Which Data Item

This is the quantity item to use – typically this is quantity item.

At Which Value Data 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.


Custom Fields

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