Configuration settings for import/export

Configuration settings for import/export

In the menu section "Configuration Settings / Import/Export," you will find settings that apply to imports and exports from the Spend Cloud. For more information about configuration settings, refer to this article.

Make sure you understand what each setting does before making any changes. During the implementation of your Spend Cloud environment, you can always contact your Visma | ProActive Consultant for advice. If a module is already implemented, you can reach out to our support department for assistance.

Once you have made changes to a setting and clicked on "Save," you will need to log out and log back in to activate the changes. You do this by clicking on your name in the top right of the Spend Cloud, next you click on logout in the menu. When you log in again, the changes will be visible in your Spend Cloud environment. This also applicable for other users.

Below settings are currently available in Spend Cloud. Unfortunately, most settings cannot be changed by yourself. This is because there are many settings that only work in combination with a specific module, web service, or can even differ per configuration in the financial package. Our goal is to make as many settings as possible available for editing in the Spend Cloud. We will try to describe this as much as possible per setting.

085 - Store import results (Cannot be changed via the Spend Cloud)
When this setting is enabled, the reporting of an import can be consulted in the menu item. Currently only works for employee imports.

114 - Allow invalid SSL certificates for web services (Cannot be changed via the Spend Cloud)
This setting currently only works in combination with Exact Financials.

115 - Invoices including audit trail
When exporting invoices, you can choose whether or not to include the audit trail in the export. In the variant including the audit trail, an extra page is added to the PDF. Note: this variant does not work in combination with pre-registration because the audit trail is not yet complete. An exception to this is when it is used in combination with Visma.net Financials.

116 - Attachment of bookings
For exporting Cash & Card bookings, you can specify whether the attachment should be exported or not. Does not work in combination with all financial packages.

119 - Select another IBAN when encoding for export (Cannot be changed via the Spend Cloud)
This setting allows you to choose a different IBAN when encoding an invoice if multiple bank accounts have been specified for the relation. Does not work with all financial packages.

125 - Imports Organizational unit based on
For some imports, such as a role import, or cost center workflow import, a field for organizational unit is defined in the import definition. With this setting, you indicate whether the value in the import file contains the name or the number of the organizational unit.

126 - Default setting relations for XML invoices
When importing relations, you can use this setting to specify which setting should be chosen by default for processing XML invoices. The choice consists of grouping all invoice lines into one invoice line, taking over all lines from the XML, or a custom way. We recommend against the last option; it is best configured in the Spend Cloud itself, per relation. Read more about processing XML invoices here.

024 - Default setting for suppliers for receipt registration
When suppliers are created based on an import, you can specify here which setting should be chosen by default for receipt registration. The choice consists of no receipt registration, registering receipt of all orders, or only registering receipt above a certain amount.

127 - Description expiration date
If available, you can give a name to the field of the expiration date for cost centers and cost bearers.

128 - Error messages web service
Here you can specify to which email address error messages from the web service should be sent.

130, 153, 005, 006 - Web service settings in the foreground (Cannot be changed via the Spend Cloud)
These settings allow changes per web service through the Spend Cloud, enabling definition of matters per administration. Works only for Exact Online, AFAS, Allsolutions, and Visma.net Financials.

Below are web service-specific settings that can be changed upon request. For this, you can contact your implementation consultant or Support after implementation.


Accountview API (Visma)

164 - Export period in the header based on (Cannot be changed via the Spend Cloud)
Choice of invoice date or period.


Accountview webservice (Branchview)

108 - Add fiscal year to administration (Cannot be changed via the Spend Cloud)
If this setting is enabled, we add a year to the administration number during import/export to Accountview. This eliminates the need to adjust the administration number in Spend Cloud when transitioning to a new fiscal year.


AFAS Profit

029 - Set invoices to automatically payable (Cannot be changed via the Spend Cloud)
If this setting is enabled, exported invoices are immediately set to payable in AFAS. Invoices with payment condition AI (Automatische Incasso) are excluded.


Decade Webservice

015 - Unlock invoice header after pre-registration (Cannot be changed via the Spend Cloud)
This setting allows editing of the invoice header after it has been pre-registered in Decade.


Exact Globe

039, 040, 041, 042, 043 - Export invoice and reporting dates (Cannot be changed via the Spend Cloud)
These settings determine whether certain invoice or reporting dates include the invoice date or period. Can be set for both header and lines.

046 - Pre-registered invoices for invoices in transit export (Cannot be changed via the Spend Cloud)
This setting determines whether pre-registered invoices should be included in an invoices in transit export or not.

007 - Extended relation export (Cannot be changed via the Spend Cloud)
If relations are created in Spend Cloud with Exact Globe, this setting can be enabled to export more fields of a new relationship to Exact. New files need to be added to the web service on the server where Exact Globe runs. Contact support for assistance.


Exact Online

138, 139 - Base header and/or line period on export on (Cannot be changed via the Spend Cloud)
Choice of invoice date or period.


Twinfield

166 - Export header period based on (Cannot be changed via the Spend Cloud)
Choice of invoice date or period.

095 - Transaction status (Cannot be changed via the Spend Cloud)
Determines the status of the invoice when exporting to Twinfield. Choice of temporary or permanent.


Unit4 Multivers API Webservice

091 - Export TransactionDate based on (Cannot be changed via the Spend Cloud)
Choice of invoice date or period.


Visma.net Financials

027 - Export header period based on (Cannot be changed via the Spend Cloud)
Choice of invoice date or period.

153 - Use code 'Flex' as period distribution code (Cannot be changed via the Spend Cloud)
When this setting is enabled, we default to the code 'Flex' when a invoice needs to be divided over multiple periods. Prior changes need to be made in Visma.net, you can read more about this on Visma's website. https://community.visma.com/t5/Nieuws-in-Visma-net-ERP/8-21-Transitorisch-verdelen-op-basis-van-een-datum-bereik/ba-p/295031


140 - G-accounts (Cannot be changed via the Spend Cloud)
These settings allow working with G-accounts in combination with Visma.net Financials.

    • Related Articles

    • Retrieving scans externally

      Scans can be retrieved by constructing a link (URL). This link has a limited validity period to minimize the risk of unauthorized access to the scans. For customers that are migrated to our new tex trecognition technology Smartscan for PDF invoices: ...