Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Transfer Opening Transactions

Posted on by 505

In closing the fiscal year, I am trying to transfer closing balances to the new year through the Opening Transactions function in GL > Periodic > Fiscal year close > Opening transactions, and receive an Infolog with the message "No transactions to post."

In the closing section of the Opening transactinos form, I select the correct fiscal year, end dates for the "Balances through fiscal period" (Period 12) and "Post to fiscal period" (Period 13) options.  In the Opening section, I select an end dat for the "Balance through fiscal period" (Period 13), Closing>Opening in the "Balance accounts" option, and enter a voucher number.

In the main account setup, I've set the "Close" option to Balance for all balance sheet accounts, and Result for all revenue and expense accounts.

In General ledger parameters, I have selected "Delete close-of-year transactions during transfer," "Create closing transactions during transfer," and "voucher number must be filled in" in the Fiscal year close fast tab of the Ledger section.  I've also selected "Use posting definitions" in the Accounting rules fast tab because of a previous message I received while trying to transfer opening transactions.

I've reviewed the trial balance, and confirmed that no adjustments are needed, so I don't think I need to use the Closing sheet.

I'm thinking this may be related to the posting definition setup.  Please advise on how to setup the posting definitions for year-end close, or provide suggestions on any other setup that is needed. 

In addition, will the Opening transactions job also close out revenue and expense accounts to retained earnings, or is that done with another process?

Thanks in advance for your help!

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Transfer Opening Transactions

    Hi Chris,

    The amounts on balance account are moved to the same account during opening.

    The amounts on a P&L account will be moved to the 'year-end result' or specified opening account during closing.

    If you take the trial balance from the system at the end of the fiscal year and run a P&L, you should be able to see earnings for the current year which is expected to be transferred to the opening account for P&L type accounts.

    Regards

    Rahul Mohta

    Independent Advisor for Microsoft Dynamics AX

  • Shirl Profile Picture
    Shirl 385 on at
    RE: Transfer Opening Transactions

    I finally figured it out after some help from Microsoft, where we still needed public sector active AND we needed to balance by fund.  The main accounts needed to have nominal if P&L and real if balance sheet - plus of course the posting definitions have to be setup properly.  Best of luck to anyone else having this issue!  Government implementations are fun!

  • Shirl Profile Picture
    Shirl 385 on at
    RE: Transfer Opening Transactions

    I am having the same problem, but I need the fund balance to come through (so I can't unmark that), and I need public sector to remain active.  Has anyone else been able to resolve it without messing up the public sector functionality?

  • gg2 Profile Picture
    gg2 10 on at
    RE: Transfer Opening Transactions

    I encountered similar issues in an AX 2012 R2 environment.

    Solution was obtained by removing the checkbox(es) related to Fund dimension under Fiscal year close on Ledger tab within General ledger parameters.  Menu path: General ledger > Setup > General ledger parameters

    Public Sector license was and remained activated.

  • Henrik Larsen Profile Picture
    Henrik Larsen 646 on at
    RE: Transfer Opening Transactions

    Just a quick comment on the synchronization issue. When doing this in a live system, you may loose data if you remove licences or configuration keys. However, if you make a back up of environments and database beforehand you should be able to roll back without problems. Also, it would be wise to test in a test or development environment beforehand.

    Since Posting definitions is part of the Public Sector "vertical" I would not have thought you should tick that unless you actually use Posting defintiions, but I guess they disappeared when you removed the PS licence...

  • Chris Melson Profile Picture
    Chris Melson 505 on at
    RE: Transfer Opening Transactions

    Stephen,

    Sorry for the delayed reply.  We were live when the change was made.  We first ran the process of removing the Public Sector license codes in Test first, then in Prod.  We did not use any of the Public Sector functionality, and have not seen any adverse effects since making the change a couple months ago.

  • Kooper Profile Picture
    Kooper 150 on at
    RE: Transfer Opening Transactions

    Chris,

    I am receiving the same error message.  I was told running the synchronization after going Live could be very dangerous.  Were you Live when you changed this License information?

  • Chris Melson Profile Picture
    Chris Melson 505 on at
    RE: Transfer Opening Transactions

    Sorry for the delayed reply, Stijn.  What resolved it for us was to disable the Public Sector functionality.  Go to System Administration > Setup > Licensing > License Information.  Click the Feature Sets tab and clear out the license code for Public Sector.  Then synchronize, and the opening transactions should be generated successfully.  Hope this helps!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Transfer Opening Transactions

    Hi Chris, I have the same problem. Do you have a solution for this? Thank you. Regards, Stijn

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans