Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Ledger accruals posting to next open fiscal period

Posted on by 85

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

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Ledger accruals posting to next open fiscal period

    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

  • Cyrille16 Profile Picture
    Cyrille16 85 on at
    RE: Ledger accruals posting to next open fiscal period

    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

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Ledger accruals posting to next open fiscal period

    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.

    accrue.png

    Please test this yourself in a demo/test environment.

    Best regards,

    Ludwig

  • Cyrille16 Profile Picture
    Cyrille16 85 on at
    RE: Ledger accruals posting to next open fiscal period

    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

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Ledger accruals posting to next open fiscal period

    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

  • Cyrille16 Profile Picture
    Cyrille16 85 on at
    RE: Ledger accruals posting to next open fiscal period

    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

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Ledger accruals posting to next open fiscal period

    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

  • Cyrille16 Profile Picture
    Cyrille16 85 on at
    RE: Ledger accruals posting to next open fiscal period

    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' ?

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Ledger accruals posting 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

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,232 Super User 2024 Season 2 on at
    RE: Ledger accruals posting to next open fiscal period

    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.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,064 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans