customization of sales order report

----------------------sales order customization report-----------------------------

COMMERCIAL SALES REPRESENTATIVES PERFORMANCE :

This report is used to get all the details of commercial sales made by the Sales Representative by the particular period and product wise.

Technical Overview:

Ø  COMMERCIAL SALES REPRESENTATIVES PERFORMANCE--

Ø  This Report exist in OM Module and the Concurrent Program name is

APPLC - Commercial Sales Reps Performance Report

Ø  This report is having 3 parameters

1.Period (Mandatory)

2.Sales Person

3.Product

Table and View Usage:

Table Name	Select	Insert	Update	Delete	Base Table
oe_order_headers_all	Y	N	N	N	Y
org_organization_definitions	Y	N	N	N	Y
oe_order_lines_all	Y	N	N	N	Y
wsh_delivery_details	Y	N	N	N	Y
wsh_new_deliveries	Y	N	N	N	Y
ra_customer_trx_all	Y	N	N	N	Y

 

Value Sets

Value Set	Size	Type	Required	Validation/Values
APPLC_PERIODS	10	Char	Yes
APPLC_SALES_REPS	200	Char	No
APPLC_SALES_REPS_ITEM_DESC	200	Char	No

Columns for this report:

SALES_PER_NAME ,

ORDER_NUMBER,

ORDERED_ITEM,

ITEM_DESCRIPTION,

sum(SHIPPED_QUANTITY),

UNIT_SELLING_PRICE,

sum(SHIPPED_QUANTITY*UNIT_SELLING_PRICE),

TO_CHAR(CONFIRM_DATE,'DD-MON-YYYY') shipped_date,

to_char(TRX_DATE,'DD-MON-YYYY') INVOICE_DATE,

Tables for this report:

OE_ORDER_HEADERS_ALL

ORG_ORGANIZATION_DEFINITIONS

OE_ORDER_LINES_ALL

wsh_delivery_details

WSH_NEW_DELIVERIES

ra_customer_trx_all

jtf_rs_salesreps

join columns:

HEADER_ID

ORDER_NUMBER

ORGANIZATION_ID

SOURCE_HEADER_ID

LINE_ID

the process of customization is,

1)I have taken standard inventory evaluation report and renamed that report with some other name.

 and placed the report in server.

2)went to system administrator responsibility and took standard report in concurrent program, and gone through copy to button and renamed that program name and short name.

3)In the executable part taken report name as executable file name and saved the changes that i have made.

4)added this report to inventory responsibility.

5)did changes in the renamed report.

6) In the data model added added required two columns in the sql code. Those two columns are line_id from oe_order_lines_all table and trx_number from ra_customer_trx_all

7)after adding those, i have assigned those two fields in the respective group(because if add columns in the sql code those two fields will come down to the lowest group so assigned those two fields in respective groups).

8)and coming to layout part, selected two fields and placed it respective repeating frame and assigned source to those two fields.

9) here have to be careful in the process of placing the fields in the repeating frame.

10)after doing changes, compiled the report, if compilation is successful means,placed that report in the server,

11)and gone to inventory module and submit the request for that respective concurrent program.

12) if the request came normal means, then taken print out for that output.

13)if that output is error out means, seen the error in view log, again gone through report and made the changes according to that error message and saved the report. compiled. again and placed that report in the server and submitted request in the inventory responsibility, until getting the request condition as completed and normal.

This is the process what I have did in Sales order report….