Sage Partners
Connect on Twitter
  • Home
  • Find a Reseller
    • By Location >
      • U.S. Partners
      • Canada Partners
    • By Sage Product >
      • Sage ERP Partners >
        • Sage 50 Partners
        • Sage 100 Partners
        • Sage 300 Partners
        • Sage 500 Partners
        • Sage X3 Partners
        • Sage Intacct Partners
      • Sage Construction Partners >
        • Sage 100 Contractor (Partners)
        • Sage 300 Construction (Partners)
      • Other >
        • Sage CRM Partners
        • Sage HRMS Partners
        • MIP Fund Accounting
  • Sage Product Info
    • Sage 50
    • Sage 100 >
      • Sage 100 Tips & Tricks
      • Sage 100 System Requirements
    • Sage 300 >
      • Sage 300 Installation Guides
    • Sage Intacct
    • Sage 500
    • Sage X3
    • Sage Construction >
      • Sage 100 Contractor
      • Sage 300 Construction
      • Sage Estimating
    • Other Sage Products >
      • Sage Fixed Assets >
        • Sage Fixed Assets User Guides
      • Sage CRM
      • Sage HRMS >
        • Sage HRMS System Requirements
  • Sage Add Ons
  • Resources
    • Blog
    • Popular Articles
    • Buying Guides >
      • Inventory Management Tips
      • ERP Implementation Failure
  • Contact Us

Creating Customized Filtered List Views in Sage Intacct

3/8/2019

0 Comments

 
Sage Intacct Filtered Lists
There are times when it's useful to view financial information – such as transactions or records – in a list format.  That's where the Lists feature in Sage Intacct comes in, enabling you to sort, filter, and even create new lists to view only the items that are most important to you. Let's take a closer look at how to create customized filtered list views in Sage Intacct.

How to Filter Lists

There are two ways to filter lists in Sage Intacct. Here's a look at both.

Filter Based on a Specific Value
  1. In the text field above the column that contains the value, enter the first part of the value. For example, if the value begins with “San” type San to include records with a value for this column of San Jose, San Francisco, Santa Fe, and so on.
  2. Enter % and then a portion of the value to view all items containing that portion of the value. For example, if you wanted to search for all June summaries, you would enter %June in the field at the top of the Summary column.
  3. Click Go beside the field and the system will display the line items that match the text you entered.

Use Advanced Filters to Apply Standard Operators to Columns
  1. Go to the list screen that you’d like to apply to filter
  2. Click Advanced filters
  3. Select the appropriate Column
  4. Under Operator, select a standard operator (equals, less than, greater than, etc.)
  5. Under Value, enter a specific value for the column (one per filter row)
  6. Add your criteria for a specific list view
  7. Click Apply in the Advanced Filters box
Intacct Avanced Filters Screen
Click to Zoom and Enlarge Image

Displaying Your Lists Through Custom Views

In Sage Intacct, a View refers to the way a list is arranged, filtered, and sorted. While the software provides standard views for displaying list items, you also have the flexibility to create your own custom views. Here’s are a few ways you can do that.

Filter for Recent Records
  1. Click the down arrow near the View menu
  2. Click Recently Viewed, Recently Modified, or All Recently Modified
  3. Return to a view of all records by clicking the down arrow again and selecting All

Intacct Customer Filter Screen
Add a Custom View (Based on an Existing View)
  1. Under View, select the view you want to use as a base
  2. Under Manage views, click Save View As
  3. In View Name, type a unique name
  4. Click Save

Add a New Custom View
  1. Under Manage views, click Create New View
  2. Follow the wizard steps to set up the view

Edit a Custom View
  1. Under View, select the custom view
  2. Under Manage views, click Edit

Delete a Custom View
  1. Go to Customization Services
  2. Click Custom Views
  3. Locate the row with the view you want to delete and click Delete

Exporting and Printing Your Lists

Need to print a list of a standard or custom view? Looking to export a list to an external application file like Word, PDF, CSV, or Excel? Sage Intacct makes it easy.

To Export a List:
Click Export at the top of the screen and then Select the file type.

To Print a List:
In the list screen, click the Export button or CSV link, then Print the file using the external application’s Print feature.
Guest Article by ACI Consulting
This article is a guest blog post provided by ACI Consulting.  Proudly serving Sage software clients for over 20 years, ACI Consulting provides Intacct Consulting in Orange County and throughout Southern California.
ACI Consulting logo
Contact ACI
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    ARE YOU A SAGE PARTNER?

    Get Your Business Listed Here!

    Click below if you're interested in having your business listed in this online directory of Sage Partners.
    Get Started
    Sage Warehouse Management
    Scanforce WMS for Sage
    Sage Cloud Hosting
    Picture

    Popular Articles

    Big Bang Implementation vs Phased Approach
    (Pros, Cons)

    ---
    What's New in
    Sage 100 2022

    ---
    What's New in
    Sage 300 2023

    ---
    New Release:
    Sage Intacct 2022

    ---
    What Does ERP Stand For?
    ---
    Sage 100 System Requirements and installation Guide
    ---
    Sage 300 Installation Guide
    ---
    Sage 100 Tips & Tricks

©2023 Top-Sage-Resellers.com. All rights reserved. This material and content on this website may not be reproduced, displayed, modified or distributed without the express prior written permission of the copyright holder. This website is not owned, operated, affiliated with, or endorsed by Sage Software, Inc. or Sage Intacct, Inc. Sage, Sage logos, and Sage product names mentioned herein are registered trademarks or trademarks of Sage Software, Inc. and/or its affiliates. Other product names mentioned are trademarks of their respective owners.
Privacy Policy