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.
Restrictions on flowfilter field