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 :
Finance | Project Operations, Human Resources, ...
Answered

Credit management and ranking of payment terms

(0) ShareShare
ReportReport
Posted on by 219

It seems i cannot setup the anking payment terms

You can put a sales order on hold if the payment terms on the order don't match the default payment terms for the customer. However, sometimes the payment terms differ but are similar enough that you don't want to put the order on hold. You can rank payment terms so that some of them have the same rank, whereas others have a higher or lower rank.

If the rankings for payment terms are active, and if the payment terms on the order have a higher rank than the default payment terms for the customer, the sales order will be put on hold.

To set up the payment terms ranking go to Credit and collections > Setup > Credit management setup >Rank payment terms

When trying to do so in the picture below the only button that is available is the edit button

pastedimage1587541840978v1.png

When trying to edit I get this error message

pastedimage1587541946222v2.png

When adding a kind of reference table I get his error

pastedimage1587542103784v3.png

Is this perhaps a bug or where to start to look for solving this?
Could it be some kind of setup I am missing?

Thank you in advance for your help here. 

 


I have the same question (0)
  • Suggested answer
    Christoph Thaler Profile Picture
    5,442 on at

    Hi Eva.

    This is a known bug. You have to setup the table with the related entity. This will work...

  • Suggested answer
    Christoph Thaler Profile Picture
    5,442 on at

    Sorry, forgot to mention the entity name. It`s "Ranking of payment terms".

  • Krakan99 Profile Picture
    219 on at

    Thank you Christoph. Do you have any more information about how to setup this table? I am not that deep into the technical parts so will see if I can fix this myself or if I need more assistant from the technical staff.

  • Suggested answer
    Christoph Thaler Profile Picture
    5,442 on at

    Hi Eva.

    The easiest way is to use the "Edit in Excel" feature within the form.

    pastedimage1587620019154v2.png

    So you can download the Excel file and open it. In the file you can modify the "Rank"

    pastedimage1587620421314v5.png

    as soon as you are finished use the "Publish" button on the right side and you are done.

    pastedimage1587620457142v6.png

  • Verified answer
    Florentina Sonu Profile Picture
    Microsoft Employee on at

    Hello Eva,

    One work item for this issue is already in progress to development team, but there is one quick workaround that solves the issue.

    Below you may find the steps to apply it and to modify the Rank values:

    Credit and collections > Setup > Rank payment terms

    • Click on Open in Excel Ranking of payment terms

     

    • Download the file0574.Pic-1.png

     6747.Pic-2.png

    • Make the changes in excel file and Publish
    • Pic-3.png
    • Refresh the data in the form > the values are modified

     Pic-4.png

    This should resolve the error message.

    Wish you a nice day!

    Best regards,

    Florentina

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 660

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 655 Super User 2026 Season 1

#3
CP04-islander Profile Picture

CP04-islander 557

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans