Sign Up for Training |
Jet Global Company Site
Submit a Request
Give Feedback

Using Vendor 1099 Code


When attempting to use the field "1099 Code" from the Navision table "Vendor", you receive a #Value or "Invalid field '1099 Code'."

Because Jet Essentials allows you to specify table and fields by the table or field number, Jet Essentials interprets "1099 Code" as: 'use field number 1099 from the Vendor table'. This field does not exist; therefore, causing the error.


To access the "1099 Code" field, you have to use the actual field number of the field: 10020.


=NL("First","Vendor","10020 1099 Code","No.",B3)  or


Will return the value from the field number 10020 from the Vendor table.

NOTE: This applies only to Navision database.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request