Interest is not getting calculated correctly for manually cleared documents using FP06

[Former Member]

Hi Experts,

We are facing the problem while calculating the interest amount for some of the Business partner.

Interest is not getting calculated correctly for three items only which is cleared due to manual account maintenance FP06.

-On account payment was available for this BP and we have cleared open item from that on account.

--Invoice due date for these two document was 30.05.2015
--On account payment was available from 15.05.2015.
--We have created AM documents on 12.06.2015
--Now run the interest calc program. Where interest is getting calculated and from 30.05.2015 to 05.06.2015. Which should not.

Now from where this 05.06.2015 is coming to interest calc program. It should pick from clearing value date. For these documents clearing value date is black.
I have seen into table level DFKKOP, there are no clearing value.

Can you please help me here to find out the source of this date 05.06.2015? And how to correct this?

Regards,

Narpal Singh

[Private_Member_7726 · Accepted solution]

Hi,

Did you search OSS and SCN..?

I'm by no means a specialist in this area, but this may be relevant: FI-CA: Interest „To-Date“ determination during the interest calculation:

For already cleared receivables the interest functionality uses the clearing value date (field DFKKOP-AUGVD) as the interest “To-Date”. But the clearing value date is not filled during the clearing with the account maintenance functionality (transaction FP06 or FPMA) because with the account maintenance it is possible to clear more than one receivable with more than one credit. Therefore, the interest functionality has to find the best interest “To-Date”

cheers

Jānis

[Former Member]

Thanks for your reply Janis,

First part is clear there may be no clearing date due to multipal documents linked.

But because of this interest amount is not matching as per the client expectation.  Now we need to correct this. SAP has cleared on the highest amount clearing date.  Is there any way to correct this?

This interest amount is already been invoiced, so I feel this is difficult to reverse this.

Regards,

Narpal Singh

[Private_Member_7726]

Hi,

It would depend on what's possible in the "Invoice correction" processes in your system. To me it seems more important, if you can figure out and implement a better "To Date" derivation algorithm in the FQEVENT exit for Interest calculation, in order to prevent the problem from occuring again.

I'd try to cancel (IS-U) Invoice, cancel Interest item(s) in FI-CA, recalculate interest correctly and invoice again. A setup to post manual credit/debit items in FI-CA and invoice them in IS-U based on "dummy" manual billing document or using IS-U manual billing document outright could also be a possibility, but would indeed be complex, if you already don't have it all set up in the system.

cheers

Janis