Sage X3 - Advanced Selection Option - Aptus Business Solutions
Aptus Business Solutions specialise in delivery and supporting solutions for Sage X3, Sage 300, Sage CRM and Sage Intacct. With over 30 years of knowledge, we have been supporting clients from around Australia and internationally. We cater to businesses of all sizes and business areas. Our services, support and business systems understanding enable clients to succeed and grow in their industry. We cover all aspects of system design, business processes, consultancy, hosting and IT, development and systems integration.
ERP, Consultants, Sage, Finance Management, Accounts Management, Sage 300, Sage X3, Sage Intacct, Sage Enterprise Manager, Sage CRM, Finance software, Accounts software, Business Solutions, Business Systems
post-template-default,single,single-post,postid-16183,single-format-standard,ajax_fade,page_not_loaded,,side_area_uncovered_from_content,transparent_content,qode-child-theme-ver-1.0.0,qode-theme-ver-16.7,qode-theme-bridge,wpb-js-composer js-comp-ver-5.5.2,vc_responsive

Sage X3 – Advanced Selection Option


Sage X3 – Advanced Selection Option

Getting more out of Advanced Selections

How to Use Advanced Selections to Speed Up Finding Data

The advanced selection option can be used to create custom filters which can be saved and reused.  This helps users quickly filter the left list to reduce the amount of data and make it easier to locate the information they are searching for.

The best way to understand this is to use an example.  Lets take a look at how to filter all the Invoices that have been entered Today in the Purchase Invoices Screen,

  1. Goto Purchases >Invoices>Invoices
  2. Click Advanced Selection
  3. Enter the following into the ” Expression Field”[F:PIH]CREDAT=date$
  4. To save the Advanced Selection for later use click on Memo and give it a code and description.
  5. Click OK
  6. When you close the Purchase Invoice Screen and go back in you will now see”Todays Entries”on the list
  7. When you click on it the Left list will now be filtered to show only invoices entered today.
  8. To clear the filters and see All Invoices click on “All”

Another Great one is to replace the expression with

[F:PIH]CREDAT=date$ and [F:PIH]CREUSR= GUSER     this will create the filter for Date/User


Some other great tips are

  • If marked as Global all user will be able to use this advanced selection
  • If an Advanced Selection is Saved as name “STD” this will be the default filter applied when you access the screen.

Contact us at for further information.[/vc_column_text][/vc_column][/vc_row]

Example of Filtering Purchase Invoices by Create Date

Todays date


Want to know more!