Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) The field cost element...

The field cost element of table Sales Line contains a value that cannot be found in the related table(GL Account)

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

When I try to select a cost element for an item the error The field cost element of table Sales Line contains a value that cannot be found in the related table(GL Account) is generated. I know the Cost element exists in the chart of account but when I try to dill down from the sales line in the stock issue card I cannot see it. I can only see a filtered values for that particular item. The reason could also be a Gen. Posing set up but I tried that one and couldn't work. I am asking if someone experienced the same problem and help me figure out.

Thanks

*This post is locked for comments

All responses (4)

Answers (1)

Verified answer

mmv 11,465 on at

Like (0)

Report

RE: The field cost element of table Sales Line contains a value that cannot be found in the related table(GL Account)

So, the value which is displayed in the Sales Line for the moment where you are getting the error is not within the filter applied in either the TableRelation property of the respective field or you need to debug the code.
Suggested answer

Rajasekhar@MS 5,567 on at

Like (0)

Report

RE: The field cost element of table Sales Line contains a value that cannot be found in the related table(GL Account)

Can you check by activating the debugger, you will be able to find the code what caused the issue
Community Member Microsoft Employee on at

Like (0)

Report

RE: The field cost element of table Sales Line contains a value that cannot be found in the related table(GL Account)

Yes, there is a customization in the Sales Line, the issued card is fully customized which is used to issue items from stores. When I dirlldown in the cost element I can see other GL accounts but others are filtered out.
mmv 11,465 on at

Like (0)

Report

RE: The field cost element of table Sales Line contains a value that cannot be found in the related table(GL Account)

Hi,

Is there any customization in the Sales Line?