LCFS- ETL discrepancy investigation

[Grulin]

TFRS balances are incorrect.

There seems to be two issues here:

1. The in-reserve amount is correct, but it appears that a transfer from org was never deducted from their TFRS account. The transaction number is credit transfer 1497. They were supposed to transfer 10,158 credits to another organization, but this amount was not subtracted from the sending organization's account upon director recording. If the transfer was subtracted from this organization's balance, they should have only 702 credits in their balance. This is their only transfer out, so it is certainly an issue with this transfer out.

It appears, however, that the receiving organization did receive the credits from this transfer.

2. It appears that the calculation in the LCFS portal has counted the organization's current balance of 10,837 and added the transfer of 10,158 twice (10,837+10,158+10,158= 31,153). Not sure about what is causing this bug in the Portal ETL, but it might be related to an identified bug in the Portal already that is being worked on.

The TFRS error will still need to be addressed.

TFRS balance: 10,837 (0)
LCFS Portal balance: 31,153 (0)