O/E Transaction List Report Screen

To open this screen

Open Order Entry > O/E Reports > Transaction List.

Fields and controls

Buttons

Print

Click Print to print the report.

Currency (From / To)

If you have a multicurrency system, specify a range of currencies to include in the report.

Customer Number / Order Number (From / To)

Specify a range of order numbers or customer numbers to include in the report.

(You use the From and To fields associated with the Sort By or the Then By fields, depending on whether you are specifying the customer number or order number as the primary or secondary sort order.)

Date (From / To)

Specify a range of dates to include in the report.

Include options

Select optional information you want to include in the report (Document Information / Details, Addresses, Tax Reporting Information, Salespersons, prepayments, and Optional Fields).

Note: The options are available only for detail reports, and they vary according to the type of transaction you select in the Print field.

Order Type options

Specify order types to include in the report (Active, Standing, Future, or Quote).

Note: These options are available only if you select Order in the Print field.

Print

Specify the type of transaction you want the report to list (Orders, Shipments, Invoices, or Credit/Debit notes).

Source options

Specify the sources of orders to include in the report. You can include orders entered directly in Order Entry or over the Internet.

Note: These options are available only if you select Order in the Print field.

Report Type

Specify whether to print a detail or summary report.

Sort By / Then By

Specify the primary sort order for the report in the Sort By field, and then, depending on your selection, specify the range of transaction numbers or customer numbers to include on the report.

When you select a primary sort order, Order Entry supplies the secondary sort order in the Then By field. Specify a range of transaction numbers or customer numbers for the secondary range.

Status options

Select order statuses to include in the report.

Note: These options are available only if you select Order in the Print field.

Related tasks

• Printing Order Entry Reports

Overview

Print the O/E Transaction List report when you need a list of orders, shipments, invoices, or credit/debit notes. You print a separate report for each type of transaction, and you can print a detail or summary version of the report.

The report includes current transactions and, if you keep transaction history, past transactions.

When printing this report for orders, you can specify which orders to include in the report by selecting the order type, status, and source.

You can sort the report by transaction number or customer number, and you can specify ranges of transaction numbers, customer numbers, and currency codes (if you have a multicurrency system) to include in the report.

Information Printed on This Report

Depending on the printing options you select, the O/E Transaction List report can include:

• The information entered on the main screen of the O/E Order Entry screen or the O/E Credit/Debit Note Entry screen, and the total amount. In multicurrency ledgers, the total amount is displayed in both source currency and functional currency.
• The address, phone number, and fax number for billing and shipping.
• Details for each item on the order, invoice, shipment, or credit/debit note, including quantities ordered and shipped or returned, unit prices, and total amounts outstanding.
• The salesperson commission split for the order.
• Any prepayments that were posted to an order or invoice.
• The contract, project, and category to which the items or charges were allocated.
• Grand totals for orders, shipments, invoices, or credit/debit notes.
• Summary totals for each source currency (for the multicurrency version of the report).

Last published: 4/8/2016