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
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.
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
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156