I have a report that runs from the Sales Invoice Line report. One of my users is trying to run the report but gets #VALUE! in most of the cells. The error message is "Invalid Table 'Sales Invoice Table.'" I checked and he has read access to that table, but not the header. I added read access to the header and all other tables that the report pull from. He is still getting the error.
Date
Votes
3 comments
-
Bryan Robinson That specific error is saying that the table in your query does not exist, not that they don't have access to it.
Without knowing your database/ERP, I can only guess that you are using NAV or Business Central. Within those databases, there is no table called "Sales Invoice Table" unless you have some customization done. The sales invoices are separated into Sales Invoice Header and Sales Invoice Line tables.
It is best practice to always use the drop down menus and search functionality within the report building tools of Jet to ensure valid tables (and spelling) are entered to the query.
-
Lewis Rosenberg Sorry for missing part of the table name. It is the Sales Invoice Line Table on NAV2013R2.
I set up a test user with the same permissions as him and was able to run the report, so I am puzzled as to why he cannot run the report. He insists he is connected to the network. -
Lewis Rosenberg Ah....the issue was that the user had the incorrect data source (Cubes) selected (instead of DIRECT database connection),
Please sign in to leave a comment.