interest calculation excluding debit notes on contract accounts on transaction FPINTM1

[isaac_ndaona]

The business users have requested that interest be calculated for all amounts that are overdue including for the amounts posted through debit notes (document type AB, etc..) The standard functionality does not include these documents and we do not want to create a custom program for this requirement but enhance the standard functionality. Can anyone suggest a solution?

[isaac_ndaona]

There is no difference between FPI1 and FPINTM1 on the amounts that are selected for interest calculation.The exclusion of the manually posted amount is maintained in the standard interest calculation program where all documents with origin 01 are excluded. There is no interest lock on the contract account because the other amounts posted as invoices or prior interest due are included as base amounts for the interest calculation.

See below

[william_eastman]

There is no standard exclusion for 01 items. Something else is happening here.

[william_eastman]

Try with FPI1 and see what message is output. Sounds like there is an interest lock involved

[SaschaWenzel]

Hi Isaac.

You can select field DEBCRED on the screen of the tab "Interest Parameters". This has the effect that interest is calculated on both debit and credit items. If the indicator is not set, interest is only calculated on the debit items.

Regards,

Sascha

[isaac_ndaona]

Thanks Sascha,

Unfortunately this does not address the issue of the documents excluded from interest calculation as it is neither a debit nor credit balance parameter issue.

All manually posted debit notes (via FPE1) amounts which are overdue with origin 01 are excluded from the standard interest program (FPINTM1). The selection of the parameter DEBCRED in the tab ''Interest Parameters'' does not resolve the issue as this is only to select the debit and credit balances. The debit balances from invoices or internally posted interest amount that are due are included in the interest calculation as required.

The issue is how to include the documents posted through manual entry on the contract account interest calculation as attempts to have this done through enhancement is giving system errors.