Skip to main content

Notifications

Dynamics 365 Community / Forums / Business Central forum / Has anyone lost the ta...
Business Central forum
Suggested answer

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

editSubscribe (0) ShareShare
ReportReport
Posted on by LK-07050844-0 2

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.

Categories:
Other
  • LK-07050844-0 Profile Picture
    LK-07050844-0 2 on at
    Has anyone lost the table relation between the Standard Journal and Employee tables?
    Is it somehow possible to add a table relation via extension or maybe add it in the Base App? 
  • Suggested answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 10,155 User Group Leader on at
    Has anyone lost the table relation between the Standard Journal and Employee tables?
    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
    LK-07050844-0 2 on at
    Has anyone lost the table relation between the Standard Journal and Employee tables?
    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
    Saurav.Dhyani 10,155 User Group Leader on at
    Has anyone lost the table relation between the Standard Journal and Employee tables?
    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
  • gdrenteria Profile Picture
    gdrenteria 3,108 Super User on at
    Has anyone lost the table relation between the Standard Journal and Employee tables?
    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

Helpful resources

Quick Links

Take the Community feedback survey!

Answer this brief 15-question survey about your Community experience…

Demystifying Copilot: Service Edition with Sundar Raghavan

Sundar answers more questions about Copilot for Service...

Dynamics 365 Business Central vs Finance and SCM

Take a look at the key differences between Business Central and…

more Community News

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,375 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 223,308 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,140

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans