Detailed Reports Information of some reports

UNBOOKED ORDERS REPORT
The unbooked Orders Report reviews orders you have entered but not booked.
Thes report shows you the order number order date ordered item and line amount for each unbooked order line you choose as well as the user who entered the order.
Submission:
in the Order Management Reports window select Unbooked Orders Report is the
Name field.
Parameters:
When you request a Unbooked Orders Report, Order Management provides you
with the following parametes. If you live any of the non requred parameters blank, this report includes all unbooked orders that meet your other parameter criteria.
In order to obtain a single unbooked order, enter the same unbooked order in
the From and To fields.
Sort by; (mandatory)
Choose from created by or order number. The default value is Order Number.
Created By (from/to)
Choose the user ids of the order entry clerk who entered the order that you want
printed in this report.
Order Date(from/to)
Choose the range of order dates you want printed in this report.
Order category
Line Category
Item Display (mandatory)

Column Headings:

Order Number
Order management prints the order number of the item on each order line.
Order Date
Order Management prints the order date of the item.
Created By
Order management print the user who created the order
Item
Order Management prints the Item Flexfield value of the item on each order line
Description
Order Management print the sdescription of the item on each order line.
Extended Line Amount
Order Management prints the extended order line amount for each order line.

Add a summary column to display all unbook orders.
Total of extended line amount
Name it group by currency and order date (it was group by currency and order number)
Order by order date
Application -- Oracle Order Management
Executable -- OEXOEUBR.
Tables
fnd_user
mtl_system_items_vl
oe_order_lines_all
oe_order_headers_all
oe_order_types_v
mtl_customer_items
ra_site_usesbill_site
ra_customerssold_to
per_all_people_fppf_mgr
per_all_assignments_f
per_all_people_f


VENDORS ON HOLD REPORT

The vendor on Hold Report lists all suppliers placed on hold. This report also
prints all purchase orders you still have outstanding with vendor on hold.
Report Submission
In the Submit Requests window. select vendors on hold report in the Name field.
Report parameters
supplier Names From/ To
enter the begining and ending vendor names.
PO Numbers From/To
Enter the beginning and ending purchase order numbers.
Sort by
Use the sort by feature to produce a report custmized to your specific needs.
Choose one of the following the options: sort the report by purchase order number sort the report by supplier.
Dynamic precision Option
Enter the decimal precision for quantities on the report
Application --- Oracle purchasing
Executable--POXVDVOH
REPORT COLUMN

PO order
vendor number
creation date
Hold reason
status
currency
Hold date
Hold by
ammount
New column(tables--PO_LINE-LOCATION,PO_LINES,PO_LINE_TYPE)
(quantity)Amount ordered(PO_LINE_LOCATIONS,PO_LINES)(quantity)
(Quantity)Amount received (PO_LINE_LOCATIONS)
(quantity)Amount due(PO_LINE_LOCATIONS)
Tables
gl_sets_of_books
financials_system_parameters
hr_employees
Po_system_parameters
po_lookup_codes
Po_vendors
po_headers
po_line_locations

ORDERS SUMMARY REPORT

The Order Summary Report reviews orders you have entered.
This report shows you the order number customer Nme, customer op.
Agreement order status, list amount ordered amount shipped amount
created by for each order you choose as well as line sales person rep
(new column added) who entered the order.

Submission
In the Oracel Order Entry Reports window, lelect Orders Summary
Report in the Name field.
Parameters
When you request a Unbooked Orders Report, Order Management provides you
with the following parametes. If you live any of the non requred parameters blank,
this report includes all entered orders that meet other parameter criteria. In order
to uptain a single entered order, enter the same enter order in the from and to
fields.
Sort by (MANDATORY)
Choose from created by or order number. The default value is order date.
Sales person name (from/to)
Order date (from/to)
Order number (from/to)
Ship To Cuountry (from/to)
Order Type (from/to)
Customer PO number (from/to)
Ordered by (from/to)
Order Source (single)
Open Order Only (mandatory dafault val is Yes single)
(Use functional currency only)
Add new column for salesperson of order (got from RA_SALESREPS)
And change order by clause to order by order date (it was order by order number)
APPLICATION - ORACLE ORDER MANAGEMENT
EXECUTABLE - OEXOEOSR

Tables
oe_order_headers_all
oe_order_lines_all
oe_order_types_v
fnd_user
oe_agreements
ra_site_uses
ra_addresses
ra_salesreps (NAME OF SALES REP)
fnd_territories_vl
oe_sold_to_orgs_v


