Imports debtor categories into Sapera, creating or updating each category with its default accounts, terms and settings.
How to use the action
1. Select the action in the Action field. 2. Point to your data source – a file (CSV or Excel) or a SQL query. 3. Map the source columns to Sapera's fields in the column mapping (see Source fields below). 4. Run Compare to see what will be created, changed or stay unchanged – without writing to Sapera. 5. Run Update Sapera to perform the import.
Use the Allow create and Allow update parameters to control whether new rows are created and whether existing ones are updated.
How matching and updating works
Each row is matched on the category's system name (SystemName). Matching categories are updated and new ones created – with their default accounts, terms and settings. Direction: from file/SQL into Sapera.
Key parameters
Parameter | Explanation |
AllowCreate | When enabled, debtor categories that do not yet exist are created. |
AllowUpdate | When enabled, existing debtor categories are updated with the imported values. |
Source fields
Field | Explanation |
AccountNumber | Default financial account number for the debtor category. |
CreditLimit | Default credit limit for debtors in the category. |
CurrencyCode | Default currency code for the debtor category. |
DefaultPriceType | Default price type applied to debtors in the category. |
DiscountAccountNumber | Discount account for sales to customers in the category. Used instead of the product's discount account. Set for the department you are logged into. |
DiscountAccountWithoutVatNumber | Like DiscountAccountNumber, but for sales without VAT. |
DisplayName | Display name of the debtor category. |
ExemptVat | Whether debtors in the category are exempt from VAT. |
IsContactPersonRequired | Whether a contact person is required for debtors in the category. |
IsCustomerReferenceRequired | Whether a customer reference is required for debtors in the category. |
IsRequestorRequired | Whether a requestor is required for debtors in the category. |
PaymentTerms | Default payment terms for the debtor category. |
ReminderFeeAccountNumber | Financial account number used for reminder fees. |
SalesAccountNumber | Sales account for sales to customers in the category. Used instead of the sales account on the product's category. Set for the department you are logged into, so a department can have its own. For all six sales and discount account columns: an empty cell clears the account, and an account number Sapera does not know gives a warning and leaves the account alone. |
SalesAccountWithoutVatNumber | Like SalesAccountNumber, but for sales without VAT. |
ServiceSalesAccountNumber | Sales account for sales of service products (e.g. hours) to customers in the category. Takes precedence over the Service sales account on the product's category. |
ServiceSalesAccountWithoutVatNumber | Like ServiceSalesAccountNumber, but for sales without VAT. |
SupportEan | Whether the category supports EAN invoicing. |
SupportEmail | Whether the category supports sending documents by email. |
SupportInvoicingByEmail | Whether the category supports sending invoices by email. |
SupportPrint | Whether the category supports printed documents. |
SuppressReminder | Whether reminders are suppressed for debtors in the category. |
SystemName | Unique system name identifying the debtor category. |
See also the overview SyncTool – actions.
Want to know more?
Read more in these related articles:
Standard parameters for all actions
The general parameters available on most SyncTool actions: step control, error handling, timeout, etc.

