web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

MR2012 and DAX 2009: soft close to get opening balance

(0) ShareShare
ReportReport
Posted on by

Hi everyone

A straightforward question to which so far I have been unable to find the answer.


Situation

I'm building a consolidation report in Management Reporter 2012. The data is period-to-date (PTD). To get the balance sheet correct, I need the opening balance. The fiscal year runs from Jan-Dec and as the auditors have not completed the audit for 2014 yet, the year 2014 is not yet closed in DAX 2009.

Problem

I can't use the "Periodic\BB" feature in MR2012 as the Beginning Balance is not there in DAX. I've read about a 'soft close' procedure but I've only found instructions to do a soft close in DAX 2012.

Question

Is there a 'soft close' feature in DAX 2009?

How does that process work? What steps should I go through?

In the absence of a softclose process in DAX 2009, what are my alternatives? I thought of getting the ending balance YTD for the previous year. But are there other ways?

Thank you for your time and help!

yours

Abaw

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    on at

    Hi Abaw,

    The financial year can be closed more than once, till the moment you set all periods to Closed. If you close your year financially via GL - Periodic - Fiscal year close - Opening transactions, the closing and opening transactions will be created. Afterwards adjustments can be made and you can again close the year, balances will be recalculated. 

    First test it in an Acceptance environment to see if this meets your requirements. 

  • Verified answer
    Community Member Profile Picture
    on at

    In addition to good explanation by Jan-Luuc Halsema,

    Dynamics AX does allow performing soft-closing and hard-closing

    Fiscal Year Period Soft-Closing:

    Generating closing and opening transactions for Closing Financially Year by running by "GL >> Periodic >> Fiscal year close >> Opening transactions"

    It will generate closing and opening transactions with new Voucher

    You can then make any new adjustment entries after observing these results

    and ensure keeping all the periods "OPEN" within that financial year

    Fiscal Year Period Hard-Closing:

    Generating again the closing and opening transactions for Closing Financially Year by running by "GL >> Periodic >> Fiscal year close >> Opening transactions"

    It will delete previous generated transactions and will generate new closing and opening transactions with new Voucher

    and ensure setting all the periods "CLOSED" within that financial year

    “CLOSED” period will not allow any new transactions, this is a complete permanent action and will never allow re-open the closed period.

    Note: Financial year closing is heavy transactional task, it should be performed with Full-Backup before & after

  • Verified answer
    Community Member Profile Picture
    on at

    Hi

    To complete the responses after testing, a few remarks.

    1) To soft close, you must have the parameter under GL --> Setup --> Parameters --> Ledger tab --> "Set period status to year closed:" set to "no" by unticking it. Otherwise you will get an error message ("The period xxx closing is not closed")

    2) For some reason or another, the menu item I see is called "Accounting year close"

    But yes, it works :-)

    Yours


    Abaw

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans