Home » Categories » Solutions by Business Process » Stock Control and Batch Tracking

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
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Base Date for Slow Moving Stock Report
Viewed 550 times since Fri, Jun 19, 2020
Choosing the Right Company - Stock Control
Viewed 1520 times since Mon, Jun 18, 2012
Save Demand and Sales Values for Previous Years
Viewed 1057 times since Fri, Jul 8, 2016
Recall Standard Text - Stock Control
Viewed 1187 times since Tue, Jun 19, 2012
Units of Issue, Pack Sizes and Price Per
Viewed 1509 times since Mon, Jun 18, 2012
Stock File FULL Screen Design (Premier) - Stock Control
Viewed 1659 times since Tue, Jun 19, 2012
Slow Moving Stock Report - Stock Control
Viewed 1664 times since Mon, Jun 18, 2012
Automatic Reports - Stock Control
Viewed 1537 times since Mon, Jun 18, 2012
Batch Tracking
Viewed 1383 times since Mon, Jun 18, 2012
Reports - Batch Tracking
Viewed 1374 times since Tue, Jun 19, 2012