Order/Invoice Detail Report (Oracle Order Entry / Shipping--Production)


	Previous	Next		Contents	Index	Navigation	Glossary	Library

Order/Invoice Detail Report

The Order/Invoice Detail Report reviews detailed invoice information for orders that have invoiced. You can choose from a variety of parameters to print the invoice information for a specific order or group of orders. If there are no invoices for a particular order that meets your parameter criteria, Oracle Order Entry/Shipping prints in the report that no invoices exist for that order.

Submission

In the Order Entry Reports window, enter Order/Invoice Detail Report in the Request Name field.

Parameters

When you request an Order/Invoice 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.

Sort By

Choose the category by which you would like to have your report sorted. You can sort this report by Customer Name, Order Type or Salesperson. The default value is Customer Name.

Customer Name Oracle Order Entry/Shipping sorts this report by currency, customer, and then order number.

Order Type Oracle Order Entry/Shipping sorts this report by currency, order type, customer, and then order number.

Salesperson Oracle Order Entry/Shipping sorts this report by currency, salesperson, customer, and then order number.

Open Orders Only

Choose No if you want to include both open and closed orders in this report. The default value is Yes.

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.

Customer Name

Choose the customer(s) on the orders you want printed in this report.

Sales Person

Choose the salesperson(s) for the orders you want printed in this report.

Order Type

Choose the order type(s) of the orders that you want printed in this report.

Order Number

Choose the order number or range of orders you want printed in this report.

Ship to Country

Choose the country for the ship to addresses of the orders you want printed in this report.

Use 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 return. The default value is No.

Column Headings

Invoice Number

Oracle Order Entry/Shipping prints the invoice numbers for each order listed on this report. If an order has several invoices, you will see them listed separately.

Invoice Line

Oracle Order Entry/Shipping prints the invoice line number.

Invoice Item

Oracle Order Entry/Shipping prints the name or description of the item on the invoice, depending on your selection for the Item Display parameter.

Customer Name	Oracle Order Entry/Shipping sorts this report by currency, customer, and then order number.
Order Type	Oracle Order Entry/Shipping sorts this report by currency, order type, customer, and then order number.
Salesperson	Oracle Order Entry/Shipping sorts this report by currency, salesperson, customer, and then order number.