web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Calculate and generate interest note after payment

(0) ShareShare
ReportReport
Posted on by

Hiyall

How can I include invoices that are paid, but paid to late when calculating interest?

The way it's working now, interest of an invoice is removed when recalcing a customer after the origin invoice is paid, while it would make sense to have this "stuck" on the customer until posted / waived.

In the same way, for many instances it would also make sense to calculate interest not before the invoice is paid. Like for instance, a huge invoice paid 10 days to late could have a potential of big earnings, but this is not picked up at all if interest calculation wasn't done in between due date and payment date.

I am using 2012 rtm

Hope for some good advises!

Cheers

*This post is locked for comments

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello WiserGuy,

    Have you tried running the periodic interest calculation job in AR with the parameter for payments activated?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    on at

    Hi Ludwig

    Thanks for replying.

    Yes, I have tried that - but it did not help with my issue, though. Which makes sense to me if I understand the system correctly;  checking payments will deduct payments from the calculated due invoice.

    What I want is to calculate invoices based on payment date minus due date for settled invoices. Any other ideas, as this is a pretty common out of the box feature in most other ERP systems I have worked with.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi WiserGuy,

    What parameter selection did you make in the AR parameters for the interest calculation parameter?

    Is it set to "open and closed" or to something else?

    If it is not set to "open and closed" can you test modifying this parameter setup and check if this resolves your issue?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    on at

    Hi again Ludwig,

    I forgot all about the AR parameters > Collections. Changing from "Open" to "Open and closed" did the trick.

    Thank you so much!

    Cheers,

    WG

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans