2013-04-19 - 4674.1200 - Rel Notes - BI Reports Issues - Release 003 #BIReleases2013
Release Notes:
4674.1200 - BI Reports Issues - COM140
Admin Info
Purpose
|
To fix the issues in BIBO 4.0 Production server
|
Release No
|
003
|
Submitted
|
04-19-2013
|
Submitted by
|
Praveen Guntuka
|
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
|
Praveen Guntuka
|
Object(s) Tested By
|
Praveen Guntuka
|
Report Name
COM140 - Commission Reconciliation Report
Name of the Queries
SAP Infoset ZSDROYALTYALL
NEC Crystal Reports Standards Check
1. COM140 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. COM140 NEC CR checklist has been sent to NEC and also attached here for reference:
COM140 NEC CR Standard Check List.xlsx
Summary Level Check
Test Conducted
SNo
|
Test Case
|
Value in Edge Report
|
Value in BOBI 4.0 Report
|
Pass/Fail Criteria
|
1
|
Sales Group
|
Tim Isaacson
|
Tim Isaacson
|
Pass
|
2
|
License
|
MLB PROPERTIES
|
MLB PROPERTIES
|
Pass
|
3
|
Sales Org
|
Canada Sales
|
Canada Sales
|
Pass
|
4
|
SBU
|
FANGEAR
|
FANGEAR
|
Pass
|
5
|
Country
|
CA
|
CA
|
Pass
|
6
|
Sold To
|
1009280
|
1009280
|
Pass
|
7
|
Customer Name
|
HATWORLD DIV OF GCO CANADA INC.
|
HATWORLD DIV OF GCO CANADA INC.
|
Pass
|
8
|
Inv Date
|
26-02-2013
|
26-02-2013
|
Pass
|
9
|
Posting Date
|
26-02-2013
|
26-02-2013
|
Pass
|
10
|
Invoice
|
91540046
|
91540046
|
Pass
|
11
|
Material Group 1
|
Global Customs MLB
|
Global Customs MLB
|
Pass
|
12
|
Material Group 2
|
MLB 15 HD395 NON REP FLX MEN
|
MLB 15 HD395 NON REP FLX MEN
|
Pass
|
13
|
Material Group 3
|
MLB15 NREPF
|
MLB15 NREPF
|
Pass
|
14
|
Team
|
BOSTON RED SOX
|
BOSTON RED SOX
|
Pass
|
15
|
Logo
|
NONE
|
NONE
|
Pass
|
16
|
QTY
|
576
|
576
|
Pass
|
17
|
Unit Price
|
10.15
|
10.15
|
Pass
|
18
|
Revenue
|
5846.4
|
5846.4
|
Pass
|
19
|
Revenue/NoTax/NoFreight
|
5846.4
|
5846.4
|
Pass
|
20
|
Poly Bag
|
0
|
0
|
Pass
|
21
|
Comm/Unit
|
0.0761284722222222
|
0.0761284722222222
|
Pass
|
22
|
Comm Due
|
43.85
|
43.85
|
Pass
|
23
|
Material ID
|
10030437
|
10030437
|
Pass
|
24
|
Material
|
BOSRED BLKWHT ACE BLKWHT
|
BOSRED BLKWHT ACE BLKWHT
|
Pass
|
25
|
Document Type
|
M
|
M
|
Pass
|
26
|
Customer Discount
|
00
|
00
|
Pass
|
27
|
Customer Discount Text
|
Dealer Disc 0%
|
Dealer Disc 0%
|
Pass
|
28
|
UOM
|
EA
|
EA
|
Pass
|
Test Conducted
SNo
|
Test Case
|
Value in Edge Report
|
Value in BOBI 4.0 Report
|
Pass/Fail Criteria
|
1
|
Sales Group
|
Isaacson/Lovern
|
Isaacson/Lovern
|
Pass
|
2
|
License
|
MLB PROPERTIES
|
MLB PROPERTIES
|
Pass
|
3
|
Sales Org
|
Canada Sales
|
Canada Sales
|
Pass
|
4
|
SBU
|
BASEBALL - ON FIELD
|
BASEBALL - ON FIELD
|
Pass
|
5
|
Country
|
CA
|
CA
|
Pass
|
6
|
Sold To
|
1009280
|
1009280
|
Pass
|
7
|
Customer Name
|
HATWORLD DIV OF GCO CANADA INC.
|
HATWORLD DIV OF GCO CANADA INC.
|
Pass
|
8
|
Inv Date
|
26-02-2013
|
26-02-2013
|
Pass
|
9
|
Posting Date
|
26-02-2013
|
26-02-2013
|
Pass
|
10
|
Invoice
|
91540516
|
91540516
|
Pass
|
11
|
Material Group 1
|
Authentic Collection MLB - BP
|
Authentic Collection MLB - BP
|
Pass
|
12
|
Material Group 2
|
MLB 03 HD476 AC BP FIT MEN
|
MLB 03 HD476 AC BP FIT MEN
|
Pass
|
13
|
Material Group 3
|
MLB3 AC BP
|
MLB3 AC BP
|
Pass
|
14
|
Team
|
TORONTO BLUE JAYS
|
TORONTO BLUE JAYS
|
Pass
|
15
|
Logo
|
NONE
|
NONE
|
Pass
|
16
|
QTY
|
46
|
46
|
Pass
|
17
|
Unit Price
|
13.5
|
13.5
|
Pass
|
18
|
Revenue
|
621
|
621
|
Pass
|
19
|
Revenue/NoTax/NoFreight
|
621
|
621
|
Pass
|
20
|
Poly Bag
|
0
|
0
|
Pass
|
21
|
Comm/Unit
|
0.0945652173913044
|
0.0945652173913044
|
Pass
|
22
|
Comm Due
|
4.35
|
4.35
|
Pass
|
23
|
Material ID
|
10757125
|
10757125
|
Pass
|
24
|
Material
|
MLB BP 5950 TORJAY 2013
|
MLB BP 5950 TORJAY 2013
|
Pass
|
25
|
Document Type
|
M
|
M
|
Pass
|
26
|
Customer Discount
|
00
|
00
|
Pass
|
27
|
Customer Discount Text
|
Dealer Disc 0%
|
Dealer Disc 0%
|
Pass
|
28
|
UOM
|
EA
|
EA
|
Pass
|
Reference Document(Specification)
2013-04-18 - 4674.1200 - Spec - BI Reports Issues