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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Has anyone lost the table relation between the Standard Journal and Employee tables?

(1) ShareShare
ReportReport
Posted on by 70

Hi guys, this is a question related to Business Central. I have been working on something in the General and Standard Journal and noticed that I cannot access the employees upon selecting Employee in the Account Type field in the General Journal. Previously when I selected the account type I the names of the employees in the company appeared in the Account ID field but now, I receive a message (We have nothing to look up here.) Is this because of some update? Has anyone faced this before? I don't have access to change preexisting table relations from the Base Application, so I couldn't possibly modified anything.

I have the same question (0)
  • Gerardo Rentería García Profile Picture
    27,054 Most Valuable Professional on at
    Hi
    In general journal lines, I do see that this relationship exists, but in the standard journal by code I do not see it. I'm not sure if it existed before.
     
    BR
    GR
  • Suggested answer
    Saurav.Dhyani Profile Picture
    14,419 User Group Leader on at
    Hello,
     
    In General Journal Line the relationship still exist in latest version of Business Central (V24). 
     
    But for Standard Journal the relationship is not available.
     
    Which version of business central you are using? And in which version you were able to do so?
     
    Regards,
    Saurav Dhyani
  • LK-07050844-0 Profile Picture
    70 on at
    The current version I'm on is 23.5. Not sure which version it was when I could, but I remember being able to do so clearly a month ago.
  • Suggested answer
    Saurav.Dhyani Profile Picture
    14,419 User Group Leader on at
    Hello,
     
    I did check with prior version (V22 and V21) and in standard base it has not changed.
     
    May be look for a PTE that was enabling this functionality in Standard Journal.
     
    It works as expected in General Journal.
     
    Regards,
    Saurav Dhyani
  • LK-07050844-0 Profile Picture
    70 on at
    Is it somehow possible to add a table relation via extension or maybe add it in the Base App? 

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,466 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,829 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,505

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans