Project

General

Profile

Actions
Copy link

Bug #1515

open

Interest calculation formula needs to be changed.

Added by Krishna Kanth A 5 months ago. Updated 2 months ago.

Status:
In Progress
Priority:
Normal
Assignee:
Bhanuchander Sannidhanam
Start date:
27/11/2024
Due date:
% Done:

0%

Estimated time:
Deployed In:
Category:

Description

Interest calculation to be made as below.

1) A Table (Name: BankIntRates) needs to be created with 2 columns, FYear int and AvgAnnIntRate float.

2) When Calculate Interest rate is clicked on Manage IPC page, find the No. of days for each Year starting from "Over Due Days" until payment Date.

3) Interest rates are to be taken from BankIntRates Table for the Respective Year.

Kindly refer to the attached Excel file for Interest Calculations.

Kindly refer to the 2 attached image files for the columns that are to be Replaced in the Manage IPC Screen in CMS Application.

Files

Download all files
IntrestRatesCalclutation_New.xlsx (67.5 KB) IntrestRatesCalclutation_New.xlsx Krishna Kanth A, 16/01/2025 01:23 PM
NRFA_Int_Rates_2.jpg (276 KB) NRFA_Int_Rates_2.jpg Krishna Kanth A, 16/01/2025 01:23 PM
NRFA_Int_rates1.jpg (183 KB) NRFA_Int_rates1.jpg Krishna Kanth A, 16/01/2025 01:23 PM
Actions
Copy link
 #1

Updated by Krishna Kanth A 5 months ago

  • Project changed from Service Desk to NRFA
  • Subject changed from 1516 to Interest calculation formula needs to be changed.
  • Assignee set to Durga Konduru

Interest calculation formula needs to be changed.
Response: Interest will be calculated as per the attached template and given along with monthly build.

Actions
Copy link
 #2

Updated by Krishna Kanth A 5 months ago

  • Description updated (diff)
Actions
Copy link
 #3

Updated by Krishna Kanth A 5 months ago

  • Description updated (diff)
Actions
Copy link
 #4

Updated by Krishna Kanth A 5 months ago

  • Description updated (diff)
Actions
Copy link
 #5

Updated by Krishna Kanth A 5 months ago

  • File Interest Calculation Template.xlsx added
Actions
Copy link
 #6

Updated by Krishna Kanth A 3 months ago

  • File Interest Calculation Template.xlsx added
  • File RDA-CMS Training and comments 21-11-24.docx added
  • Description updated (diff)
Actions
Copy link
 #7

Updated by Krishna Kanth A 3 months ago

  • File deleted (Interest Calculation Template.xlsx)
Actions
Copy link
 #8

Updated by Krishna Kanth A 3 months ago

  • File deleted (RDA-CMS Training and comments 21-11-24.docx)
Actions
Copy link
 #9

Updated by Durga Konduru 3 months ago

  • Assignee changed from Durga Konduru to Bhanuchander Sannidhanam
Actions
Copy link Download all files
 #10

Updated by Krishna Kanth A 3 months ago

Actions
Copy link
 #11

Updated by Krishna Kanth A 3 months ago

  • File deleted (Interest Calculation Template.xlsx)
Actions
Copy link
 #12

Updated by Durga Konduru 3 months ago

  • Assignee changed from Durga Konduru to Bhanuchander Sannidhanam
Actions
Copy link
 #13

Updated by Kalyan Battula 2 months ago

  • Status changed from New to In Progress

Interest calculation is done for all the IPC’s for the contract and added total interest against single IPC.
Interest calculation for partial payment IPC ‘s is not displaying in Interest calculation link screen.

Actions
Copy link

Also available in: Atom PDF