Creating a Transaction Writer report

Select the folder where you want to store report information. Folders are defined on Folder (RW01.1). Folders store Transaction Writer reports and Report Writer reports. You can assign security to reports in a folder.

For more information, see the Report Writer User Guide.

Specify the number of spaces you want between columns. Column spacing is only applied to columns as they are added to a report.

Select Manual or Automatic to indicate if you want to manually define the two column heading lines at the top of the Layout tab or if the system automatically creates the column headings. The default setting is Automatic. Automatic headings use the column heading defined in Attribute (MX00.1) for the attribute selected in the column defaults.

Select if you want the output for the report to be a CSV (comma separated value) file. The default setting is No, which creates a 132-character wide report with up to two lines of detail for each transaction.

Select a search method to determine how the Transaction Writer searches for information about selected transactions.

• Accept the default, System Controlled, to let the program analyze the selected parameters and choose the most efficient search method.

• Select Activity to search for transactions by activity.

• Select User Attributes to search for transactions by user-defined transaction attributes. To use this method, secondary selects must exist and each Or group must contain at least one user-defined transaction attribute.

Select a report currency. Amounts not stored in that currency will be exchanged to the currency value.

Select the transaction attribute that you want to use for selecting data. There are Lawson-defined transaction attributes for all the fields in a transaction, in addition to user-defined transaction attributes you may have created. Select the specific attribute values in the Value Range field.

Select a specific range of attribute values in the report. Specify the beginning value in the first value range field and the ending value in the second value range field.

Select a value in the Or Group field to create conditional value statements. Use the Field and Or Group fields together to create conditional value statements.

This table shows the type of conditional statement created depending on the values in this field and the Item field.

Group Field Number Statement same same not valid

same different ..... either/or

different same both/and

different different either/or

Having a field and group number that are the same is not a valid combination. For example, a transaction cannot have a transaction amount of $5,000 and a transaction amount of $7,000.

This example shows how you can include a combination of conditions to select transactions dated June 15, 2000, or June 30, 2000, with a status of Posted (9).

Value Field Range Or Group

Tran Date 061500 - 061500 1

Trans Status 9 - 9 1

Tran Date 63000 - 063000 2

Trans Status 9 - 9 2

In this example, if you did not repeat the value range for the Tran Status after the Either/Or condition, then the system would select transactions dated June 15 with a posted status, and transactions dated June 30 with any status.

If you selected Manual column headings on the Basic tab, then specify the column headings in the first two lines on the Layout tab.

Select whether the columns you are maintaining are on line 1 or line 2. The default setting is Line 1.

Select the order that the field values print from left to right across the report by specifying the column number within the line number. The valid values are 1-50 for each line. For example, there can be a line 1, column 1 and a line 2, column 1.

Select the attributes to include on the report for each transaction. There are Lawson-defined attributes in the application for all of the fields on a transaction. You must create user-defined attributes for the originating system values that you have assigned to each source code.

Specify the column size. The first field is the overall size of the column. The default value is determined by the way the attribute is defined. If the column heading is wider than the data, then change the size to be larger than the default size to prevent truncated headings.

You can specify the number of decimal places used with amount or currency rate information. Decimal values are 0 though 6. The default value is determined by the way the attribute is defined.

Specify the number of blank spaces that precede the column. If you leave this field blank, then the column spacing selected on the Basic tab defaults.

Select Yes to have the system count the number of records (alpha and date fields) or total the values in the field (numeric and signed fields). The default setting is No.

Select Yes to print totals for this field. If you select Yes as the Total Break option, then you must include the field in the Sort tab. The default setting is No.

Select Yes to list each field on a separate page. If you select Yes as the Page Break option, then you must include the field in the Sort tab. The default setting is No.

Select Yes to print the description of the field instead of the code. For example, you can print Overhead instead of the account category 03700. The default setting is No.

Select Yes to suppress duplicate values on sequential lines of the report. The default setting is No.

Select Yes to suppress an entire line if it equals the previous transaction field values. The default setting is No.

Select Left, Right, Center, or None in the Align Head field to indicate how the heading aligns over the field values. The default setting is Left align for alpha and date fields, None for field descriptions, and Right align for other fields.