Sales Orders > Reports > Order and Booking

Order and Booking

You use the Order and Booking program to print various reports that lists sales orders held on file.

[Note]
  • 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.
  • If you select to run the report based on a Date selection basis of Ship, then non-merchandise lines (e.g. freight and miscellaneous lines) are not printed on the report for Scheduled Orders.
  • The Booking report is generated by order, so any order and/or line discounts are included in the values.

Report Options

Field Value 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.

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.
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.

[Note]

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

See also 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.

[Note]

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.
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 below.
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 below.

[Note]

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 below.

Selections

In addition to the report options that can be selected, the following selection criteria can be defined:

  • Date selection

    Indicate the date(s) for which you want 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.

Other Options

The following selection criteria can be defined:

  • Customer selection

    Indicate the customer(s) for whom you want to include orders in the report.

  • Branch selection

    Indicate the Accounts Receivable branches for which you want to include orders in the report.

  • Salesperson selection

    Indicate the salesperson(s) for which you want to include orders in the report.

  • Source warehouse selection

    Indicate the source warehouse(s) for which you want to include orders in the report.

    This applies to Supply Chain Transfers.

  • Product class selection

    This option 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 Code Maintenance program (Descriptive tab).

    If a specific product class is entered, then only orders for stock items belonging to that product class are included in the report.

  • Stock code selection

    Indicate the

  • Order type selection

    Indicate the order type(s) for which you want to include orders in the report.

    This option is only relevant if you indicated that the order type is required (Sales Order Setup - General 2 tab).

    Order types are maintained using the Browse on Order Types program.

  • Target warehouse selection

    Indicate the target warehouse(s) for which you want 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 if the Accounts Receivable setup option: Foreign currency sales required is selected (Accounts Receivable Setup - General tab).

Field Value Description
Show values in    
Local currency Select this if you want to print foreign amounts in the local currency equivalent.
Foreign currency Select this if you want to print foreign amounts in the original currency.

Selections

The following selection criteria can be defined:

  • Currency selection

    Indicate the currency(ies) for which you want 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

If you selected 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, then the values are printed exclusive of tax.

The Order and Booking 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.

  • .