Problem in table access

(0) Share

Report

Posted on by JCalvo

Hello, I have a problem with the item table. I have de DataPerCompany property value to "No" and all the relational tables the same. I create a new item and in one of the companies I could use it and in the other I could not. I could not use in the company where I create the item. If I restart the nav service it still work again.

Here is the capture of the error when I trie to use it once its created.

i62.tinypic.com/23mvae8.jpg

Has anyone any Idea of the problem?

Thanks for all.

*This post is locked for comments

All responses (3)

Answers (1)

Suggested answer

Suresh Kulla 44,656 on at

Like (0)

Report

RE: Problem in table access

When you get that error, can you please check in the event log if there is any additional information, because if it is working on restart it may be some kind of synchronization problem. What NAV version are you using ?
JCalvo 70 on at

Like (0)

Report

RE: Problem in table access

The item is not blocked in any company, there are no security filters. The translation of the error is "The field No of the table Purchase Line has a value (E037B15B) that could not be find in the relational table (Item)"
Verified answer

keoma 32,675 on at

Like (0)

Report

RE: Problem in table access

first restart nav service, then try again.

It can be that the value which is displayed in the purchase 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.

also check, if the item is blocked in the company and if there are security filters.

please translate the error message.