This chapter describes the use of the export module for ABN AMRO Bank. This module can be used to create export files that contain debtor and invoice information in the format expected by ABN AMRO Bank. The following topics are covered:
Menu items: 'Export', 'ABN AMRO Bank'
Use the menu options mentioned above to open the export module for ABN AMRO Bank.
When the export module is opened, it is suggested to import the latest financial information. Always import this information if new entries were entered into the accounting package since the last time that information was imported into d-basics.
The following initial configuration is required:
•Export directory
The export directory is the location where export files will be saved. The default location is: 'c:\export'. To select a different location, push the 
button at the end of the text box and browse to the desired location.
•Company information
The following information is needed to identify the sender of export files:
• ABN AMRO Bank account number (four numbers)
•Select export files
In case of ABN AMRO Bank, d-basics creates the following export files:
1) Outstanding amounts
If the option outstanding amounts is selected the following export files will be created:
•A file containing debtor information
•A file containing outstanding items
•Connection settings
D-basics can automatically send the export files to ABN AMRO Bank. To use this option, enter the following connection settings:
•Send files automatically
If this option is checked, d-basics will automatically send the export files to ABN AMRO Bank after they have been created (using the ABN AMRO Bank webservice).
•Username and password
Enter the same username and password as used to logon to the ABN AMRO Bank (Speedata) website (these are provided by ABN AMRO Bank).
Notes: •The 'Test' button can be used to check the connection with the ABN AMRO Bank webservice •If an error occurs during the automatic upload, try to send the files manually before contacting the d-basics helpdesk. If an error also occurs during the manual upload, there might be something wrong with the internet connection or the ABN AMRO Bank (Speedata) website. •The Speedata password must be changed monthly. If the Speedata website is used to change the password, the password used by d-basics must be replaced by the new password manually. |
•Proxy settings
If a Proxy server is used to manage internet access d-basics can only send files to the ABN AMRO Bank webservice after the proper proxy settings have been entered. Also see the paragraph "Internet settings".
III. Creating and sending export files
To create export files, the following steps must be completed:
Step 1: Send all debtors
By default only the (address) information of debtors with outstanding amounts is sent to ABN AMRO Bank. If the option "send all debtors" is selected, the information of all debtors - except of those who have been excluded through filtering - will be sent.
Step 2: Setting filters
Filters can be used to exclude information from export files. For more information see paragraph 'Using filters'.
Step 3: Creating export files
Push 'Start' to create export files. Before export files are actually created, d-basics performs the following checks:
•Are all required parameters set?
Required parameters that are missing or not entered correct are displayed in red. In order to proceed, the correct values must be entered.
•Are the country, language and currency codes matched to the corresponding ISO codes?
If the country, language or currency codes that are used in the accounting package are not compliant with the international ISO standard, these codes must be linked to the matching ISO codes before export files can be created. For more information also see 'Match ISO codes'.
Notes: •Each time export files are created, d-basics checks whether all codes that are used in the accounting package are linked to the matching ISO codes. D-basics cannot create export files until all codes are linked with the matching ISO codes. •It is possible to schedule import and export actions. For more information see 'Automatic import and export'. |
Step 4: Sending export files to ABN AMRO Bank
The export files created by d-basics must be uploaded to ABN AMRO Bank by means of the ABN AMRO Bank (Speedata) website. If the option to send files automatically is selected this will be carried out after the export files have been created. If the option is not selected, the transmission can be initiated by pushing the 'Send' button.
Step 5: summary and Log
After creating export files, the proceedings of d-basics can be reviewed:
•Summary
The second tab of the Export module shows a summary of the information that was retrieved from the ledger (administration) in the accounting package.
•Log
The third tab of the Export module shows the export log. The export log gives a summary of the events that took place during the import and export of information.
See the appendix 'Events log file' for an explanation of the events mentioned in the export log.
Notes: •Most of the errors mentioned in the log file can be fixed by changing the information in the ledger (administration) in the accounting package. •'Error- and Truncate events are only registered if the corresponding checkbox is checked. It is recommended only to use this feature for debugging purposes, since it has a negative impact on the performance of d-basics. |