Filtering error - report Request page

poppins
poppins Member Posts: 647
in NAV Three Tier
Hi everyone,

I tried to run report 109 with a filter on "Payment terms" in the request page like this:1M(8D).
I got the following error message:

One or more filters are not valid. Check the filters and correct them as needed. The filter "1M(8D)" is not valid for the Payment Terms Code field on the Customer table. Did not expect a '('.

Is standard NAV really unable to handle such filters for Code fields?

Thanks in advance :)

Answers

  • archer89
    archer89 Member Posts: 337
    replace value with '1M(8D)', means incl. quotes.
    best regards
    Franz Kalchmair, MVP
    Alias: Jonathan Archer

    please like / agree / verify my answer, if it was helpful for you. thx.
    Blog: http://moxie4nav.wordpress.com/

Categories