Creating an Example Tabular Section Report

Use the Director to create this example tabular section report, which is used to review outstanding purchase orders by business unit. A tabular section format was selected for this report for the automatic totaling and Row Description column features that are available in tabular sections. The V4311A - Purchase Order Detail Browse business view is attached to the tabular section, and these columns were selected for the section layout:

Description
Business Unit
Order Type
Amount Open

The report is organized by company and displays item descriptions. The data is filtered to include only purchase orders (as opposed to items that were ordered by other methods, such as purchase requisitions) for stocked parts. These parts carry a balance and are not yet closed

Access RDA.

From the File menu, select New.
On the Create New Report form, enter R554311 in the Report Name field.
Enter Outstanding Purchase Orders in the Description field.
Enter 55 in the Product Code field.
Select the No Update Report option and click OK.
On the Welcome to the Report Design Director form, select the Page Header and Tabular sections, and click Next.
On the Page Header Details form, click Next to accept the default.
On the Business View Selection Option form, select the option I'll find a business view myself, and then click Next.
On the Select Business View form, locate and select the V4311A - Purchase Order Detail Browse business view, and click Next.
On the Section Layout form, select these columns in the order listed and move them to Select Columns:
- Description
  The system has already added a Description column for you in Selected Columns. This is the Row Description column.
- Business Unit
- Order Type
- Amount - Open
When the selected columns are arranged as indicated, click Next.
On the Data Sequencing form, move the Order Company column (from table F4311) and the 2nd Item Number column to Selected Columns, and click Next.
Note: The data in this tabular section is sorted on business view columns that are not included in the section layout.
On the Define Sort Properties form, sort the data for both columns in ascending order.
Select the Level Break option for both fields, and click Next.
The Row Description column includes both of these columns, and the system calculates totals for open orders each time that the system displays a new record.

To filter data to include only open purchase orders of stock items that have an amount open, complete these criteria on the Data Selection form, and then click Next:

This filter statement meets the criteria that the open purchase orders include an open amount:

Column	Value
Operator	Where
Left Operand	Amount - Open (F4311) (AOPN) (BC)
Comparison	is greater than
Right Operand	<Zero> Do not enter a value of zero as a literal value.

Note: Each succeeding line of the filter is connected with an And operator. You must use And because every data item must meet all of the criteria to be included in the section.

This filter statement meets the criteria that the records are purchase orders:

Column	Value
Operator	And
Left Operand	Order Type (F4311) (DCTO) (BC)
Comparison	is equal to
Right Operand	OP

This filter statement meets the criteria that the purchase orders are still open, or not complete:

Column	Value
Operator	And
Left Operand	Status Code - Next (F4311) (NXTR) (BC)
Comparison	is not equal to
Right Operand	999 999 is a literal value for Complete.

This filter statement meets the criteria that the purchase orders include stock items only:

Column	Value
Operator	And
Left Operand	Line Type (F4311) (LNTY) (BC)
Comparison	is equal to
Right Operand	- S S is a literal value for Stock Item.

On the Finish form, select the No, I will create a version of this report later option, and click Finish.
On the JD Edwards Report Design Aid form, click Save to save the report.
Select the Preview tab to preview the report.
From the File menu, select Exit to quit RDA.