LCFS - Investigate Reporting Issue with Broken Link Between Original and Supplemental Reports
- Dominant language
- Python
- Stars
- 6
- Forks
- 6
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 87
Description
**Describe the Bug:**
There is a reporting issue affecting compliance reports CR3885 and possibly also CR3918. The link between the 2024 original compliance report and the corresponding supplemental report appears to be broken. Additionally, reserve amounts are incorrectly displaying in the transactions table, and the organization account is showing a negative balance.
**Expected Behaviour:**
The 2024 original compliance report and the supplemental report should be correctly linked so that data flows accurately between them. Reserve amounts should reflect the correct values in the transactions table, and the organization account balance should reconcile correctly based on all validated transactions and transfers.
**Actual Behaviour:**
The link between the 2024 original report and the supplemental report is broken for CR3885 and possibly for CR3918. Reserve amounts are appearing in the transactions table when they should not be (or are displaying incorrect values), and the organization account is showing a negative balance that does not align with expected compliance unit holdings.
**Implications:**
A broken link between the original and supplemental reports may result in inaccurate compliance summaries, incorrect credit or debit calculations, and unreliable account balances. A negative balance in the organization account could trigger false non-compliance flags and impact the integrity of audit records. This issue needs to be investigated to determine the root cause and assess whether other reports or organizations are affected.
**Steps to Reproduce:**
1. Navigate to compliance report CR3885 in the LCFS Portal.
2. Verify the link between the 2024 original report and the supplemental report.
3. Review the transactions table for unexpected reserve amounts.
4. Check the organization account balance and confirm the negative balance.
5. Repeat the above steps for compliance report to check if it is also affected CR3918.
6. Compare behaviour against a correctly linked original and supplemental report pair to isolate the discrepancy.
**Acceptance Criteria:**
- [ ] Root cause of the broken link between the 2024 original and supplemental reports is identified for CR3885 and CR3918.
- [ ] Reserve amounts in the transactions table are investigated and the source of incorrect values is determined.
- [ ] The negative organization account balance is investigated and the cause is documented.
- [ ] Assessment is completed to determine if other reports or organizations are similarly affected.
- [ ] Findings and recommended fix are documented for team review.
**Additional context:** This investigation should prioritize determining whether the issue is isolated to these two compliance reports or is systemic. Any findings related to data integrity in the transactions table or account balance calculations should be flagged for further remediation.
Contributor guide
Assessment
This issue has not been assessed yet.