Hello,
I'm working with Jet Reports Essentials for a few weeks now. So far I haven't had any issues apart from not knowing enough how NAV is set-up.
I'm trying to search all assemblies in which a certain article number is part off. I have a list which uses the "Production BOM Line" table. Problem with this table is that I can get the "Prod. No", but not the version number of the BOM article. In NAV we use the "Where used function", and today I saw that the table used for this information is "Where-used Line". I've tried to get all rows from this table using JetReports, but no rows are returned. I've found only one person having the same issue. How is it possible Jet cannot get any information from this table? This simple NL-function, even without any filters, won't return any value.
I hope you guys can help me out because we have lots of Jet reports that are depended on searching article information and extracting BOM's.
Date
Votes
5 comments
-
Jet Reports Historic Posts One thing which can occasionally be an issue for report designers is table permissions. Jet Reports generally looks to your system for which tables you are permitted access to, and if you cannot see the table in NAV, you won't be able to see the data from it in a Jet Report. I would check with your systems admin first.
-
Jet Reports Historic Posts Thanks for your answer.
I'm able to view information from this table in the RTC client, so I guess I already have permission to this table? -
Jet Reports Historic Posts Yes, it sounds like you do have the permissions needed.
Unfortunately - my company does not use this table (not manufacturing), so I can't test the table myself as in my environment it is empty and still would not return any values. -
Jet Reports Historic Posts I'm not familiar with that specific table, but some tables in NAV are filled when viewed and emptied when closed.
Can you see data in that table when running it in the object designer?
You might need a developer environment for that though…
rmw -
Jet Reports Historic Posts Hi.
The Ware-used table is only populated in NAV when you run the Ware-used function, so unless you call this function in NAV it of no use to you. you will need to run a query against all the lines that you are interested in, i.e. BOM Lines and Production Component lines
Malcolm
Please sign in to leave a comment.