Support #11651

[SCP ID :##5824##] : EOD Fix bulk payment amount calculation

Added by Zahir Abd Latif over 3 years ago. Updated about 3 years ago.

Status:Work Completed-End life cycleStart date:May 04, 2021
Priority:NormalDue date:May 04, 2021
Assignee:Zahir Abd Latif% Done:

100%

Category:-Spent time:-
Target version:-

Description

Hi,
Kindly attend below request:-

Issue happened when eod calculate amount and balance for incomplete data in DB (time out during bulk payment file upload)

SCP ID 5824.docx (645 KB) Nurul Athira Abdul Rahim, April 26, 2021 18:18

History

#1 Updated by Nurul Athira Abdul Rahim over 3 years ago

  • Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin

#2 Updated by Najmi Pasarudin over 3 years ago

  • Due date set to April 16, 2021

#3 Updated by Najmi Pasarudin over 3 years ago

  • Status changed from New - Begin Life Cycle to Development / Work In Progress

#4 Updated by Najmi Pasarudin over 3 years ago

  • % Done changed from 0 to 90

#5 Updated by Najmi Pasarudin over 3 years ago

  • Status changed from Development / Work In Progress to Pending SIT Deployment

#6 Updated by Najmi Pasarudin over 3 years ago

  • Status changed from Pending SIT Deployment to Finished Development

SIT deployed on 16/04/2021

#7 Updated by Najmi Pasarudin over 3 years ago

  • Status changed from Finished Development to Internal Testing
  • Assignee changed from Najmi Pasarudin to Nurul Athira Abdul Rahim

Issue:
Eod reject a bulk payment file because of insufficient balance but log shows balance is sufficient.

Finding:
If the company retry failed file upload multiple times, the details are accumulated in database.
In EOD amount calculation, the amount includes the failed file details and the total amount is more than the available balance.
However, during payment, EOD program already filters the failed file details. So no issue of extra payment.

Solution:
Fix EOD amount calculation to calculate only the valid bulk payment details.

Test steps:
  1. Access eBiz>Bulk Payment>Data Entry
  2. Submit a Bulk Payment
  3. At IBAM, run EOD
  4. Expected result, correct Bulk Payment total amount is shown in EOD summary and report

#8 Updated by Nurul Athira Abdul Rahim over 3 years ago

  • File SCP ID 5824.docx added
  • Status changed from Internal Testing to System Integration Test

Tested and passed on 23/4/21

#9 Updated by Nurul Athira Abdul Rahim over 3 years ago

  • Due date changed from April 16, 2021 to May 04, 2021
  • Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin
  • Start date changed from April 13, 2021 to May 04, 2021

Tested and passed by azyan.
Please prepare for UAT deployment

#10 Updated by Nurul Athira Abdul Rahim over 3 years ago

  • Status changed from System Integration Test to Pending UAT Deployment

#11 Updated by Najmi Pasarudin over 3 years ago

  • Status changed from Pending UAT Deployment to Code Review

#12 Updated by Najmi Pasarudin over 3 years ago

  • Status changed from Code Review to Development / Work In Progress

#13 Updated by Najmi Pasarudin over 3 years ago

  • Status changed from Development / Work In Progress to User Acceptance Test
  • Assignee changed from Najmi Pasarudin to Nurul Athira Abdul Rahim

UAT deployed on 04/05/2021

#14 Updated by Nurul Athira Abdul Rahim over 3 years ago

  • Status changed from User Acceptance Test to Pending Prod Deployment
  • Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin

Tested and passed on UAT env.

Kindly prepare for preprod deployment.

Thank you

#15 Updated by Najmi Pasarudin over 3 years ago

  • Status changed from Pending Prod Deployment to Pending Review
  • Assignee changed from Najmi Pasarudin to Nurul Athira Abdul Rahim
  • % Done changed from 90 to 100

Production deployed on 07/05/2021

#16 Updated by Nurul Athira Abdul Rahim about 3 years ago

  • Status changed from Pending Review to Work Completed-End life cycle
  • Assignee changed from Nurul Athira Abdul Rahim to Zahir Abd Latif

Migration ID0033

Also available in: Atom PDF