Support #13228

[SCP ID :##6432##] : Different of Consolidate Memberstatement & Memberstatement Window 10-12 Report

Added by Zahir Abd Latif about 2 years ago. Updated almost 2 years ago.

Status:Closed - End of life cycleStart date:September 16, 2022
Priority:HighDue date:
Assignee:Zahir Abd Latif% Done:

100%

Category:-Spent time:-
Target version:-

Description

Hi,
Kindly attend below request:-

There are the difference between of Consolidate Memberstatement & Memberstatement Window 10-12 Report. The different is in the credit total and the total of transaction.

*This issue happen to Maybank.

WO0000000316943 (1).zip (883 KB) Zahir Abd Latif, September 16, 2022 15:12

History

#1 Updated by Bramantyo Pujo Wiyono about 2 years ago

  • Status changed from New - Begin Life Cycle to Investigation

#2 Updated by Bramantyo Pujo Wiyono about 2 years ago

  • % Done changed from 0 to 10

Asked them to regenerate the report

Already Requesting back to check by this query:

--Query to get DEBIT total amount and volume transaction
select OFI_CODE, SUM AS AMT_DBT, COUNT FROM rpp_trnx_log_data where
OFI_CODE = 'IBBKIDJA' AND
COMPLETED_DATE >= TO_DATE('08092022 170000', 'DDMMYYYY HH24MISS') AND
COMPLETED_DATE < TO_DATE('08092022 180000', 'DDMMYYYY HH24MISS') AND
(TRNX_STATUS='ACTC' OR TRNX_STATUS='ACSP') AND SERVICE in ('010','011','019','110')
GROUP BY OFI_CODE;

--Query to get CREDIT total amount and volume transaction
select RFI_CODE, SUM AS AMT_DBT, COUNT FROM rpp_trnx_log_data where
RFI_CODE = 'IBBKIDJA' AND
COMPLETED_DATE >= TO_DATE('08092022 170000', 'DDMMYYYY HH24MISS') AND
COMPLETED_DATE < TO_DATE('08092022 180000', 'DDMMYYYY HH24MISS') AND
(TRNX_STATUS='ACTC' OR TRNX_STATUS='ACSP') AND SERVICE in ('010','011','019','110')
GROUP BY RFI_CODE;

--NOTE: Please change COMPLETED_DATE FILTER VALUE BASED ON WINDOW TIME FRAME WINDOW 10, 11 AND 12

waiting for response...

#3 Updated by Zahir Abd Latif almost 2 years ago

  • Status changed from Investigation to Development / Work In Progress
  • Assignee changed from Bramantyo Pujo Wiyono to Zahir Abd Latif
  • % Done changed from 10 to 100

Wahyu Dwianto, Oct 5, 2022:-

For following ticket, you can close it due no issue from application.

The difference between those reports due : there is in-house transaction for those participant.

Issue closed in SCP.

#4 Updated by Zahir Abd Latif almost 2 years ago

  • Status changed from Development / Work In Progress to Closed - End of life cycle

Also available in: Atom PDF