cancel
Showing results for 
Search instead for 
Did you mean: 

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

Cel_Marasigan
Participant
0 Kudos
165

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

 

Cel_Marasigan
Participant
0 Kudos

Dear Experts, Good day. FYI. I tested the interest calculation in our test system without changing any configuration. The computation is correct. Due date is 25th of the month, and the interest calculation from is the next day, 26th of the month.  Thank you very much.

Warm regards,

Cel

Cel_Marasigan_0-1723425913008.png

 

Cel_Marasigan_1-1723425964306.png

Cel_Marasigan_2-1723426060110.png

 

 

Accepted Solutions (0)

Answers (0)