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

Notifications

Announcements

No record found.

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

I have the same question (0)
  • 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans