Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

How to set up Term of payment at last Thursday?

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Can Ax set up term of payment at last Thursday of next month?

Ex. Invoice date on Feb 15. and payment should be 'March 31'

I try to set up as

payment method = Curr.Month.

Days = 25

payment day = Weekday = Friday

 but it has problem that on November is not 30th. payment day is going to December.

If I setup days = 24, payment date should be Thursday Mar, 24. it is not going to Thursday Mar, 31.

Can I set 1 condition for last Thursday or another weekday of next month?

Please advise

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to set up Term of payment at last Thursday?

    Thank you now I advise user to set up 2 terms of payment and select by themselves because they do not want to customize program.

    I tested many case but I asking for something I missing.if anyone have another way better.

    But if standard cannot make it, I can confirm to myself and user.

    Thank you for your help.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: How to set up Term of payment at last Thursday?

    Hi Poonzz10, I tested many scenarios and believe that you won't be able to always get the correct due date calculated. Either you ask the user to double check and manually modify the due date once Standard AX calculates is wrong - as e.g. for October 2016 - or you grap a developer and implement a system adjustment. Best regards, Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to set up Term of payment at last Thursday?

    Hi

    Thank you for you advise but it seem like due date will be end of every month not last thursday of each month.

    Let me explain more detail. I try to setup like this.

    Payment days

    Month - 25

    Week - Thursday

    2313.4.jpg

    And Term of payment.

    Payment method = Current month

    Month/days = 0

    6523.2.jpg

    Then the result is

    4064.3.jpg

    Every month due date will be last Thursday as

    Posting 1/1/2016  -> Due = 2/25/2016

    Posting 2/1/2016  -> Due = 3/31/2016

    Posting 3/1/2016  -> Due = 4/28/2016

    Posting 4/1/2016  -> Due = 5/26/2016

    But in October Posting 10/1/2016  -> Due = 12/1/2016


    because payment days = 25 is too more

    but if I set up as 24 

    2313.4.jpg

    The result is below. November is correct, due date = 11/24/2016

    but March is incorrect, due date = 3/24/2016 (correct should be 3/31/2016).

    And another months are correct. Only this month's problem because payment day as 24 is too less.

    0755.5.jpg

    Do you have any idea? Thank you and please advise.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: How to set up Term of payment at last Thursday?

    Hi,

    I tried the following, which seems to work for your scenario 15 Feb and 15 October.

    Can you double check whether this setup fits your needs?

    8838.PT1.png

    Ludwig

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans