I have the Jet template for aged receivables working [NAV017 - Accounts Receivable Summary].
However, i need to be able to filter the information / extract data based upon a filter
How do I modify the table so that i can filter by Global Dimension 1 and/or Global Dimension 2?
Thanks,
Rich
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Rich,
I updated the report to filter for GD1 and attached it here for you. I will list out the steps I followed to complete the task. You can use these if you want to add more filters from the Customer table.
* I inserted a new row under the Balance filter (in row 9) for the new filter.
* Added the keyword Option to A10 so it will appear in the Report Options window.
* Added the label of Global Dimension 1 Code and value of * as my filter.
* Next we need to update the function so that it will actually filter on this new field. I did that by updating the function in cell D29. I expanded the range for the Filters= parameter to include C9:D10.
If you want to add a filter for GD2, simply add a new row to the report, include the word Option in column A. Then update the Filters= range to include the new row.
I hope this helps!
Please sign in to leave a comment.