DOCUMENT Filter line item references function

This article describes the RPA Document functionality to filter statement line item references by an example pattern.

For a full list of available functions, please read DOCUMENT functions.

Description

The Filter line item references function cleans up extracted statement data by separating reference numbers from descriptions. You provide an example of what a valid reference looks like, and the function builds a pattern from it: digits in the example match any digit, letters match any letter.

For each line item in the statement:

• If the reference matches the pattern, it stays in the reference field
• If the reference does not match, it is moved to the front of the description field, and the reference field is cleared

How patterns work

Setting it up

To use the Filter line item references function, follow these instructions:

{{popups:rpas/add:action=statement-filter-reference}}

Once on a process map:

1. Navigate to the process where you would like to add the function
2. Click on the green button’s drop-down (right side of the green button labelled “Process”)
3. On the menu that appears, click on the “+ Activity” item
4. From here you can select the DOCUMENT Filter line item references option
5. Click "Add" once you are done

Input parameters

Output

The function modifies the statement data in place. After filtering:

• Line items with matching references keep their reference field unchanged
• Line items with non-matching references have the old reference prepended to description and reference is cleared

Errors

• Variable not found – the specified variable does not contain statement data
• Invalid pattern – the pattern example is empty

Tips

• Run this after extracting statement data to clean up references before reconciliation
• Use multiple filter steps with different patterns if statements contain mixed reference formats
• The pattern is case-sensitive for letters: 'PO' matches uppercase only. Use the exact case you expect.

Related functions

• Extract statement data
• Extract invoice data