cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

How to Calculate Interest on "Overdue" Receivables based on Net Due Date

Cel_Marasigan
Participant
0 Likes
468

Dear Experts,

Good day. I wish to calculate interest on AR debit open items based on net due date. Currently I have configured Prepare Item Interest Calculation based on Baseline Date. However, from a layman's viewpoint (not sure if just applies in our country), interest is computed when a receivable is "overdue", therefore the reference date should be the net due date. However I can't find the net due date from the list of reference due dates in the configuration, as per the 1st screenshot below. Is there any way in the configuration to meet my goal?

Cel_Marasigan_0-1723138955889.png

Here are my sample receivables for interest calculation:

Cel_Marasigan_1-1723139103761.png

Here is the sample computation:

Cel_Marasigan_0-1723139653169.pngThank you very much.

Warm regards,

Cel

 

Accepted Solutions (0)

Answers (0)