| Description |
*This issue relates to i21 Help Desk ticket:* [ HDTN-266039 - 21.2 TC1 - Inconsistent/different basis component report layout|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-266039]
*Steps* : Generate Basis Component Report
*Issue:*
JDE customer has reported the below issue in TE2 environment while doing their UAT testing.
Layout is still not consistent with what currently is the lay out in the live system. A testing system which is not matching the live system, and fixes which result in again another format.
See below some examples of format inconsistencies
Example column layout - amount of column used differs vs live system.
!pastedImage_d173651_0.jpeg|height=44,width=558!
Example row layout – suddenly blank rows appear now in the download of the excel report
!pastedImage_d173651_1.png|height=263,width=1020!
Example formatting – Net Weight column numbers are stored as text instead of numbers in the download of excel report.
Also all these columns Quantity, Net Weight, Futures, Financing Cost, FOB+, FOB CAD, Other Cost, Sustainability Premium, Basis, Cash Price are stored as text instead of numbers
!pastedImage_d173651_2.png|height=334,width=495!
Example Row width - The row width on screen and in the excel report has increased a lot. We cannot see more lines on screen, it should be as compact as before as how it is showing in Live system. In the excel to see the full data we can expand the column so no need to have more row width
Live Screen:
!pastedImage_d173651_3.png|height=450,width=1003!
Live excel report:
!pastedImage_d173651_4.png|height=366,width=1000!
TE2 Screen:
!pastedImage_d173651_5.png|height=467,width=1000!
TE2 excel report:
!pastedImage_d173651_6.png|height=357,width=1005!
*Acceptance* : Report should be the same as live
|