Cancelled Orders Report
The Cancelled Orders Report reviews all orders that have been cancelled. This report provides a summary of each cancelled order, including order number, customer name, line number and item, the date and reason the order or order line was cancelled, the quantity ordered and the quantity cancelled, and who cancelled the order.
This report can be used to report total dollars cancelled in a specified time-frame, and allow you to evaluate the most common cancellation reasons, review cancellations by salesperson, or review cancellations by customers.
Submission
In the Order Entry Reports window, enter Cancelled Orders Report in the Request Name field.
Parameters
When you request a Cancelled Orders Report, Oracle Order Entry/Shipping provides you with the following parameters. If you leave any parameters blank, this report includes all cancelled orders that meet your other parameter criteria.
Sort By
You can sort this report by Cancel Date, Cancel Reason, Customer, or Sales Person. The default value is Customer.
| Cancel Date
| Oracle Order Entry/Shipping sorts this report by cancel date and then order number.
|
| Cancel Reason
| Oracle Order Entry/Shipping sorts this report by cancel reason and then order number.
|
| Customer
| Oracle Order Entry/Shipping sorts this report by customer name and then order number.
|
| Sales Person
| Oracle Order Entry/Shipping sorts this report by salesperson, customer name, and then order number.
|
Customer Name
Choose the customer(s) that you want printed in this report.
Order Type
Select the order type that you want printed in this report.
Order Number
Choose the range of order numbers that you want printed in this report.
Salesrep Name
Choose the salesperson(s) that you want printed in this report.
Cancel Date
Choose the range of cancel dates that you want printed in this report.
Cancel Reason
Choose the reason for the cancellation of the orders that you want printed in this report.
Cancelled By
Choose the userid(s) of the person(s) who cancelled the order(s) that you want printed in this report.
Item
Choose the name of the item that you want printed in this report.
Item Display
Choose Description or Flexfield depending on whether you want the item name or description to be printed in this report under the Item column heading. The default value is Description.
Order Category
Choose the order category for the cancelled orders that you want printed in this report. You can choose from Regular or Internal Sales Order. The default value is Regular.
Mixed Precision
If you are printing this report in multiple currencies you can use Mixed Precision to ensure that all currency values align at the radix character for easy readability. Mixed precision is the distance between the radix (the decimal, or any dividing symbol between the whole and parts of the currency) and the right side of the column. It is right padded if the currency's standard precision is less than the mixed precision. For example:
Oracle Order Entry/Shipping defaults this parameter from the profile Currency: Mixed Precision.
Show in Functional Currency
Choose Yes if you want to print any currency amounts in the functional currency for your set of books, or No if you want to print any currency amounts in the currency for the order. The default value is No.
Column Headings
Item
Oracle Order Entry/Shipping prints the name or description of the item, depending on your selection for the Item Display parameter.
See Also
Cancelling Orders
