HDTN-336012 - JM Davis - In AR-Invoice>Invoice Detail Report Invoices are showing multiple times

Issue No: AR-20673
Created 3/19/2024 8:51:21 PM
Type Bug
Priority Critical
Status Closed
Resolution Fixed
Fixed Version 22.1, 22.1.Maint-042624
Description *This issue relates to i21 Help Desk ticket:* [HDTN-342234 - Please apply patch in TR-3486 & AP-14503 to TE, WIP22.1 and WIPCES|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-342234]\\*This issue relates to i21 Help Desk ticket:* [HDTN-340280 - 22.1 Blocker - WIPCES Invoice Detail Report is showing incorrect Cost per UOM\|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-340280]\\ *This issue relates to i21 Help Desk ticket:* [ HDTN-336012 - JM Davis - Go Live Testing - In AR-Invoice>Invoice Detail Report Invoices are doubling |https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-336012]   --   *Issue:* Invoice Detail Report is showing multiple lines.   *Steps:*   1. Create IR with 2 qty.   2. Create Invoice, make sure to use the item used in created IR then shipped qty should be greater than the IR qty   3. Post Invoice.   4. Check Invoice Report Detail.   !pastedImage_3_26_2024__18_17_22_630.png|height=334,width=688!   !pastedImage_3_26_2024__18_18_59_325.png|height=301,width=684!   *Acceptance:*   Add Configuration: 'Use Cost per UOM in Invoice detail report:   !pastedImage_4_3_2024__22_02_14_813.png|height=402,width=535!   * If Enabled: Show multiple lines with right quantities based on Inventory Valuations. [See above photos for reference]. * If Disabled: Should work as it is showing as one line in Invoice Detail Report. ** Note: In scenarios that there are multiple Unit Cost used per item, no duplicate lines must be shown in the Invoice Detail Report. Use below figures for reference to get the correct Cost per UOM in Invoice Detail Report ** |Invoice Shipped Qty|Qty per Unit|Cost Per Unit| | |1000|500|2|1000| | |300|3|900| | |200|2|800| | | |COGS|2700| | | |Cost per UOM|2.7|