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.
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. |
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.
|
Sales order selection | Indicate the sales order(s) you want to include in the report. |
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. |
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. |
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. |
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).
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.