0

Vendor Report Missing City and State

Jet Reports Historic Posts

March 03, 2017 16:59

None

Follow

I created a simple report to pull Vendor Name, Address, City, State and Zip. All fields are pulling into the report except City and State. Does anyone have any suggestions for a solution? Is this a known software issue?

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts March 03, 2017 19:10

  Hello -
  
  First, is that data in the database?
  
  If you access NAV's Object Designer which is located either in the NAV Development Environment (for NAV 2013 or newer) or in the Classic Client (for older versions), select the Vendor table and click RUN:
  
  
  
  This will display the Vendor table within the NAV client:
  
  
  Are the fields for City and State populated?
  
  If so… let's look at the report itself.
  
  Are you using:
  - an NL(Table) function?
  - NL(Rows) with NF() function?
  - NL(Rows) with NL(First) functions?
  
  If we could see the design of the report, that would help.