Tips and tricks for creating filters on the Pay AP purchase invoices page
Unless you configured Accounts Payable to display all ready-to-pay AP purchase invoices, AP purchase invoices will not load until you apply a filter.
You can filter on-the-fly using common filters that we've bubbled up to the Pay AP purchase invoices page, or create a filter set. Each time you access Pay AP purchase invoices, just select your filter set from the Filter by dropdown and select Apply filters.
Need to see all your AP purchase invoices at once? If you have less than 1000 AP purchase invoices to pay, this is possible by creating a filter that includes all AP purchase invoices, such as a filter for suppliers with names A through Z.
However, Intacct only displays a maximum of 1000 AP purchase invoices, so it's possible you won't see all available AP purchase invoices if you have more than 1000 AP purchase invoices. You can create more specific filters or create payment requests for AP purchase invoices and run the filter again.
Filter based on AP purchase invoice characteristics
Filter for AP purchase invoices with the nearest upcoming deadline to be paid.
- On the Pay AP purchase invoices page, select the Filter by dropdown and select Add a filter set.
- Add a Name for your filter.
- In the Due date range dropdown, select This week or This month.
- Select Save.
- On the Pay AP purchase invoices page, select the Filter by dropdown and select Add a filter set.
- Add a Name for your filter.
- In the Due date range dropdown, select Past due.
- Select Save.
- On the Pay AP purchase invoices page, select the Filter by dropdown and select Add a filter set.
- Add a Name for your filter.
- In the AP purchase invoice payment priority dropdown, make your selection. You can filter for Urgent, High, Normal, or Low-priority AP purchase invoices.
- Select Save.
- On the Pay AP purchase invoices page, select the Filter by dropdown and select Add a filter set.
- Add a Name for your filter.
- In the Drill down filters section, select or enter the following values
Object: Supplier
Attribute:Supplier name
Operator: Equals
Value: Enter the name of the supplier
- Select Save.
For example, create two filters: Suppliers A-L, and Suppliers M-Z.
- On the Pay AP purchase invoices page, select the Filter by dropdown and select Add a filter set.
- Add a Name for your filter, such as Suppliers A-L.
- In the Drill down filters section, select or enter the following values:
Object: Supplier
Attribute:Supplier name
Operator: Less than
Value: M
- Optionally, sort the list by ascending supplier name.
In the Sort by section, select Supplier name as the Attribute and Ascending for the Order.
- Select Save.
- On the Pay AP purchase invoices page, select the Filter by dropdown and select Add a filter set.
- On the Advanced filters page, give your filter set a name such as Partially paid AP purchase invoices.
- In the Drill down filters section, select or enter the following values:
- Object: AP purchase invoice
- Attribute: State
- Operator: equals
- Value: Partially Paid
- Select Save.
Filter based on payment method
- On the Pay AP purchase invoices page, select the Filter by dropdown and select Add a filter set.
- Add a Name for your filter, such as Preferred payment method.
- In the Drill down filters section, select or enter the following values:
Object: Supplier
Attribute: Preferred payment method
Operator: Equals
Value: Select the desired payment method.
- Select Save.
Filter based on entities
- On the Pay AP purchase invoices page, select the Filter by dropdown and select Add a filter set.
- Add a Name for your filter.
- Select the Show top-level transactions checkbox.
- Select Save.
- On the Pay AP purchase invoices page at the top level, select a filter and select Edit filter, or select Add a filter set.
The Advanced filters page appears.
- Select Select under Entities to pay.
The multi-select box enables you to view and select from the list of entities that have a defined business relationship.
- Do one of the following:
- Select Add all to include all entities in your filter, then select Done.
- Select the arrow beside each entity that you want to add to the filter, then select Done.
The number of selected entities appears under Entities to pay. You can edit this selection anytime. After you apply the filter, the resulting list includes AP purchase invoice line items associated with the selected entities.
You can hold off on paying AP purchase invoices for specific entities that do not have the resources yet to pay in full.
- On the Pay AP purchase invoices page at the top level, select Pay by entity at the top of the page.
- Check the Select entities with ability to pay all AP purchase invoices in full checkbox.
- Select Apply filter.
- On the Pay AP purchase invoices page at the top level, select a filter and select Edit filter.
The Advanced filters page appears.
- Select one of the following:
- Include: Include AP purchase invoices that have multi-entity line items so long as one line item meets the criteria.
- Exclude: exclude AP purchase invoices that have multi-entity line items even though one or more line items meet the criteria.
- Only: show only AP purchase invoices that have multi-entity line items; AP purchase invoices with multiple line items for the same entity are excluded.
Add sort criteria to an advanced filter
- On the Pay AP purchase invoices page, select the Filter by dropdown menu and select the appropriate filter.
- Select Edit filters.
The Advanced filters page appears.
- In the Sort by section, select Due date in the Attribute field.
- Select Ascending in the Order field.
- Save the filter set.
The Pay AP purchase invoices page appears.
- Select Apply filter.
Intacct applies the filter and sorts the list of AP purchase invoices by due date, showing the oldest due date at the top.
- On the Pay AP purchase invoices page, select the Filter by dropdown menu and select the appropriate filter.
- Select Edit filters.
The Advanced filters page appears.
- In the Sort by section, select Supplier name in the Attribute field.
- Select Ascending in the Order field.
- Save the filter set.
The Pay AP purchase invoices page appears.
- Select Apply filter.
Intacct applies the filter and sorts the list of AP purchase invoices alphabetically, by supplier name.