Order and Booking

Report Options

Field

Description

Report type

Booked

Select this to print a list of orders that have been booked (captured) in a particular period.

A single line summary of the total order value of each order is printed. Cancelled orders are included. Supply chain transfers are excluded.

You typically select this option together with a specific date range. For example you could run the report for yesterday's date, to view all orders captured the previous day.

Back Order

Select this to print details of orders having an outstanding back order amount at the time of invoicing (i.e. orders that have been only partially filled.

A single line summary of the total order value for each order is printed, as well as details for each order line.

Order

Select this to print details of outstanding sales orders held on file according to the selection criteria specified.

When you select this option, you can additionally indicate the order status for which you want to generate the report. You could therefore, include all orders, or only orders for a specific status.

Report sequence

Order

Select this to print the report in order number sequence.

Customer, Order

Select this to print the report in order number within customer sequence.

Customer, Purchase order

Select this to print the report in purchase order number within customer sequence.

SCTs

This option applies to supply chain transfers and does not apply to a Booked report type. SCTs are excluded when running a Booked report.

Option	Description
Include	Select this to include supply chain transfer orders in the report.
Exclude	Select this to exclude supply chain transfer orders in the report.
Only	Select this to print the report only for supply chain transfer orders.

Price options

The available Order status options depend on your selection at the Report type field.

List only price override

Select this to list only orders where prices were manually overridden.

You will be unable to access the Order status field if you select this option.

Order status

Indicate the status code(s) according to which orders must be included for printing.

The Order status options available depend on your selection at the Report type field.

See also Sales Order Status Codes.

A-All

Select this to include all orders.

F-Forward

Select this to include orders that were entered as forward orders using the Sales Order Entry program

S-Suspense

Select this to include orders in suspense. These are orders that failed credit checking during processing within the Sales Order Entry program, or that have manually been put on hold.

1-Booked

Select this to include booked orders (orders in status 1).

2-Backorder

Select this to include orders in a status of 2 or 3.

4-Warehouse

Select this to include orders in a status of 4.

\-Cancelled

Select this to include orders in a status of * or \.

8-Released

Select this to include orders in a status of 8.

9-Completed

Select this to include orders in a status of 9.

Date selection required

Select this to be able to select orders according to a range of dates.

You specify the dates you require using the Date type and Date selection fields.

Include non-stocked lines

Select this to include non-stocked order lines.

If you do not select this option, then only the stocked lines of an order are selected and only the value of these lines is indicated on the report.

Print comments attached to order/invoice

Select this to include comments attached to the entire order or invoice in the report.

You cannot select this option if you selected the Booked option at the Report type field.


	The comments printed on the report are the comments entered using the Comment function when Adding lines to a sales order. They are not the comments entered using the Order Comments function on the End Order screen (Sales Order Entry).

Print comments attached to order/invoice lines

Select this to include comments attached to order lines or to invoice lines in the report.

You cannot select this option if you selected the Booked option at the Report type field.

Print freight and miscellaneous lines

Select this to print the freight and miscellaneous charge lines attached to orders in the report.

Exclude lines with negative back order quantity

Select this to exclude orders with a negative back order quantity.

This option is available only if you selected to print a Back Order Report type.

Include completed orders

Select this to include completed orders when printing booking and order type reports.

This option is not available if you selected to print a Back Order Report type.

This option is automatically selected when you select to print completed orders at the Order status field.

Date type

You can only access this option if you selected the Date selection required option and you selected Order at the Report type field.

Option

Description

Order entry date

Select this to select sales orders based on the date they were processed in the Sales Order Entry program.

You can include orders for a range of order entry dates. You indicate this range in the Date selection fields.

Ship date

Select this to include sales orders based on the ship date specified in the Sales Order Entry program.

You can include orders for a range of order ship dates. You indicate this range in the Date selection fields.


	If you select this option, then non-merchandise lines (e.g. freight and miscellaneous lines) are not printed on the report for Scheduled Orders. The reason is that for Scheduled Orders, the merchandise lines are included in the report based on the ship date, but non-merchandise lines do not have a ship date and are therefore excluded.

Status date

Select this to include sales orders based on the date an invoice was last produced for the order.

You indicate this range in the Date selection fields.

Selection criteria

Field	Description
Date selection	Indicate the date(s) for which to include orders in the report. This date refers to either the order entry, ship or invoice date depending on whether you selected to include orders based on Order entry, Ship date or Status date at the Date type field. You can only access the Date selection field if you selected the Date selection required option and you selected the Order option at the Report type field.
Order selection	Indicate the range of orders you want to include in the report.
Warehouse selection	Indicate the warehouse(s) for which orders must be included in the report.

Field

Description

Date selection

Indicate the date(s) for which to include orders in the report.

This date refers to either the order entry, ship or invoice date depending on whether you selected to include orders based on Order entry, Ship date or Status date at the Date type field.

You can only access the Date selection field if you selected the Date selection required option and you selected the Order option at the Report type field.

Order selection

Indicate the range of orders you want to include in the report.

Warehouse selection

Indicate the warehouse(s) for which orders must be included in the report.

Other Options

The options on this tab page enable you to indicate additional criteria for including orders in the report.

Selection criteria

Field	Description
Customer selection	Indicate the customer(s) for whom to include orders in the report.
Branch selection	Indicate the Accounts Receivable branches for which to include orders in the report.
Salesperson selection	Indicate the salesperson(s) for which to include orders in the report.
Source warehouse selection	Indicate the source warehouse(s) for which to include orders in the report. This applies to Supply Chain Transfers.
Product class selection	This enables you to include orders for a selection of products classes in the report. The product class is defined against the stock item using the Stock Codes program. If a specific product class is entered, then only orders for stock items belonging to that product class are included in the report. This selection is not available for a report type of Booked.
Stock code selection	Indicate the stock code(s) for which to include orders in the report.
Order type selection	Indicate the order type(s) for which to include orders in the report. This option is only relevant if you indicated that the order type is required (Sales Orders Setup). This selection is not available for a report type of Booked. Order types are maintained using the Order Types program.
Target warehouse selection	Indicate the target warehouse(s) for which to include orders in the report. This applies to Supply Chain Transfers.

Currency Options

The options on this tab page enable you to indicate the currency in which you want to print order values on the report.

This only applies when the Foreign currency sales required option is enabled (Accounts Receivable Setup).

Field

Description

Show values in

Option	Description
Local currency	Select this to print foreign amounts in the local currency equivalent.
Foreign currency	Select this to print foreign amounts in the original currency.

Currency selection

Indicate the currency(ies) for which to include the selected sales orders in the report.

Select All to print the value of sales orders regardless of the currency in which they were posted.

Alternatively, select Single to only print the value of sales orders posted in a specific currency.

Output Options

These options enable you to apply a theme to the report and to define multiple output destinations for the report once it has been compiled (SRS Output Options).

Report Details

Values are printed exclusive of tax if the setup option: Reduce S/O value by tax amount when tax is inclusive and the tax code used on the sales order was inclusive

This report is based on the order quantities, the ship quantities and the backorder quantities. However, if you are using Dispatch Notes, then the Order quantity is not necessarily equal to the sum of the ship quantity and backorder quantity. This is because each dispatch note reduces the ship quantity by the quantity dispatched.

The Booking report is generated by Order, so any order and/or line discounts are included in the values.

Notes and warnings

Restrictions and limits

In a C-ISAM environment, if you select to print an Order type report for a range of stock items (or a single stock item) we recommend that you deselect the option: Print freight and miscellaneous lines. If you do not deselect this option, then all sales orders containing freight or miscellaneous lines are printed, regardless of your stock selection.
When you run the report based on a Date type of Ship date, then non-merchandise lines (e.g. freight and miscellaneous lines) are not printed on the report for Scheduled Orders.