Sign Up for Training |
Jet Global Company Site
Community
Downloads
Training
Submit a Request
Become a Jet Insider
Give Feedback

Using Vendor 1099 Code


This information applies to Dynamics NAV

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.

Was this article helpful?
0 out of 0 found this helpful

Comments