Previous  Next          Contents  Index  Navigation  Glossary  Library

Open Returns Report

The Open Returns Report reviews summary information about open returns (RMAs). You can identify returns that have been open for a certain number of days and that have outstanding receipts for a certain number of days.

Submission

In the Order Entry Reports window, enter Open Returns Report in the Request Name field.

Parameters

When you request an Open Returns 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 returns that meet your other parameter criteria.

Sort By

You can sort this report by Customer Name, Return Type, or Warehouse. The default value is Customer Name.

Customer Name Oracle Order Entry/Shipping sorts this report by currency, customer name, return number, return line number, and then option number.
Return Type Oracle Order Entry/Shipping sorts this report by currency, order type, customer, return number, return line number, and then option number.
Warehouse Oracle Order Entry/Shipping sorts this report by currency, warehouse, customer, return number, return line number, and then option number.

Open Returns Only

Choose No if you want both open and closed returns printed 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.

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.

Customer Name

Choose the customer name whose returns you want printed in this report.

Customer Number

Choose the customer number whose returns you want printed in this report.

Warehouse

Choose the warehouse for the returns you want printed in this report.

Return Type

Choose the order type you want printed in this report.

Return Number

Choose the range of the return numbers you want printed in this report.

Return Date

Enter the range of the return dates you want printed in this report.

Return Days

Enter the range of return days for returns you want printed in this report. The number of return days is calculated as the number of days between the Return Date and the current date.

Expected Receipt Date

Enter the range of dates for the expected receipt date for the returns you want printed in this report.

Receipt Days

Enter the range of receipt days for returns you want printed in this report. The number of receipt days is calculated as the number of days between the Expected Receipt Date and the current date.

See Also

Overview of Returns

         Previous  Next          Contents  Index  Navigation  Glossary  Library