Sign Up for Training |
insightsoftware Company Site
Submit a Request
Become a Jet Insider
Give Feedback

NAV (and Navision) Code and No. fields with Special Characters

This information only applies to Dynamics NAV users.


Characters used in NAV filters (such as the ampersand "&", pipe "|", and range indicator "..") should not be used in Code or No. fields. In addition, you should not use blank Codes or No.s.  Using blanks or special characters in your Code or No. fields will cause problems with reporting and filtering in both NAV and Jet Reports.  Fortunately, it is rare to find blanks or special characters in Code or No. fields.

When field values contain filter characters such as "&", you must put the field values in single quotes to use them in a filter.  For example, if customer IDs have embedded "&"s you can filter on the customer ID as follows.

B2: =NL ("Rows","Customer","No.")

B3: =NL(,"Customer","Name","No.","'"&B2&"'")

Note the customer number is in a formula that surrounds it with single quotes: "'"&B2&"'".  This causes NAV to consider any embedded special characters as part of the field value.
Was this article helpful?
0 out of 0 found this helpful