DPR - Report does not show the Basis Risk and Price Risk

Issue No: RM-4746
Created 6/8/2022 12:00:05 AM
Type Bug-QC
Priority Critical
Status Closed
Resolution Fixed
Fixed Version 20.1
Description *This issue relates to i21 Help Desk ticket:* [ HDTN-272946 - Need a rebuild from 01|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-272946]   STEPS   [http://inet.irelyserver.com/display/RM/DPR+Rebuild+Process+when+Upgrading+to+New+Version]   ISSUE   Soybeans - Report does not show the Basis Risk and Price Risk   ACCEPTED   Report should show the Basis Risk and Price Risk     Details:-   *Purpose: -*   * Functional specification will provide details for the change in the DPR print layout format * Once DPR is run for a commodity, date and further customer selects ‘Print’ on the position detail screen, the print layout format will now display the positions in a different format than before (Transpose the previous print layout format)   *Background: -*   When we ran the DPR for a commodity and selected ‘Print’ on the position detail screen of DPR, the print layout format was displaying the result as below   *DPR*   !pastedImage_d187416_0.png|height=547,width=745!     *DPR print out*     !pastedImage_d187416_1.png|height=536,width=995!     * The ‘Inventory details’ and ‘Contract hedging’ details from the DPR were printed correctly in the above layout but the third section ‘contract details by month’ did not print all the buckets from the DPR report * The Print layout was only displaying limited buckets till ‘Purchase DP’ and left out the above highlighted DPR buckets- ‘Purchase & sales basis’, ‘unpriced position’, ‘Basis & price risk’ which is incorrect therefore the print layout was to be changed to accommodate all the required buckets, as present in the DPR   *Note: - This issue can be seen across customers in 20.1*     *New design: -*   When the customer runs DPR for a commodity and selects ‘Print’ on the position detail screen of DPR, then the ‘contract by month’ section of the print layout will be modified as below: -   !pastedImage_d187416_2.png|height=474,width=745!     * With the new print layout, the DPR buckets will now be shown in the ‘Row’ and the months will be displayed in the ‘Column’ (as shown above) * Inventory Details and Contract Hedging layout will remain As IS * All the three sections above will be displayed in the first page of the print layout * In case the number of rows (DPR buckets) exceeds OR does not fit in the above template then only the third section ‘Contract details by month’ will move to the second page of the print layout. The second page will have the customer logo and the contract detail by month section * The save to excel/PDF functionality for the print layout remains As IS     *Note: -*   * In case the number of column increases > 11 months then these excess month/columns will be moved to the second page of the print layout BUT this enhancement is still in progress and will be taken in the future versions (RM-4771)