Comprehensive Order Detail Report
The Comprehensive Order Detail Report reviews comprehensive details of all orders. This report provides a detailed, comprehensive listing of information about each order, including sales credits, price adjustments, and schedule details.
Submission
In the Order Entry Reports window, enter Comprehensive Order Detail Report in the Request Name field.
Parameters
When you request a Comprehensive Order Detail Report, Oracle Order Entry/Shipping provides you with the following parameters. If you leave any of the non-required parameters blank, this report includes all orders that meet your other parameter criteria.
Warning: When running this report you must specify at least one of the parameters, for example, Order Number range. If no parameters are specified you will be selecting everything in your database.
Sort By
You can sort this report by Customer, Request Date, or Sales Representative. The default value is Order Type.
Order Type
Choose the order type(s) you want printed in this report.
Order Number
Choose the order number(s) you want printed in this report.
Customer Name
Choose the name(s) of the customer(s) you want printed in this report.
Salesrep Name
Choose the salesperson(s) you want printed in this report.
Entered By
Choose the userid of the order entry clerk whose orders you want printed in this report.
Order Category
Choose the order category of the orders you want to print in this report. You can choose either the Regular or Internal Sales Order category. If you leave this parameter blank, this report includes orders of both categories.
Show Open Orders Only
Choose whether you want to print only open orders or both open and closed orders in this report. The default value is Yes.
Show Sales Credits
Choose whether you want to print sales credits in this report. The default value is Yes.
Show Price Adjustments
Choose whether you want to print price adjustments in this report. The default value is Yes.
Show Schedule Details
Choose whether you want to print schedule details in this report. The default value is Yes.
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
Sales Credits:
Oracle Order Entry/Shipping prints information about the sales credits for the order line.
Quota Credit
Oracle Order Entry/Shipping prints whether the credit type for this order is Quota.
Percent
Oracle Order Entry/Shipping prints the percentage of the sales credit this sales representative receives for this order.
Line Number
Oracle Order Entry/Shipping prints the line number of the item for which detailed information is printed.
Ship Number
Oracle Order Entry/Shipping prints the ship set number of the item for which detailed information is printed.
Option Number
Oracle Order Entry/Shipping prints the option number of the model item for which detailed information is printed.
Item
Oracle Order Entry/Shipping prints the description of the item.
Selling Price
Oracle Order Entry/Shipping prints the actual selling price (list price with price adjustments) for this item.
Extended Price
Oracle Order Entry/Shipping prints the quantity multiplied by the selling price for this item.
Commitment
If you have Oracle Receivables fully installed, Oracle Order Entry/Shipping prints the number of the customer commitment, if any.
Promised
Oracle Order Entry/Shipping prints the promise date.
Scheduled
Oracle Order Entry/Shipping prints the schedule date.
Requested
Oracle Order Entry/Shipping prints the request date.
Line Details:
Oracle Order Entry/Shipping prints information about the schedule detail.
Price Adjustments:
Oracle Order Entry/Shipping prints information about any price adjustments for the order line.
Name
Oracle Order Entry/Shipping prints the name of the discount applied to this order line.
Amount
Oracle Order Entry/Shipping prints the monetary value of the price adjustment.
Percent
Oracle Order Entry/Shipping prints the percentage of the price adjustment.
Automatic
Oracle Order Entry/Shipping prints Yes or No to indicate whether this discount is automatic.
Prorate
Oracle Order Entry/Shipping prints whether this discount is prorated.
See Also
Overview of Sales Orders
Defining Order Types