Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Feedback

Using Vendor 1099 Code


Problem:

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.

Solution:

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

Ex:

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

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

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

Comments