0

Invalid 1099 Code...

Jet Reports Historic Posts

January 21, 2009 18:03

None

Follow

I think this was an error last year too…

Does anyone have the resolution?

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts January 21, 2009 18:36

  Found this on the Support site: http://support.jetreports.com/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=503
  
  

  Using Vendor 1099 Code
  
  SolutionWhen attempting to use the field "1099 Code" from the Navision table "Vendor", you may receive a #Value or "Invalid field "1099 Code"." Because Jet Reports allows you to specify table and fields by the table or field number, Jet Reports interprets "1099 Code" to mean to 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. This requires that you use field number 10020. For example,
  
  =NL("First","Vendor","10020 1099 Code","No.",B3)
  Will return the value from field number 10020 from the vendor table.
  
  This applies on to the Navision database.

• 0
  
  Jet Reports Historic Posts January 21, 2009 18:45

  That is excactly what I needed…many thanks….