| Description |
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-208557 - Position Report (Hammarized)|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-208557]
In prior Position Report design change tickets, there were requests to change the Position Report to accomodate reporting requirements specific to Zeeland's Soybeen crush functions. There was an Excel spreadsheet mockup that was provided that was supposed to replace the *Contract Details By Month* section. Instead, someone replaced the entire report.
!pastedImage_d107024_0.png|height=612,width=935!
*{color:#ff0000}Here's what we need to do to fix this problem:{color}*
1) *Position By* should only be visible / enabled for the new Daily Position Report
!pastedImage_d107024_1.png!
2) Eliminate the Pre-Crush report that appears when the Crush Position checkbox is checked
!pastedImage_d107024_2.png|height=419,width=956!
3) Add *Daily Position Report* option to the Risk Management Reports menu
!pastedImage_d107024_3.png!
4) Use the standard Position Report as a starting point for the new DailyPosition report format.
{color:#ff0000} *Important: Use the existing Position Report code and simply add rows and other differences when the report is generated from the Daily Position menu link. The goal is to +not+ have two sets of Position Report code. In other words, if a change is made to the top of the standard report format or rows that are shared between the two report formats then +both+ report formats should show the change.* {color}
{color:#000000}5) Do not change the Inventory Details or Contract/Hedging Details.{color}
{color:#000000}6) +Carefully+ review the + *attached* +mockup and have the Position Report present the data in this format +when it's generated from the new menu link+.{color}
{color:#000000}Please note that the totals are in the 1st column followed by Near By and subsequent delivery period months.{color}
{color:#000000}Include the Pre-Crush row that was on the report mentioned in step 3. Change the label to *Crush.* {color}
{color:#ff0000} *Let me know if you need clarification on any calculations or other regarding this section.* {color}
{color:#000000}Also review the comments within the Excel file.{color}
{color:#000000} !pastedImage_d107024_4.png! {color}
{color:#ff0000} *Note: the Crush row should appear only if the Crush Position checkbox is checked in the Company Configuration.* {color}
{color:#ff0000} *Skip the Delta Adjusted Options for now. We need a formula from Kevin.* {color}
7) The drill downs need to be fixed. Problems include:
* Drilldown window opens behind the Position Detail window. The detail window has to be closed before the drilldown can be viewed.
* It would be helpful if some of the drilldowns displayed additional information. Example: Net Hedge
** Display Trade ID with drilldown capability
** Do the same for other drilldown windows that are not associated with contracts
* See RM-2115 for a discussion about this.
!pastedImage_d107024_5.png|height=335,width=858!
|