BI-Dhananjay - 2017-08-14 - 52272 - Break Fix - XPO carton labels (Saravanan Lakshmanan by 2917-08-25) #wipdoc
BREAK FIX
52272 - 10546 - XPO carton labels
Problem Summary
Need to fix the UPC number issue in SNC160 report.
Admin Info
| Purpose |
Need to fix the UPC number issue in SNC160 report. |
| Requested by |
Saravanan Lakshmanan |
| Issue Date |
08-14-2017 |
| Resolved by |
Dhananjay G |
| Resolved Date |
08-18-2017 |
| Document Status |
WIP |
Detailed Problem Description
WF Ticket Assigned from Saravanan Lakshmanan on 08/10/2017:
The UPC numbers are incorrect on the XPO carton labels for PO 4500198767, downloaded from the Supplier Portal.Solution Analysis and Recommendations
1. Need to check the logic in the report.
2. Need to check the table joins.
3. Need to validate the reports with SAP Tables.
4. Need to place the report in BI development and inform NEC for promotion after successful validation.
Test Plan
| Test ID |
Test Scenario |
Expected Results |
| 1 |
Report Format. |
Should be as per NEC crystal standard checklist. |
| 2 |
Execute Crystal Report in Crystal Designer tool after changes. |
Report should execute successfully in Crystal Designer tool. |
| 3 |
Schedule the Report in NEC BI Launch Pad. |
Report should execute successfully in NEC BI Launch Pad. |
Resolution
1. Added new table i.e MEAN for solving UPC number issue in the report, the below highlighted links are new to added up.
2. The report is validated with the all issued PO's as below:
4500198767
4500181923
4500194279
4500184714
4500195328
4500195329
4500195925
4500195114
4500196289
4500189492
4500194046
4500189423
4500196737
4500197329
4500193618
3. Placed the report in BI development and informed NEC for promotion after successful validation.
Release Information
2017-08-18 - 52272 - Rel Notes - XPO carton labels