Choose a Microsoft Dynamics NAV Filter Format
Updated: November 10, 2004
By J. Carlton Collins, CPA
Looking to create a more comprehensive audit trail? J. Carlton Collins, CPA, president of ASA Research, LLC, offers examples of the various filter formats you can use to drill down on financial data in Microsoft Dynamics NAV.
Equal to | 377 | Number 377. |
Interval | 1100 .. 2100
..2500
P8.. | 1100 through 2100.
Up to and including 2500.
Information for accounting period 8 and thereafter. |
Either/or | 1200|1300 | Those with number 1200 or 1300. If there is a record with each number, both will be shown. |
And | <2000&>1000 | Numbers that are less than 2000 and greater than 1000. (The & sign cannot be used by itself with numbers because no record has two numbers.) |
Different from | <>0 | All numbers except 0. |
Greater than | > 1200 | Numbers greater than 1200. |
Greater than or equal to | >=1200 | Numbers greater than or equal to 1200. |
Less than | <1200 | Numbers less than 1200. |
Less than or equal to | <=1200 | Numbers less than or equal to 1200. |
An indefinite number of unknown characters (may be none) | *Co**CoCo* | Texts that contain Co, end with Co, and begin with Co. |
One unknown character | Hans?n | Texts such as Hansen or Hanson. |
Calculate before rest | 30|(>=10&<=20) | Those with number 30 or with a number from 10 through 20 (the result of the calculation within the parentheses). |
You can also combine the various format expressions, as the following examples illustrate.
5999|8100 .. 8490 | Include any records with the number 5999 or a number from the interval 8100 through 8490. |
..1299|1400.. | Include records with a number less than or equal to 1299 or a number equal to 1400 or greater—that is, all numbers except 1300 through 1399. |
>50&<100 | Include records with numbers that are greater than 50 and less than 100—that is, numbers 51 through 99. |
*C*&*D* | Texts containing both C and D. |
@*co?* | Texts containing co., CO., Co., cot, cope, incorporated, and so on. (CO, cO, co, or Co must be present, followed by at least one character. But there can be an indefinite number of characters before and after these, and case is unimportant.) |
J. Carlton Collins, CPA, president of ASA Research, LLC, is an independent author, lecturer, and analyst in the accounting systems industry. He has installed more than 200 accounting systems and delivered 1,800 lectures around the world on the subject of accounting systems and technology. Collins has published extensive accounting system reviews that can be seen at Accounting Software Advisor.