VENDOR PURCHASE SUMMARY REPORT
The Vendor Purchase Summary report lists the numbers and amount of orders you have placed with various suppliers during a particular period. You can use this information to analyze and manage your purchasing valume with your Vendor.
Report Submission
In the Submit Requests window. select Vendor Purchase Summary Report in the
Name field
Report Paramdeters
Creation Dates From/To
Enter the beginning and ending creation dates
Supplier type
Enter the supplier type from the Lookup Codes window to restrict the report to a specific supplier type.
Small business
Enter Yes to restrict the report to small business suppliers.
Minority Owned
Enter Yes to resrtict the report to minoriry owned suppliers.
Women Owned
Enter Yes to restrict the report to women owned suppliers.
Sort by
Use the Sort By fearure to produce a report customized to your specific
needs. Choose one the following options.
Sort the report by supplier name,supplier site, and PO number
Sort the report by supplier type,supplier name,supplier site, and PO number
Application;--Oracle purchasing
Executable-- POXPOVPS
Report column

Vendor name
vendor number
vendor site
PO type
PO number
Creation date
Reserved date
Currency
Description
PO amount
functional amount
add new column for vendor type(Table--PO-LOOKUP-CODES)
Amount ordered( PO_LINE-LOCATIONS,PO_LINES)
Amount received (PO_LINE_LOCATIONS)
Amount due ((PO_LINE_LOCATION)
TABLES
gl_sets_of_books
financials_system_parameters
mtl_default_sets_view
fnd_lookups
fnd_currencies
po_line_locations
po_headers
po_vendor_sites
po_vendors

OVERSHIPMENTS REPORTS
The overshipments Report lists purchase order receipts with a quantity
received greater than the quantity ordered. You can also use the Overshipments
Report to identify service overcharges or suppliers who deliver more than the requested
quantity.

Report Submission
In the Submit Requests window. select Overshipments Report in the Name field
Report Parameters
Receipt Location
Enter the receiipt location to restrict the report to overshipments to a specific internal location
Receiver
Enter the name of tghe employee to restrict the report to overshipments to a specific receiver.
Receipt Date From/To
Enter the beginning and ending receiipt dates to restrict he dreport to a range of receipt dates.
Supplier From/To
Enter the beginning and ending supplier names to restrict the report to a range of suppliers.
Supplier site
Enter the supplier site to restrict the report to overshipments to a specific supplier site.
Organization Name
Enter the organization name to restrict the report to a specific organization.
Sort By
Use the sort By feature to produce a report customized to your specific needs.
Choose one of the following options:
Sort the report by document number. This is the default if you do not choose an option.
Sort the report by supplier.
Quantity Precision Option
Enter the decimal precision for quantities on the report.
Tables
gl_sets_of_books
financials_system_parameters
mtl_default_sets_view
fnd_lookups
po_vendors
poA_vendor_sites
po_lines
mtl_system_items
financials_system_parameters
hr_locations
po_line_types
po_line_locations
po_headers
mtl_categories
po_lookup_codes
po_document_types
po_system_parameters
hr_employees
rcv_transactions
rcv_shipment_headers
po_lookup_codes
mtl_transaction_reasons
org_organization_definition

ORDER/INVOICE SUMMARY REPORT

The Order/Invoice Summary Report reviews summary invoice information about order that have invoiced, including ordered amount, invoiced amount, adjusted receivables and orders that have been invoiced.
Submission
in the order management Reports window, select Order/invoice Summary Report in the Name field.
Parameters
When you request a Order/Invoice Summary Report, Order Management provides you with the following parameters. If you leave any parameters blank. this report includes all orders that meet your other parameter criteria. In order to obtain a single order. Enter the same order in the from and to fields.
Sort by
Choose from customer name, order type, and salesperson to include in this report.
Open Orders only
Choose No if you want to print both open and closed orders in this report. The default value is yes.
Customer Name (From/To)
Choose the ranbe fo customers that you want printed in this report.
Salesperson(From/To)
Choose the range of salespeople that you want printed in this report.
Order Type(From/To)
Choose the range of order type that you want printed in this report.
Attention: Non-invoiced orders print which display a zero(0) balance due. Non-invoiced
orders display the message, No Invoices /exist For this Order.Order/invoice summary Report
Order Number(From/To)
Choose the range of order numbers that you want printed in this report..
Ship-To country
Choose the country for the ship to addresses of the shipments you want printed in this report/
Show in Functional Currency
Choose Yes if you want to print any currency amounts in the functional currency. or No if you
want tro print any currency amounts in the cureency for trhe order. The default value is No.

Column headings

Total Credits/Adjustments
Order Management prints the total amount of receivable credits or adjustments applied to the
invoice.
Balance Due
Order Management prints the outstanding balance for the invoice
Ordered Amount
Order Manafementr prints the quantity requested for each order.
Invoiced Amount
Order management prints the invoiced amount for each order.
Tables
oe_order_lines_all
ra_customer_trx
ra_customer_trx_lines
oe_order_headers_all
oe_order_lines_all
oe_order_types_v
ra_siteuses
ra_addresses
ra_salesreps
fnd_territories_vl
oe_sold_to_org_v