Sales Orders > Reports > Backlog Report by Customer

Backlog Report by Customer

You use this program to generate a list of all outstanding orders for a range of selected customers. A single line is printed for each stock item against which an order has been placed.

Report Options

Field Description
Selection  
Orders Select this to generate the report for sales orders, excluding supply chain transfer orders.
Supply chain transfers Select this to generate the report for supply chain transfer orders only.
Date selection  
All Select this to include orders for all dates in the report.
Entry

Select this to select sales orders based on their order entry in the Sales Order Entry program.

Ship

Select Ship to select sales orders based on the line ship date specified in the Sales Order Entry program.

Status

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

From

This indicates the first date in a range of dates for which you want to include orders in the report.

This date refers to either the entry, ship or invoice date depending on whether you selected to include orders based on Entry, Ship or Status dates.

To

This indicates the last date in a range of dates for which you want to include orders in the report.

This date refers to either the entry, ship or invoice date depending on whether you selected to include orders based on Entry, Ship or Status dates.

Selection criteria

Field Description
Customer selection Indicate the customer(s) for which you want to include sales orders in the report.
Stock code selection

Indicate the stock code(s) that you want to include in the report.

  • Rev/Rel

    This option is only available if you selected to print the report for a single stock code.

    It enables you to define the single revision and release for the selected stock code to include in the report.

    The wording for this field (as well as the column headings on the report) defaults to the text defined against the User-defined fields: Revision and Release (Bill of Materials Setup).

    This option is available only if the Engineering Change Control module is installed and the Stock control level is be set to Revision or Release (Bill of Materials Setup).

Sales order selection Indicate the sales order(s) you want to include in the report.

Other Options

The options on this tab page enable you to indicate additional selection criteria according to which orders are selected for printing.

Field Description
Print options  
Print only if stock on hand

This applies only if a single warehouse was entered at the Warehouse selection field.

This enables the program to determine whether there is sufficient stock on hand for the order to be shipped.

Print only if order line contains b/order qty Select this to include order lines containing a non-zero backorder quantity.
Print customer purchase order number Select this to print the customers' order numbers for the order selected on the report.
Include non-allocated scheduled orders Select this to include scheduled orders that have not yet been allocated on the report.
Include lines with negative back order qty Select this to include order lines containing a negative backorder quantity.

Selection criteria

Field Description
Warehouse selection

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

If you print the report for a single warehouse, then the On hand, Free and Available quantity for each stock item is displayed for the selected warehouse.
Branch selection Indicate the branch(es) 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). Order types are maintained using the Order Types program.

Currency Options

The options on this tab page enable you to indicate how to print order values on the report. This is only relevant when the Foreign currency sales required option is enabled (Accounts Receivable Setup).

Field Description
Show values in  
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 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 SO value when tax is inclusive (Sales Orders Setup) and the tax code used on the sales order was inclusive, then the values are printed exclusive of tax.

The status of each order is listed in the Stat column as follows:

Status Description
Hd/Bo Status 2 - Open backorder
Rel/Bo Status 3 - Released backorder
Rlsed Status 8 - Released for invoicing
Shipd Status 4 - In warehouse - delivery note printed
Book Status 1 - Open order
Cr/Sp Status S - Suspense
Fwd Status F - Forward order

If the status 'Sched' is listed against an order line, then this indicates that the line is scheduled, but not yet allocated. This overrides the order status for the order.

This report does not include SCT (supply chain transfer) orders. The report can, however, be generated for supply chain transfer orders only.

This report is generated at line level and therefore only includes line discounts (and not order discounts) in the values.

The stock code description is shown on each line and not as a header, because the description could vary per line.