0

Special Character in filter

Newman Cui

October 02, 2018 04:23

None

Follow

=NL("First","Jet Customer Master","Customer Name","Customer Number","'"&$D14&"'")

Good afternoon, when we set up Debtors in Dynamics GP, Accounts Receivable used "&" as part of the Debtor ID, such as ADA&SON, J&LJOHNSON, so I used this format "'"&$D14&"'". It works with all the debtors with "&" in the middle of the debtor ID, but doesn't work with this debtor ID "GRIB&S&", it returns "Invalid filter "GRIBS"". I think it is because of the last "&", what do I need to do to make the function work? 

Thanks. 

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Harry Lewis October 02, 2018 14:57

  Hello Newman -

  So far, I have been unable to duplicate what you are experiencing.

  e.g.,

  

  resulting in:

  

  If the error message you listed is completely accurate, there appears to be an issue with the quoting (the error message has an extra quote in it, somehow).

  Could you check that your function's filter is actually using the format:  double-quote single-quote double-quote (especially after your cell reference)?

  "'"

  and could you embed a screen shot of the actual message displayed?