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

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Interest Calculation/I...
Microsoft Dynamics AX (Archived)

Interest Calculation/Interest Note

(0) ShareShare
ReportReport
Posted on by Community Member

Hi Everyone,

How does native AX calculate interest? How does the posted interest note looks like?

We were able to calculate interest and post the interest note, but when checking the customer account interest note created several lines with the same invoice number.

.1 Customer transaction screen

Interest-_2D00_-CUST-TXN-SCRN.png

.2 Interest Note showing interest on invoices that were calculated

Interest-Note.png

Can AX post 1 line of interest equal to the sum of the interest calculated?

Thanks everyone,

Jesa

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Jesa,

    Can you provide some more information on your interest calculation setup?

    How are the AR parameters setup?

    How did you setup your interest rate calculation?

    What account do you use for posting the interest and is this account posted in combination with financial dimensions that differ for example by customer open position (sales order), customer, etc.?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi Ludwig,

    Below are screen shots of set up/test we did

    .1 AR parameters

    interest-calculation.png

    .2 Interest code

    interest-code-set-up.png

    .3 Posting Profile

    Posting-Profile-_2D00_-interest-code.png

    .4 Interest Calculation

    interest-calculation.png

    .5 Main Account

    main-account-set-up.png

    Thanks,

    Jesa

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Jesa,

    Please try to test the following in a demo/test System, which should summarize the interest transactions

    (a) When you start the interest calculation select 'account' in the 'use posting Profile from' drop down field

    (b) When you post the interest calculated make sure that the Parameter 'interest per transaction' is not checked.

    This should summarize the interest into one single voucher.

    Would be great if you could test and let us know if this fixed your issue.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi Ludwig,

    Thanks, I was able to post 1 line of interest.

    One more question, how about free text invoice? How do AX calculate free text invoices? Did a test on customer with free text invoice, interest was not calculated

    Thanks,

    Jesa

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Jesa,

    Can you provide some more info on the free text issue?

    I actually tested and processed the interest calculations for free text invoices.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi Ludwig,

    Just confirmed that we will not calculate interest on free text invoices.

    The other question is, if I pay an invoice with interest, how is the process? Will AX verify that the invoice selected has interest calculated?

    Thanks,

    Jesa

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Jesa,

    the interest is recorded as a separate open position and if you are lucky enough that your customer pays that amount you can mark the invoice amount that he pays and the open interest amount.

    Is that clear?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi Ludwig,

    Thank you. I thought AX has the ability to indicate that if an invoice has interest calculated, we can process payment for the invoice plus the interest.

    Maybe a customization will help?

    Thanks again,

    Jesa

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Jesa,

    I would be careful with a customization in this area as it can easily get quite complex. If you have many customers that really pay the interest you record for them an adjustment might make sense. Yet, please carefully calculate the cost of making this adjustment with the benefit that it brings.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi Ludwig,

    Thanks for all the help.

    But do you happen to know why this error pop out?

    criteria.png


    Interest calculation

    criteria.png

    Thanks again,

    Jesa

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

News and Announcements

Season of Giving Solutions is Here!

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
user5555 Profile Picture

user5555 2

#1
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#1
Nakul Profile Picture

Nakul 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans