DFSP Settlement Statement Report issue (transaction not being included in report)

[zinzinnyohlaing-tw]

issue detail is in the comment

PR:[https://github.com/mojaloop/reporting-bc/pull/37]
update include in:
mojaloop/reporting-bc-participants-reporting-svc version: 0.3.16

[pthandar]

Let me raise an issue that can't see the settlement transaction in the report. Ko @SithuKyaw-Thitsaworks

I have settled the matrix ID : 5c69e94b-3120-45f3-adc0-a49207c897af
Amount : 12 MXN
From Fsp : demowalletTest
To Fsp : demomfiTest
However, this transaction was not included in the report. That's why the balance shown in the report is not the same as the balance of FSPs's balance. Please check the below SS for your reference.

Report's Balance

FSP's balance

I also don't see the log for that transaction in the participant's fund movement.

Log from Lens

FYI @myo-min-htet @TW-Ei-Nghon-Phoo @zinzinnyohlaing-tw @YminOo @PhyuSinMyat8

[pthandar]

As per Specification , Account Number is "DFSP Liquidity account number opened in the settlement bank".

But in the report , the Account number is wrongly showing as 6b45e38d-f92f-487e-976b-5fd04023dd57

The DFSP Liquidity account number opened in the settlement bank is 123

Ko @kyaw-soe-tw Could you please check for it?

FYI : @myo-min-htet @SithuKyaw-Thitsaworks @TW-Ei-Nghon-Phoo @zinzinnyohlaing-tw @YminOo @PhyuSinMyat8

[JulieG19]

As discussed in sprint review, we are closing this ticket. If a ticket is ready to be picked by QA it will be moved to the appropriate column.

[pthandar]

I have made one deposit fund transaction and one withdrawal transaction.
But the report displays only deposit transaction and doesn't see withdrawal transaction.
Please check the below SS.
Fund movement page

Report

Could you please check ko @SithuKyaw-Thitsaworks ?

FYI @TW-Ei-Nghon-Phoo @zinzinnyohlaing-tw @PhyuSinMyat8

[PhyuSinMyat8]

Testing Result

QA passed

Note: All of the criteria passed for DFSP Settlement Statement Report but I found another issue in settlement account balance. Although the settlement balance amount should be equal to the balance amount from report, they were different in some dfsp and the settlement balance amount from participant page was a little higher than the actual amount. The balance amount from report was correct.

Summary

• The report displays all of the following transaction types within the selected date range.

• • "OPERATOR_FUNDS_DEPOSIT",
• • "OPERATOR_FUNDS_WITHDRAWAL",
• • "MATRIX_SETTLED_AUTOMATIC_ADJUSTMENT_CREDIT",
• • "MATRIX_SETTLED_AUTOMATIC_ADJUSTMENT_DEBIT",
• • "OPERATOR_LIQUIDITY_ADJUSTMENT_CREDIT",
• • "OPERATOR_LIQUIDITY_ADJUSTMENT_DEBIT"

• The report displays the updated balance after each transaction.

• In the account number column, the system shows the correct data. ["DFSP Liquidity account number opened in the settlement bank".]

• The generated report should adhere to the format specified in the provided Excel file.

Specification

• Updated date of tested version: 11-July-24
• Portal version: v 0.5.38 - dev

Please refer to the screenshots below for more information.

Initial amount - 0 SGD

After a 100,000 SGD deposit to that account

After a 10 SGD withdrawal to that account

After 10 SGD were transferred and settled,

After liquidity adjustment, 30 debit

"MATRIX_SETTLED_AUTOMATIC_ADJUSTMENT_CREDIT" and "OPERATOR_LIQUIDITY_ADJUSTMENT_CREDIT"