Line item interest calculation and Residual payment report

[former_member514441]

Hi All,

I have two requirements.

1. My client get loan from bank, for the loan they get they pay interest on monthly basis. Here the Bank is considered as Vendor. They want calculate interest on line item basis, and I have configured as per their requirement.They payment interest amount to abnk after some 10 to 15 days after the interest is calculated. when I run they vendor line item interest in FINTAP. For the first month it is calculating fine but when I run it second month it is calculating interest on interest.

Eg: Loan received - 100000

1st month int calculation is 1000 (only on principle amount)

2nd month interest calculation is 1000 + 10 (interest on interest it is calculating.

I changed the configuration grace period as 90 days but still I face same issue. kindly help me with the solution

2. Client wants to see the amount only paid the vendor or received from customer, I have suggested them for Residual payment but system behaves strange.

Eg : Invoice amount is 2,00,000

we paid 50,000 in residual method. When I checked in FBL1N, the report is as follows.

Open item = 1,50,000

Total open item = 1,50,000

Cleared item = 2,00,000 (it creates 2 new line item) with in this item only I could see the paid amount.

Kindly help me resolve the issues.

[Mohamed_Cassim]

In SAP S4HANA Cloud: Exclude Interest Documents from Interest Calculation

Exclude Interest Documents from Interest Calculation You want to exclude open items generated by the interest run from future interest calculations.

Procedure

1. You schedule an interest run in the Schedule Interest Calculation Jobs app.

2. Make an entry in the Interest Lock Field. Result Items that are created in this interest run are excluded from further interest calculation.