Hello,
Is it possible to set up AX 2012 so that it becomes possible to post ledger accruals within 'next open fiscal period' when the spread includes a period which is 'on hold'?
Many thanks in advance!
Cyrille
*This post is locked for comments
Hi Cyrille,
What I shared and mentioned is a standard functionality that you should be able to replicate in any Microsoft 'Contoso' demo company.
You can find a documentation about this feature on the following site:
docs.microsoft.com/.../create-accrual-schemes
Hope this answers your questions.
Best regards,
Ludwig
Hi Ludwig,
It works indeed, I tried and succeeded but not in all test scenarios.
Consequently, have 2 more questions to you:
1) Is it standard AX functionality?
2) If so, is there any documentation about how it works available for me to make sure that I have full understanding of the logic behind spreading accruals across different open and on hold periods?
Regards,
Cyrille
Hi Cyrille,
You can test this. Simply create a GL journal for a vendor invoice and post an expense account as the offset account. Then use the accrual functionality and take a look at the transaction preview. In my example, I see the following for an invoice for a total of $12000 that is accrued monthly with your 3 months closed.
Please test this yourself in a demo/test environment.
Best regards,
Ludwig
Hi Ludwig,
Correct, this is something I'd like to check if possible with standard AX without customization, as I understand, it is not possible, is it?
Regards,
Cyrille
Hi Cyrille,
In your example September will get the amounts posted that should be recorded in Jun, Jul, Aug.
That is you will see 4x the accrual in September.
Best regards,
Ludwig
Hi Ludwig,
For instance, we are in open period March 2019, have all other months of 2019 open, except for Jun-Jul-Aug that are 'on hold'. My question is, does standard AX (any module) allow posting to Sep 2019 as it is next open period after Aug which is on hold?
I understand that ledger accruals post to open periods only but what about other modules?
Regards,
Cyrille
Hello Cyrille16,
Please define 'next open fiscal period' ideally by a simplified example.
What if there no next open fiscal period and all future periods are closed.
Many thanks,
Ludwig
Hello Andre, Ludwig,
Thank you, your responses are helpful. Is there any out of the box functionality in standard AX that allows postings to 'next open fiscal period' ?
Hi Cyrille,
Can't you leave all of your periods open for a couple of accountants that post such accruals and lock them for others by making use of the module access restriction function?
Best regards
Ludwig
Hi Cyrille,
This is not possible out of the box. To be able to do the accruals, each period should be open. You can actually consider a customization.
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,232 Super User 2024 Season 2
Martin Dráb 230,064 Most Valuable Professional
nmaenpaa 101,156