Sunday, April 24, 2016

Unbooked Orders Detail Report,PRINT ORDERS BY CUSTOMER WISE

TICKET 8: Unbooked Orders Detail Report
What Is:Use the Unbooked Orders Report to review orders you have entered but not booked. This 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.
What it is:
Customization: TO PRINT ORDERS BY CUSTOMER WISE
Parameters: Sort by -Order Number:Manager:Created by, Created by (From),  Created by (To),Order Date(From),Order Date (To),Order Type(From),Order Type(To), Manager (From), Manager(To),Use Ledger Currency
TABLES: fnd_user, mtl_system_items_vl,oe_order_lines_all , oe_order_headers_all ,oe_order_types_v , mtl_customer_items, hz_cust_site_uses_all  , hz_cust_acct_sites_all, hz_party_sites,hz_parties bill_to_party, hz_cust_accounts, hz_parties,  hz_cust_accounts, per_all_people_f,per_all_assignments_f,per_all_people_f

QUERY:
sold_to_party.party_name sp,





No comments:

Post a Comment

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...