Contract Balance - Contract Balance is incorrect when sequence is sliced

Issue No: CT-3462
Created 7/18/2019 10:26:12 PM
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-233400 - MTM - Sales Basis Contracts Wrong|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-233400]   *Issue:*     MTM-13 was created on 7/15 with a Transaction Up to date of 6/30. The Sales Basis Contracts were 7770. That matched the DPR. Created MTM017 7/18 and the 6/30 DPR and MTM show 7743.     The variance is from contract 10489-1. It was 270 balance and now it is 243. This change was done on 7/16. Why is that impacting the MTM and DPR as of 6/30   I see the issue. It was a single sequence to start for 270. It was sliced in July, and priced. Seq 1 was then 243, and priced. The DPR and MTM recognize that it was Basis as of 6/30 (good) but thinks the starting balance is 243 for seq 1 instead of 270. And it skips sequence 2 because it was created in July. I thought we handled this situation correctly in the past. Slicing contracts is common.     *Steps:*   # Sale Basis Contract was created on 01.20.2020 with 1 sequence   # Sequence was sliced on 01.22.2020   ## Filtering by 01.20.2020, sequence is still unsliced   ## Filtering by 01.22.2020, sequence is already sliced   # One sequence was partially paid on 01.26.2020   ## Filtering by 01.20.2020, sequence is still unsliced   ## Filtering by 06.20.2019, sequence is already sliced   ## Filtering by 07.24.2019, 1 sequence is shown as partially priced     Acceptance: Contract Balance should show correct qty when a sequence is sliced.