Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Unanswered

System message 9 Item not found in journal transactions

Posted on by 245

A new account was created and shows in chart of accounts maintenance.  When trying to do a journal entry, the account number is not found, getting System Message 9 Item not found, please reenter.  I have tried resolution 9436 by changing the first description in the chart of accounts maintenance but that did not fix it.  Any suggestions?

I can pull up the account when I go to account history. 

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: System message 9 Item not found in journal transactions

    Anyone found a resolution for this?

  • Sharon Profile Picture
    Sharon 245 on at
    RE: System message 9 Item not found in journal transactions

    Correct

  • Ram Peru Profile Picture
    Ram Peru 2,830 on at
    RE: System message 9 Item not found in journal transactions

    You are saying that you have already added the new account using Charts of Accounts Maintenance through Main company but that does not work too.

  • Sharon Profile Picture
    Sharon 245 on at
    RE: System message 9 Item not found in journal transactions

    Yes, I have multi company.  I had not tried it in the main company but have since done so and nothing I add shows up in the AcctXref.

    Thanks

    Sharon

  • Ram Peru Profile Picture
    Ram Peru 2,830 on at
    RE: System message 9 Item not found in journal transactions

    Hello Sharon,

    Do you have multi-company setup in Dynamics SL? If Yes, Did you try to create the Chart of Accounts from Master company?

  • Sharon Profile Picture
    Sharon 245 on at
    RE: System message 9 Item not found in journal transactions

    Hi Perumalsamy,

    I ran this and the account does not show up.  I added another new account and it does now show either.  I tried changing an existing account description also but no luck.

  • Sharon Profile Picture
    Sharon 245 on at
    RE: System message 9 Item not found in journal transactions

    Hi John,

    I tried this and the new account does not show up either.  Any other thoughts?

  • Sharon Profile Picture
    Sharon 245 on at
    RE: System message 9 Item not found in journal transactions

    Thanks for both your responses.  I ran the query and the account does not show up.  I tried inserting a new account and it does not show either in the script and I get the same message when trying to use it in journal transactions.  Any other suggestions would be greatly appreciated.

  • John_Joyce Profile Picture
    John_Joyce 1,040 on at
    RE: System message 9 Item not found in journal transactions

    Another trick: Add a new account, such as 9999 TEST. Then delete this new account.  Or change an existing account description, save, and then change it back.  Usually those types of changes will trigger an update to the AcctXRef table that Perumalsamy noted.

    John

  • Ram Peru Profile Picture
    Ram Peru 2,830 on at
    RE: System message 9 Item not found in journal transactions

    Good morning Sharon,

    I believe that your new Account doesn't get inserted into the AcctXref table of System database.

    To my knowledge, This AcctXref table is automatically inserted while creation of new accounts in chart of accounts Maintenance screen.

    Execute the below query in System Database to find out your new account in AcctXRef table.

    Select * from AcctXRef where CpnyID = 'XXXXX' and Active = 1 and Acct Like 'XXXXX' order by CpnyID, Acct  

    Here XXXX is the company ID & Account Number.

    Also use the below link http://support.microsoft.com/kb/871403/pt for your reference

    Hope this explains.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans