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.