PPV Summary in Sourcing Report for Fats & Oils – showing Empty standard prices/standard values

Issue No: RM-3124
Created 7/11/2019 7:58:08 AM
Type Bug
Priority Blocker
Status Closed
Resolution Fixed
Fixed Version 19.1
Description This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.   [HDTN-232861 - Sourcing Report for Oils - Empty standard prices/standard values|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-232861] Steps:   In the Sourcing Report enter the details in the header and click on PPV Summary button   !pastedImage_d121510_0.png|height=202,width=996!     Issue:   In the Sourcing Report Detail it is not displaying the Standard Price and Standard Value for Fats & Oils. This issue is happening since Hershey’s has gone live with 19.1   !pastedImage_d121510_1.png|height=452,width=950!     This is due to the bug that is introduced while making the change to consider the storage location if the storage location is specified in the contract sequence.   As per the analysis done, we figured out that it is not working when the AOP is not configured for a specific storage location when the contract sequence has the storage location. We should have taken the AOP value configured for the item + location + book combination with the storage location as empty when there is no value configured for the item + location + book + storage location combination. Since item + location + book + storage location level AOP setup is an optional one and it is only used for some commodities it causes issues for Fats & Oils commodity items. Due to this they are not able to generate the PPV summary report for Fats & Oils. This has blocked them from generating the monthly report for Fats & Oils.   For e.g. Fats & Oils, AOP is configured with the standard price as 1.353 for 1-16589-000 + 130-US + 2019 combination with the storage location as empty. This indicates that this price is applicable for the storage locations. Our PPV report shows the Standard Price/Standard Value as empty for contract # 288-1 because we are not considering the 1-16589-000 + 130-US + 2019 combination with the storage location as empty when there is no AOP configured with that storage location.   !pastedImage_d121510_2.png|height=327,width=586!   !pastedImage_d121510_3.png|height=145,width=579!   !pastedImage_d121510_4.png|height=269,width=586!     Acceptance:   It should work when the AOP is not configured for a specific storage location when the contract sequence has the storage location. We should take the AOP value configured for the item + location + book combination with the storage location as empty when there is no value configured for the item + location + book + storage location combination.   Since item + location + book + storage location level AOP setup is an optional one and it is only used for some commodities.