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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Error when change stat...
Microsoft Dynamics AX (Archived)

Error when change status period from Stopped to Closed

(0) ShareShare
ReportReport
Posted on by Yanti 155

Hi,

I having problem in AX 2009 while in the general ledger --> periods, i have to change status period from stopped to closed.

i have successfully close at few month, but at with some month i facing the following error :

"Transaction exist in the inventory journals for the current period"

I have checked : all inventory journal, AR, AP and General Ledger, There don't have any pending journal.

Thanks

Yanti

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,743 Super User 2026 Season 1 on at

    Hi Yanti,

    Are you also using Production or Project management?

    It could also be a record not visible to you as it is possible to set journals private.

    Can you find anyone to have a look into the tables using a table browser (e.g. within AOT or SQL management studio)? Then you also might find some "hidden" records.

  • Yanti Profile Picture
    Yanti 155 on at

    Hi Andre, thank you for you reply.

    i also use Production module.

    Which table, should i search "hidden" record and what should i do with that.

    Thank you very much

    Yanti

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,743 Super User 2026 Season 1 on at

    Hi Yanti,

    Have you checked if there are pending journals related to this period in Production?

    With "hidden" I meant that a user can select a journal to be private. Then it is hidden for all other users. But if you open the table directly (not using a Journal form) this filter is not applied. Then you can see who is the "owner" of this journal and ask this person to unlock it and/or take the required actions so you can close the period.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Basicaly system generates this error message from method

    dataDictionary\Tables\LedgerPeriod\checkJournal()

       select  firstonly inventJournalTrans

       where   inventJournalTrans.TransDate >= this.PeriodStart                                &&

               inventJournalTrans.TransDate <= this.PeriodEnd

       join    inventJournalTable

       where   inventJournalTable.Posted     == NoYes::No                                      &&

               inventJournalTable.JournalId  == inventJournalTrans.JournalId;

       if (inventJournalTrans)

           return checkFailed("@SYS28650");  //"Transaction exist in the inventory journals for the current period"

    So you should review following tables InventJournalTrans and inventJournalTable for period which you want to close

    there you will find some inventory journal still open

    please verify and update us with your findings

  • Yanti Profile Picture
    Yanti 155 on at

    Hi Nitesh & Andre,

    Thank you for all your reply, i have success Month Closing :)

    Yanti

  • Community Member Profile Picture
    Community Member on at

    appreciated if you please update the answers as verified, if details helped you.

  • Yanti Profile Picture
    Yanti 155 on at

    Hi Nitesh,

    I open the blocked transaction on " inventJournalTable ", and deleted the journal.

    After monthly close, i have to fiscal end year closing, i have some facing the following error "Total of the transaction in the year is not 0.00. Total is 0.00. This is serious error. Run \"Check\" on ledger transaction

    I have checked "Consistency Check" of general journal --> ledger transaction, there is found zero error.

    Thank you

    Yanti

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,743 Super User 2026 Season 1 on at

    Hi Yanti,

    This error is related to the task Opening transactions. You get this error if the ledger accounting transactions are not zero in total. As the mentioned total is 0.00, you could have some transactions where the amount is stored in the database with more that 2 decimals. Rounded it seems to be OK. Can you check this? Due to incorrect customizations I have seen a similar issue in the past.

    You have to check it directly in the SQL database as AX only shows the ledger amounts with 2 digits.

  • Yanti Profile Picture
    Yanti 155 on at

    Hi Andre,

    I checked in SQL database where all ledger amounts are rounded to 5 decimal. This is because we use an exchange rate conversion system (other currencies to IDR, current exchange rate is 1 IDR = 8.6 × 10-5 U.S. dollars). This is a precision (exchange rate setup) that we cannot ignore, however it should be possible to round the ledger amounts to 2 decimal places.

    Do you have any suggestions on how to proceed, in accordance with the best practices?

    Thank you

    Yanti

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Andrew Jones a1x Profile Picture

Andrew Jones a1x 2

#3
GL-01081504-0 Profile Picture

GL-01081504-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans