How to add filter on a General Ledger Report

How to add filter on a General Ledger Report

Adding Filter

You can add filter to meet the report that you need. 

To add Filter:
1. On General Ledger → click Filter button above 'Period (calendar)',.
2. Choose fields that you want to filter:
  1. You can choose from the default fields on the left or you can;
  2. type in the Smart Filter Assistance field as well for better and faster search (You can search for a specific G/L Account, Company, Customer, Vendor, Etc.)
  3. For advanced filter option, click Add Filter → Open Selection Window → click Advanced button then choose available fields to filter.
3. Once done choosing fields to filter, run the report.

Note: You can hide Parameters/Filtered fields as well by clicking the   "Eyecon" on the left side, clicking the red "x" button will remove the filter.


Adding Filter in CustomBooks™ General Ledger Report

    • Related Articles

    • Can I add Salesperson on my Sales by Item Report?

      Yes. You can add Salesperson as a grouping field at the top level. Click More Actions → Advanced Settings. Click the grouping tab. Click Add. Choose the + sign next to Document. Highlight Salesperson. Click Add. Highlight the new field and click the ...

    • Report Packages

      Overview Report packages allow you to prepare and group multiple financial reports together and can deliver them via email. Reports that are available in packages include: Balance Sheet (comparitive)  Coming Soon! Balance Sheet (standard) General ...

    • Budget vs. Actual Report

      Overview The Budget vs. Actual Report will show budgeted amounts for each account included in the budget along with actual account totals for comparison purposes. Usage To run the Budget vs Actual report, Navigate to Reports / Budget vs Actual Report ...

    • How can I filter a list of invoices to only show those between certain dates?

      Invoices and other lists can be filtered by any field in the document. To illustrate: We'll use the example of a date range of January 1, 2024- May 31, 2024. 1) Start by clicking the More Actions → Settings button and choose Configure List. 2) In the ...

    • Assembly Bill of Materials Report

      Overview If you have ever wanted to see a quick look at what assemblies a product is used in, this report will do the trick.   Complete the steps below once and save,  and you can run the report whenever you need it.   The report will be grouped by ...