Microsoft Dynamics AX (Archived)

How to set up Term of payment at last Thursday?

(0) Share

Report

Posted on by Community Member 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

All responses (4)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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

And Term of payment.

Payment method = Current month

Month/days = 0

Then the result is

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

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.

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

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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?

Ludwig