2013-04-19 - 4674.1200 - Rel Notes - BI Reports Issues - Release 002 #BIReleases2013
Release Notes:
4674.1200 - BI Reports Issues - COM101
Admin Info
Purpose
|
To fix the issues in BIBO 4.0 Production server
|
Release No
|
002
|
Submitted
|
04-19-2013
|
Submitted by
|
Naga Brahmam
|
Source/Destination Systems
|
IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
|
Release Sent To
|
Mark Harris
|
Object(s) Created By
|
Naga Brahmam
|
Object(s) Tested By
|
Naga Brahmam
|
Report Name
COM101 - Commission Pay Report (Item on Demand)
Name(s) of Tables Used
BKPF [Accounting Documnet Header]
BSAD [Accounting: Secondary Index for Customer (Cleared Items)]
CE10010[Billing Document: Header Data]
KNA1[General Data in Customer Master]
KONV[Conditions (Transaction Data)]
TVGRT [Organizational Unit: Sales Groups:Texts]
TVKBT [Organizational Unit: Sales Offices:Texts]
TVM2T [Material Pricing Group 2: Description]
TVM3T [Material Pricing Group 3: Description]
VBRP [Billing Documnet: Item Data]
NEC Crystal Reports Standards Check
1. COM101 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. COM101 NEC CR checklist has been sent to NEC and also attached here for reference:
COM101 NEC CR Standard Check List.xlsx
Summary Level Check
Test Conducted
Group: 0090650112 > 000000000010145628
SNo
|
Test case Name
|
Value in BO 3.1
|
Value in BI 4.0
|
Pass/Fail Criteria
|
1
|
Company Code
|
0040
|
0040
|
Pass
|
2
|
Sales Org
|
2100
|
2100
|
Pass
|
3
|
Sales Manager
|
Horst Brandes
|
Horst Brandes
|
Pass
|
4
|
Sales Rep
|
Markus Finke
|
Markus Finke
|
Pass
|
5
|
Customer #
|
0001004350
|
0001004350
|
Pass
|
6
|
Customer Name
|
-
|
-
|
Pass
|
7
|
Purchase Order #
|
867500395
|
867500395
|
Pass
|
8
|
Invoice date
|
1/14/2011
|
1/14/2011
|
Pass
|
9
|
FI DOC. #
|
0090650112
|
0090650112
|
Pass
|
10
|
SD billing
|
0090650112
|
0090650112
|
Pass
|
11
|
Order #
|
0000583211
|
0000583211
|
Pass
|
12
|
Total Invoice Amount In Doc curr
|
19,726.63
|
19,726.63
|
Pass
|
13
|
Invoice No Freight, No Tax
|
524.00
|
524.00
|
Pass
|
14
|
Commission in doc curr.
|
0.00
|
0.00
|
Pass
|
15
|
Doc Currency
|
EUR
|
EUR
|
Pass
|
16
|
Invoice Amount in Local curr
|
19,726.63
|
19,726.63
|
Pass
|
17
|
Commission in Local currency
|
0.00
|
0.00
|
Pass
|
18
|
Local Curr.
|
EUR
|
EUR
|
Pass
|
19
|
Exchange Rate
|
1.00000
|
1.00000
|
Pass
|
20
|
Plant
|
0320
|
0320
|
Pass
|
21
|
Shipping Point
|
0320
|
0320
|
Pass
|
22
|
Item ID
|
-
|
-
|
Pass
|
23
|
Material Number
|
000000000010145628
|
000000000010145628
|
Pass
|
24
|
Material group 1
|
M02
|
M02
|
Pass
|
25
|
Material group 2
|
042
|
042
|
Pass
|
26
|
Material Group 2 Description
|
MLB 20 HD899 NON REP ADJ M
|
MLB 20 HD899 NON REP ADJ M
|
Pass
|
27
|
Material group 3
|
020
|
020
|
Pass
|
28
|
Material Group 3 Description
|
MLB20 REP ADJ
|
MLB20 REP ADJ
|
Pass
|
Group: 0091496924 > 000000000010759171
SNo
|
Test case Name
|
Value in BO 3.1
|
Value in BI 4.0
|
Pass/Fail Criteria
|
1
|
Company Code
|
0014
|
0014
|
Pass
|
2
|
Sales Org
|
5000
|
5000
|
Pass
|
3
|
Sales Manager
|
Al Derago
|
Al Derago
|
Pass
|
4
|
Sales Rep
|
Gerry Cruz
|
Gerry Cruz
|
Pass
|
5
|
Customer #
|
0001012678
|
0001012678
|
Pass
|
6
|
Customer Name
|
KMART MANAGEMENT CO
|
KMART MANAGEMENT CO
|
Pass
|
7
|
Purchase Order #
|
245672989
|
245672989
|
Pass
|
8
|
Invoice date
|
1/25/2013
|
1/25/2013
|
Pass
|
9
|
FI DOC. #
|
0091496924
|
0091496924
|
Pass
|
10
|
SD billing
|
0091496924
|
0091496924
|
Pass
|
11
|
Order #
|
0001355050
|
0001355050
|
Pass
|
12
|
Total Invoice Amount In Doc curr
|
59.10
|
59.10
|
Pass
|
13
|
Invoice No Freight, No Tax
|
59.10
|
59.10
|
Pass
|
14
|
Commission in doc curr.
|
0.59
|
0.59
|
Pass
|
15
|
Doc Currency
|
USD
|
USD
|
Pass
|
16
|
Invoice Amount in Local curr
|
59.10
|
59.10
|
Pass
|
17
|
Commission in Local currency
|
0.59
|
0.59
|
Pass
|
18
|
Local Curr.
|
USD
|
USD
|
Pass
|
19
|
Exchange Rate
|
1.00000
|
1.00000
|
Pass
|
20
|
Plant
|
1420
|
1420
|
Pass
|
21
|
Shipping Point
|
0116
|
0116
|
Pass
|
22
|
Item ID
|
-
|
-
|
Pass
|
23
|
Material Number
|
000000000010759171
|
000000000010759171
|
Pass
|
24
|
Material group 1
|
AP1
|
AP1
|
Pass
|
25
|
Material group 2
|
5WR
|
5WR
|
Pass
|
26
|
Material Group 2 Description
|
5TH T-SHIRT NOT AUTH * MASS
|
5TH T-SHIRT NOT AUTH * MASS
|
Pass
|
27
|
Material group 3
|
5WR
|
5WR
|
Pass
|
28
|
Material Group 3 Description
|
MLB11 5TH WOMEN'S AND GIRL'S
|
MLB11 5TH WOMEN'S AND GIRL'S
|
Pass
|
Reference Document(Specification)
2013-04-18 - 4674.1200 - Spec - BI Reports Issues