How to Set Up the Receivable Routing Filter for Business Central

Use the Receivable routing filter so Paystand only syncs the Microsoft Dynamics 365 Business Central invoices that match your AR rules — for example cash-only Project Type, or every department except one ACH-only code.

Important: The filter is off by default. Configure it on Integrations → Business Central. Prefer enabling it before the first sync when you want non-matching invoices never to enter Paystand.

Related: Receivable Routing Filter for Business Central · Business Central Dimensions in Paystand.


Before you start

  • Your Paystand account is connected to Business Central (or you are finishing connection on Integrations).
  • Your Business Central environment has the current Paystand extension. See How to Keep the Paystand Extension Updated in Business Central.
  • You know which dimension code on the invoice header should drive routing (for example Project Type or Department). Line-only dimensions are not used.
  • You know whether you need an Allow list (small “good” set) or an Exclude list (small “bad” set).
  • You have access to update Integrations in the Paystand Dashboard.

Coming soon — before you enable hide on live data

Paystand is finishing work so hidden receivables are also blocked from checkout, the payer portal, autopay, and related totals.

Target ship date: Monday, October 5, 2026, by end of day. After that release, hidden receivables will no longer be payable or counted on those surfaces.

Until that update ships:

  • You can still set up dimension values in Business Central, configure the filter, and use Check impact.
  • If receivables are already in Paystand, do not treat soft-exclude / hard-hide as a complete payment stop yet.
  • Safest path for go-live: finish BC dimension placement, configure the filter, and enable it so the first sync already respects the rules.

1. Open the Receivable routing filter

  1. Sign in to the Paystand Dashboard.
  2. Open Integrations.
  3. Select your Business Central connection.
  4. Scroll to Receivable routing filter.

Integrations Business Central page with Receivable routing filter card off

The routing filter sits on the same Integrations page as Customer sync filters.


2. Enable the filter and choose a dimension

  1. Turn on Enable receivable routing filter.
  2. Under Dimension code, select the Business Central dimension that should drive routing.
  3. Under Dimension values to include (Allow list) or Dimension values to exclude (Exclude list), add each value as a chip (a small rounded tag in the field), not as plain typed text alone.

How to add a dimension value correctly

  1. Click inside the dimension values text box so the cursor is in the field.
  2. Select a value from the dropdown, or type the value (for example CASH).
  3. With the cursor still inside the text box, press Enter (or click the matching dropdown option) so the text transforms into a chip. The placeholder text is Select or type a value, Enter to add.
  4. If you need more than one value, add them one at a time: type or select the next value, press Enter again, and confirm a new chip appears. Do not type several values in one string.
  5. Repeat until every value you need shows as its own chip.

Dimension values field showing CASH as a blue chip tag

Example: CASH saved correctly as a chip. Plain text in the box without a chip is not part of the filter.

Important: If the value still looks like editable text in the box and you do not see a chip, it is not part of the filter yet. Check impact and Save filter ignore uncommitted typed text. After Save, that text can disappear and the allow/exclude list stays empty.

Pick any dimension code that appears on the invoice header dimension set. You do not need to change Global Dimensions 1 or 2 in Business Central if your code already posts to the header (for example as a shortcut dimension).


3. Choose Allow list or Exclude list

  1. Select Allow list to sync only the selected values. Invoices with no value for this dimension do not sync. Already-synced receivables that do not match are hidden when you save.
  2. Or select Exclude list to sync everything except the selected values. Invoices with no value still sync. Soft exclude (available in this mode only) can leave already-synced matching invoices alone.
  3. Optional: turn on Use customer default when missing on invoice so Paystand can read the customer card’s Default Dimension when the invoice header has no value.

Allow list mode with dimension, values, and Check impact preview

Allow list example with Check impact before Save.


4. Soft exclude (Exclude list only)

  1. If you use Exclude list, leave Soft exclude (recommended) on unless you intend a full cutover.
  2. Soft exclude stops new matching invoices from syncing but leaves already-synced matching invoices visible.
  3. Turning Soft exclude off (hard exclude) hides already-synced matching invoices from the merchant Receivables list. Prefer Soft exclude unless you deliberately want that cutover.

Exclude list mode with Soft exclude recommended toggle

Soft exclude is recommended when you only want to block future syncs.


5. Check impact and save

  1. Confirm every intended dimension value appears as a chip before you continue. If Check impact warns that the allow list (or exclude list) is empty, go back and press Enter inside the values box to add each value.
  2. If receivables already exist in Paystand, select Check impact and review how many would remain vs be hidden.
  3. If nothing has synced yet, Paystand notes that rules apply to the first sync; impact preview is available after receivables exist.
  4. Select Save filter.
  5. Use Discard changes if you need to revert an unsaved draft.

Connected Business Central Integrations page with routing filter active and Check impact

After connect, you can edit routing rules anytime; Check impact uses live open receivables.


Verify

  1. Confirm the filter shows enabled with the expected dimension code, mode, and value chips (not an empty values field).
  2. After the next sync (or first sync), open Receivables and confirm only expected invoices appear.
  3. In Business Central, spot-check that excluded (or non-allowed) posted sales invoices are the ones that should stay out of Paystand collections.

Troubleshooting

I typed a dimension value, but it disappeared after Save (or Check impact says the list is empty)

  1. The value was not added as a chip. Typing alone does not commit the value. With the cursor inside the values text box, press Enter so the text becomes a chip. Check impact and Save only use values that appear as chips.
    Fix: Click inside the values field, type or select the value, press Enter, confirm the chip appears, run Check impact again, then Save filter.
  2. You need multiple values. Add each value separately (type or select → Enter → chip), then continue with the next one.
    Fix: Do not paste or type a comma-separated list. Create one chip per value.
  3. Check impact warned that the allow list (or exclude list) is empty. That means no chips were saved yet.
    Fix: Add chips first, then Check impact and Save. Do not rely on plain text left in the input box.

The Receivable routing filter card is missing

  1. The Business Central connection is not available. Confirm Integrations shows Business Central as connected or in progress.
    Fix: Complete connection, then refresh the page.
  2. Your extension is out of date. Update the Paystand Business Central extension, then reload Integrations.

Unexpected invoices still sync

  1. The dimension is only on invoice lines. Paystand evaluates the header dimension set only.
    Fix: Work with your BC partner so the dimension posts to the sales invoice header.
  2. Allow list with blank values. Untagged invoices do not sync in Allow list mode. Confirm customer defaults if you rely on fallback.
  3. Allow list chips were never saved. If the values field looks empty after reload, the filter may be enabled with an empty list, so every invoice can still sync (or nothing new syncs, depending on mode).
    Fix: Re-add values as chips, Check impact, and Save.
  4. Exclude list with Soft exclude on. Already-synced matches can remain visible by design.
    Fix: Use Soft exclude off only if you intend to hide them from the merchant list (and wait for payment-surface coverage described above).

Save filter stays disabled

  1. No dimension code selected while the filter is on.
    Fix: Choose a dimension code, run Check impact when required, then save.
  2. Impact is stale after you changed values.
    Fix: Run Check impact again for the current draft, then save.

Still need help?

Contact Paystand Support or your Customer Success Manager. Include:

  • Your Business Central company name
  • The dimension code and allow/exclude values
  • Whether the filter is enabled before or after first sync
  • A screenshot of the Receivable routing filter card and Check impact results

Last updated: October 2026 · Microsoft Dynamics 365 Business Central · Receivable routing filter

Was this article helpful?
0 out of 0 found this helpful