User RolesAdminStaff contributor✗ External Contributor✗ Pulse user

This article explains how to configure your AFAS GetConnectors to group customer and supplier accounts. This way, all amounts are sent to Silverfin as a single total account.


Table of contents

Situation without filters

By default, the AFAS API sends each customer and supplier separately to Silverfin. As a result, you will see multiple accounts, which can make your reporting less clear.

Example:

If your file contains three customers and two suppliers, you will see the following accounts in Silverfin:

  • 400001 Customer A
  • 400002 Customer B
  • 400003 Customer C
  • 440001 Supplier Y
  • 440002 Supplier Z

In this case, no total account for all customers or suppliers is available.

Situation with filters

By applying custom filters to your GetConnectors in AFAS, you can structure the data so that all customers are combined into one total account, and the same applies to suppliers.

This allows the amounts from individual customers and suppliers to be sent as grouped total accounts in Silverfin.

  • 400000 Customers
  • 440000 Suppliers

How to set this up?

Apply the following filters in the GetConnector settings in AFAS.


GetconnectorActions
Silverfin_openstaande posten debiteuren
Filter what you do not want to send to Silverfin. Advised to send nothing.
Silverfin_GrootboekrekeningenAdd the fields “subrekening crediteur” & “subrekening debiteur” and make them empty by turning the visibility off.


For more details on how to build GetConnectors and apply filters in AFAS, you can refer to the following Dutch AFAS articles:

Ingebouwd filter in GetConnector

GetConnector Bouwen en testen