Sunday, April 24, 2016

Order Discount Detail Report,Add SubTotals for Selling Price and List Price

TICKET 9: Order Discount Detail Report:
What Is:The Order Discount Detail Report reviews discounts applied to orders by order line detail. This report provides detailed line pricing information, including price list price, selling price, and discount information.
What it is: The Order Discount Detail Report reviews discounts applied to orders by order line detail. This report provides detailed line pricing information, including price list price, selling price, and discount information.
Customization: To Add SubTotals for Selling Price and List Price unit_list_price,unit_sell_price Formula columns(list_price,sell_price) IN some data group(line_template)
Parameters:Sort by,Customer Number(From),Customer Number(To),Order Date(From),Order Date (To),Order Type(From),Order Type(To),Line Type(From),Line Type(To)
Manditory Parameters:Open Order Only,Item Display,Mixed Precision
TABLES: OE_ORDER_LINES_ALL, OE_ORDER_TYPES_V, OE_LINE_TYPES_V, HZ_CUST_SITE_USES_ALL ,HZ_CUST_ACCT_SITES_ALL,HZ_LOCATIONS,HZ_PARTY_SITES,
 MTL_SYSTEM_ITEMS_TL ,MTL_SYSTEM_ITEMS_B_KFV,RA_SALESREPS,  OE_SOLD_TO_ORGS_V           
OE_PRICE_ADJUSTMENTS,QP_LIST_HEADERS_VL ,OE_ORDER_HEADERS_ALL



No comments:

Post a Comment

Types of animations

Animation is a diverse and creative field with a variety of styles that artists and filmmakers use to bring their visions to life. Here are ...