Hi,
I get an error when I very simply try to bring in the 1099 code from the Vendor Table. It gives me the #VALUE error.
Is this a unique problem to my database? Or has anyone else seen it?
Thanks again,
Susan
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi Susan,
I think the problem is that Navision not only names the fields in the tables but also numbers them as well. You can use either the field name or number when you are using Jet Reports. For instance, the field "1099 Code" has the field number of "10020" in my database (it should be the same in yours). When you enter a field name that starts with a number, Jet Reports assumes that you are using the field number instead of the field name. This is why you are getting the error. You do not have a field in the Vendor table with the field number "1099". Does this make sense?
Change your formula to use the "10020" instead of "1099 Code" - your formula will look something like this:
=NL("Rows","Vendor","10020")
or even
=NL("Rows","Vendor","10020 Vendor 1099 Code")
This works because Jet Reports ignore anything in the field name after the number.
This should give you an idea of what the formula should look like. To find the field numbers in your database, you will need to have permissions to use the Object Designer and be able to Design the table. Most user do not have access to this because they could potentially "break" the database. But you can always ask your Navision consultants for the information.
Does this help? -
Jet Reports Historic Posts Yes tremendously. I didn't anything about field numbers. Yes I do have access to the designer. That worked. I am so glad this community is here.
Thank you once again,
Susan -
Jet Reports Historic Posts I had the same problem and this fixed my report as well…
Thanks…
Please sign in to leave a comment.