Home » Categories » Solutions by Business Process » Stock Control and Batch Tracking |
Transaction Reports - Stock Control |
Article Number: 508 | Rating: Unrated | Last Updated: Thu, Jun 22, 2023 at 10:54 PM
|
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 ControlUp 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 ItemsHere 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 ItemHere 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 SequenceReports 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 ButtonThe 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 TransactionsThis report lists all stock transactions in the order they were entered (subject to any sort settings). Issues / ReservationsThis report lists all sales issues (type 1) and reservations (type 6) transactions. Purchases / DeliveriesThis report lists all purchase orders (type 2); purchase deliveries (type 3) and goods received (type 4) transactions. AdjustmentsThis report lists all stock adjustments (type 5) and stock take adjustments (type 8). TransfersThis report lists all stock and warehouse transfer transactions (type 7) AssembliesThis report lists all assembly build transactions (type 9) Cost/Price ChangesThis report lists all selling and cost price change transactions (type A) Analysis SummaryThis 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 ItemThis is the quantity item to use – typically this is quantity item. At Which Value Data ItemThis 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. |
Attachments
![]() There are no attachments for this article.
|
Stock Optional 3 - Stock Control
Viewed 1781 times since Tue, Jun 19, 2012
Period End - Stock Control
Viewed 2091 times since Mon, Jun 18, 2012
Set Auto Expand Data Files - Batch Tracking
Viewed 1508 times since Tue, Jun 19, 2012
Batch Optional 2 - Batch Tracking
Viewed 1403 times since Wed, Jun 20, 2012
Set Application Code Formats - Stock Control
Viewed 1433 times since Mon, Jun 18, 2012
Batch / Call-Off - Stock Control
Viewed 1638 times since Tue, Jun 19, 2012
Potential Out of Stock Report - Stock Control
Viewed 2079 times since Mon, Jun 18, 2012
Automatic Stock Take – Zero Quantity Adjustments
Viewed 34 times since Wed, Oct 23, 2024
Batch Reports - Batch Tracking
Viewed 1625 times since Wed, Jun 20, 2012
Batch Enquiry - Batch Tracking
Viewed 1499 times since Wed, Jun 20, 2012
|