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

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

I have the same question (0)

All responses (4)

Answers (1)

mmv 11,471 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?

Was this reply helpful? Yes No
Community Member 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.

Was this reply helpful? Yes No
Suggested answer

Rajasekhar@MS 5,569 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

Was this reply helpful? Yes No
Verified answer

mmv 11,471 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.

Was this reply helpful? Yes No