0

Restrictions on flowfilter field

Hi,

I'm trying to create a simple report based on item table from NAV. All I wish to include is "No.", "Description" and a flow filter based on item ledger entries we call "Usage".
My problem is I wish to exclude certain document types, within NAV the following filter can be applied: "<>IM*&<>INTM*&<>PSHIP*".

However due to special character restrictions I can't recreate this in JET. I've tried using various single/double quote methods to encapsulate it but still get the standard error about special characters not being allowed.

Is it even possible? Am I just not getting the syntax right?

Any help appreciated.

6 comments

Please sign in to leave a comment.