Problem:
When attempting to use the field 1099 Code from the Dynamics NAV table Vendor, you receive a
- #VALUE! or
- Invalid field '1099 Code'
Because Jet Reports allows you to preface table and fields name with the the table or field number, Jet Reports interprets "1099 Code" as: 'use field number 1099 from the Vendor table'. This field does not exist; therefore, causing the error.
Solution:
To access the "1099 Code" field, you have to use the actual field number of the field: 10020.
Example:
=NL("First","Vendor","10020 1099 Code","No.",B3)
or
=NL("First","Vendor","10020","No.",B3)
Either function will return the value from the field number 10020 from the Vendor table.
Comments