1.Introduction

This is the manual for the integration between Magento and AFAS.

The integration ensures that invoices from the Magento webshop are processed to orders or financial entries in AFAS. Because the invoices enter the merchant's accounting system directly, it saves time on financial administration.

Please pay special attention to the following
The integration is working for these versions of Magento: FAQ - Magento versions. The integration is a basic integration. Magento has many options in the standard version that the integration does not support. In particular, these are:
  1. Reading shipping addresses. We do have an option for this, but it needs to be programmed on the Magento webshop side.
  2. Reading payment costs. We do have an option for this, but it needs to be programmed on the Magento webshop side.
  3. Adding discounts excl. VAT. The integration does not support this.
  4. Adding credit amounts - adjustments - in credit invoices. The integration cannot process this because the VAT information is missing.
  5. In some situations, the VAT of free items cannot be determined correctly.
  6. In some situations, the VAT percentage does not come through correctly from the Magento webshop. This often happens with smaller amounts and/or large quantities. Magento webshops pass on amounts in 2 decimals, not 4. This causes rounding differences. These invoices will have to be entered manually in AFAS.
  7. We will supplement this list if we notice that more items are missing.
This integration is a financial integration. It is not a logistical integration. The integration is not suitable for updating customers in AFAS, printing packing slips or synchronizing products/stock. Also, establishing the connection with OAuth can be difficult and we often cannot resolve this on our end.
This integration does not replace the work of an accountant. It saves time because you no longer have to retype documents. The accountant is still needed for advice, expertise, and control.
  • It is possible to process to AFAS sales orders, but there are restrictions. For example, new products are placed in item group 900 by default, VAT type 1 is used for low VAT and VAT type 2 for high VAT in new products.

    Tip: Other customers using this integration found the tips in the FAQ for Magento and in the FAQ for AFAS.

    Read more Introduction .... Read less Introduction ....
  • Install integration
    Installing the integration starts with signing up for a trial period, via our integrations page. After registration, you will receive an email containing an installation URL and login details. With this installation URL, you start the installation of the integration.
    The installation is complete when both connection dots are green, and the settings in the Configuration tab have been entered and saved.
    There is a trial period of 30 days.
    If you want to install another integration, you can do so in the same way. Make sure you are logged out of the integration dashboard and preferably start the new installation in an incognito browser.

    Cancel integration
    At the end of the trial or subscription period, the integration will not be automatically renewed. You will receive an offer for a one-year subscription or renewal by email at the end of this period. You can confirm the renewal by using the payment link in that email. Do you want to terminate the integration in the meantime? Please send us an email with the request and the license key. We can only stop integrations for you as of the current date, not on a future date.
    Are you switching to another web shop/accounting system and do you want to re-establish a connection? In this faq we explain how to do this.
    We advise you to deactivate the OAuth keys of the integration in your Magento webshop when uninstalling the integration.

    2.How the integration works

    A invoice from the Magento webshop is processed to a AFAS order or financial entry.

    Invoices are retrieved from the Magento webshop once per hour. This integration processes Magento invoices, not Magento orders. The integration works for both Magento 1.9 and Magento 2.x webshops, starting from Magento 2.1. Therefore, we do not support Magento 2.0.
    Read more How the integration works .... Read less How the integration works ....

    Pre-check
    At the start of processing an invoice, we perform a number of checks on the Magento invoice:
    • It is checked whether the total of the Magento invoice is equal to the sum of the amounts in the invoice lines.
    • If the invoice is an ICP invoice, the VAT number is checked.
    • It is checked whether a corresponding VAT code exists in AFAS for the VAT in each line.
    • It is checked whether the invoice has not already been processed.

    Processing invoices
    Processing a Magento invoice to AFAS takes place in three steps:
    1. It is checked if the customer already exists in AFAS. If not, the customer is created. Matching is based on the email address.
    2. When processing to AFAS orders, it is checked whether the products from the Magento invoice are already present in AFAS. Missing products are created.
    3. The AFAS order or financial entry is created and added.

    Post-check
    After the invoice has been forwarded and a success message from AFAS has been received, the invoice is marked as completed. The Magento invoice appears in the Report tab on the dashboard.

    If AFAS returns an error while processing the invoice, the invoice appears in the Errors tab on the dashboard. Via the yellow button More info more information about the problem can be found. Via the red button Report problem can the invoice with all necessary information easily be submitted to us after you have tried to resolve the problem yourself. If the problem is solved, in some cases the invoices can be processed again with the blue Process button.

    Data
    Information about the data that is processed can be found in the section Day-to-day: To AFAS later in the manual.

    3.Required: Magento keys - only Magento 1.x

    This step is only necessary for Magento 1.x. If you have a Magento 2.x webshop, you can skip this chapter!

    Read more Required Magento 1.x ....
    Read less Required Magento 1.x ....
    To establish the connection with Magento 1.9 webshops, an extension must first be added, and then a consumer key and secret must be created.

    3.1 Install extension

    Installing and configuring the extension for Magento 1.x consists of the following steps:

    First, check if your Magento webshop environment allows the use of the REST API. This check consists of the following steps. We use www.jouwwebwinkel.nl as the URL of your webshop.

    (i) Is the REST API accessible? You can test this with the url http://www.jouwwebwinkel.nl/api/rest/products. Do you see a 403 appear on your screen? Fine. But …

    (ii) … do you see a 404-screen?

    Then the URL is redirected to an error page. This could be a problem with the .htaccess file. The line RewriteRule ^api/rest api.php?type=rest [QSA,L] must be present in this file. If not, you need to add it.

    The problem could also be caused by a setting in the Apache web server. See this link for more information: http://magento.stackexchange.com/questions/29936/rest-api-returns-404.

    (iii) Does the username you used to create the OAUTH keys have admin rights? That is actually necessary, otherwise the data cannot be retrieved from the webshop.

    (iv) Do you use php-fpm fastcgi in the hosting environment? In that case, the authorization keys may not be transmitted correctly. This link contains more information: http://www.magentogeek.com/magento-rest-api-solution-for-400-bad-request/. This applies, among other things, to webshops hosted at byte.nl - shared hosting. They have a good explanation to solve this.

    (v) In all cases: Contact us if you can't figure it out. We sometimes see details in our log files that might help you resolve the problems.

    1. Turn off caching in your webshop. You can do this via System > Cache Management. After installing the extension, you can turn caching back on.

    2. Install extension. Unzip the file and install the files under your Magento root. You can see from the structure of the zip file where to place which files. No files will be overwritten.

    3. Define the REST Role. You first define a so-called Role that can read the invoice details, including tax rates and payment methods, from your webshop. To do this, go to System > Web Services > REST Roles. To use the extension, you need to create a Role of type Administrator. You create this by clicking Add Admin Role. If you already have one, you can reuse that Role.

    Plaatje Magento REST Role aanmaken

    On the left side of the screen is a screen titled Role Information. Click on the sub-menu link Role API Resources. You will see the option REST API Calls to read invoices appear. Check all the boxes under this option and save the details.

    Installatie extensie Magento

    You have now configured the integration to have the right to read the invoices, tax rates, and payment methods entities from Magento, but you have not yet specified which data it is allowed to retrieve per entity.

    4. Assign the fields that can be read. Go to System > Web Services > REST Attributes. Open the User Type Admin. Here, you will see the option REST API Calls to read invoices appear again. Check all options again and save the details.

    Configureer REST Attributes

    5. Link the administrator to the REST role. Finally, you need to assign the administrator to the REST role. Go to System > Permissions > Users. Click on the administrator of the webshop. Go to REST Role, the bottom option in the menu on the left. Assign the administrator of the webshop to the Administrator REST Role.

     

    Assign user to REST Role

    3.2 Magento consumerkey and consumersecret
     

    The steps for creating a Magento consumer key and consumer secret are as follows:
    1. Log in as admin to your Magento 1.x webshop.
    2. Go to System > Web Services > REST OAuth Consumers.

    Plaatje Magento Consumerkey en Consumersecret


    3. Click Add new to create the Magento keys. The key and secret are already filled in. Enter the name for the connection and the callback URL yourself. The value of the callback URL must be: https://interface.cloudinvoice.company/api/v1/servlet/magento/callback.php

    Plaatje Magento Consumerkey en Consumersecret

    4. Enter your administrator password. Click Save. You will enter the key and secret from this screen in a later chapter in the Consumerkey and Consumersecret fields of the connection settings screen.

    4.Required: Magento after version 2.1

    Magento webshops up to and including version 2.4.3 should follow the steps below to establish a connection with the webshop. For Magento webshops from version 2.4.4 onwards, we recommend creating an integration as explained below, but without a callback. If you contact us afterwards, we will ensure that you can enter the client ID / client secret / access token and token secret to establish the connection with the Magento webshop.

    Please note: This is a standard integration without customization options. This means that the integration does not support all extensions in the webshop. It can also be difficult to connect the webshop due to a specific hosting configuration, for example, because of a modified .htaccess file, complex redirects, or a firewall. If you encounter these problems, it is often necessary to engage a Magento expert.

    Read more Required Magento....
    Read less Required Magento....

    Installing and configuring the extension for Magento 2.x consists of the following steps:

    1. Configuration. There are two Magento tabs you need to fill in. For the first one, we come up with a recognizable name and enter the Callback URL (https://interface.cloudinvoice.company/api/v1/servlet/magento2/callback.php?cikey=YOURLICENSEKEY), the Identity link URL (https://interface.cloudinvoice.company/api/v1/view/cloudinvoice/authenticate.php), and your password. YOURLICENSEKEY must be replaced with the license key from the email. It is always smart to save in between (top right). After that, we move on to the second tab, API.

     

    Integration info tab invullen

    You are now going to assign the permissions: which data from the webshop is the integration allowed to use? The image explicitly indicates which resources you need to check. Then click SAVE in the top right.

    API tab invullen 2. Activating the extension. You are now going to activate the extension. First, click on ACTIVATE.

    Activeer extentie You must grant permission to do so using the ALLOW button in the top right of the next screen.

    Allow And now you finally understand why Magento 2 is called 'Magento 2': two windows open! On the first window (so outside your Magento store):

    Authenticatie informatie

    In this separate window, enter your webshop domain name and the connection key you received by email upon registration. If you then click the Consent to connect button, you will see the activation take place in the other screen (of your Magento store).

    Na toestemming geven kijk je naar je Magento scherm The extension is now fully activated. To be sure, you can check the status of your integration on the Integration screen within your Magento webshop. The status should now be ACTIVE.

    Status extentie You have now completed the preparations in your Magento 2.x store.

    5.Required: AFAS Key and connectors

    To get the connection working, an AppConnector must be created in the Afas Administration. The AppConnector must be populated with GetConnectoren and UpdateConnectoren.

    Read more Required Afas.nl ....
    Read less Required Afas.nl ....

    Step 0: Create user group and special user

    Afas advises you to create a separate username and user group for the connection.

    1. Creating a separate user group is done via General > Administration > Authorization tool
    2. Create the new user group via Group > New and fill in the details.
    3. Create system user and place in group
      • Go to User > New system user
      • Vul de gebruikersnaam en omschrijving in.
      • Click on: Next.
      • Profit Windows must be unchecked.
      • Complete the wizard. You do not need to enter an email address and UPN.
      • Go to the tab: Group maintenance.
      • Select the user group you created in step 1.
      • Go to the tab: Users in group.
      • Click on New.
      • Check the connector user.
      • Click on: Ok.
      • Close the Authorization tool. You do not need to reopen the environment.
      • Also see https://help.afas.nl/help/NL/SE/App_Auth_Group_Add.htm

     

    Step 1: Create AppConnector

    To create the AppConnector, log in to the Profit environment and go to General > Administration > AppConnector.

    Enter a clear description for the AppConnector and specify a user group. Afas users in that user group can use the connector.

    Then click Finish.

    The AppConnector opens. The check mark next to Blocked is pre-checked. Remove this check mark.

    Step 2: Add GetConnectoren

    We make the GetConnectors available as a zip file. You can download this file here: https://www.webwinkelfacturen.nl/afas_getconnectors.zip

    Extract the zip file on your own computer.

    Then go to General > Output > Management > GetConnector and click on import.

    You can import the GetConnectors one by one. After that, you can add them to the AppConnector. If you are working in a browser, you can upload the GetConnectors to your temporary Afas drive via the lines at the top of the screen and the upload circle.

    Step 3: Add UpdateConnectoren

    Go to the Update Connectors option and click New to add a new Update Connector. We recommend adding these connectors:

    1. FbItemArticle - for adding products
    2. FiEntries - for adding financial transactions
    3. FbSales - for adding orders
    4. KnSalesRelationOrg - for adding customer organizations
    5. KnSalesRelationPer - for adding customer relationships

    Step 4: Add user tokens

    Via the User Token tab, you can generate a code to authorize the connection to the Afas environment. Click on New to create a new user token.

    Select the user and provide a description. You can create multiple tokens for one user.

    A screen with a special code will now appear. Save this code carefully. You will need this code during the configuration of the connection on the dashboard https://uwkoppeling.webwinkelfacturen.nl. Please note that you need the entire code, including the 1 part.

    If you are working via the browser, you can copy the code from the top of the screen. This saves a lot of typing and prevents errors.

     

    6.Installation

    After installation, check using this FAQ, whether the integration works.

    Installing the integration starts with signing up for a trial period, via our integrations page. After registering, you'll receive an email with an installation URL and login details. Use this installation URL to start the integration installation.

    Activating the integration consists of three steps:
    1. Establishing the connection with the Magento webshop. For Magento 2.x webshops, you have already done this in the previous step. For Magento 1.9 webshops, you need to fill in additional details here.
    2. Establishing the connection with AFAS. This authorizes the integration to write transactions to your AFAS administration and read information.
    3. Configuring additional data, such as the VAT settings. Please note: The integration uses the amounts from the webshop to calculate the VAT percentages. Ensure that rounding differences do not cause problems with the VAT percentages.

    Read more Installation .... Read less Installation ....

    Before the integration can be used, the terms and conditions must first be accepted. The terms and conditions are based on the general ICT Terms and Conditions (industry organization) and the general GDPR guidelines.

    Authentication Magento webshop:
    This step only needs to be performed for Magento 1.9 webshops. For Magento 2.x webshops, the authentication has already been done in the previous step. Authenticating the Magento 1.9 webshop is done as follows:

    - First you fill in the admin URL of the webshop with the consumerkey and consumersecret from the previous step.


    - Then you click the yellow Connect button to give the integration the correct authorization. Only after performing these two steps is a valid connection with the Magento webshop established. You can see this because the indicator will be green.

    Authentication AFAS
    Establishing the connection with AFAS is done via the red Connect button in the Configuration tab. In the pop-up, you enter your Customer Code (this is the AFAS online 5-digit member number), and the token you created in the previous section. Please note, you need the entire code as a token, including the 1-part.

    Settings AFAS
    To use AFAS, select an administration within your account. You also indicate in which journal the revenue should be posted and what the debtors account is. The journal for processing (individual) invoices will be a Sales journal.

    Configure VAT rates and general ledger accounts
    When configuring the VAT rates and general ledger accounts, a link is created between the VAT rates in webshop and the VAT codes and revenue accounts in AFAS. You can always make changes by clicking the blue 'Edit' button and selecting an option from the drop-down menus.

    By default, all EU countries are shown in the list. You only need to configure the countries you sell to, and - if applicable - ICP and International. The integration shows the standard VAT rates for Europe. You can adjust the VAT percentage with which you sell - left column. For example: By default, sales to Germany are set to 21%, but if you sell in the webshop with 19%, you can adjust that in the left column. Intra-Community (ICP) and international deliveries
    The Intra-Community supplies / ICP option is intended for business-to-business deliveries within the EU. These sales are invoiced with 0% VAT. A VAT number from the customer is required. The International option applies to deliveries outside the EU. For these sales, the integration expects 0% VAT; otherwise, the sales cannot be processed. Separate VAT codes and general ledger accounts can be configured for both ICP and international deliveries.

    Once the VAT settings have been configured and saved, you will always see the selected VAT rates. If you want to start over, you can use the grey 'Remove VAT settings' button. Your current settings will then be deleted and you can begin again.

    Configure payment methods
    You can create a link here between the payment methods in the webshop and a fixed debtor in your AFAS administration. Invoices with a payment method from the list will then always be posted to this debtor. In that case, no new debtors will be created.
    Note: It is not possible to set fixed debtors for ICP invoices. For an ICP invoice, a valid VAT number must be transmitted. Therefore, a debtor will always be created in AFAS for an ICP invoice.

    7.Day-to-day: From Magento

    In this section, we show how we retrieve the invoices from the webshop.

    Processing schedule: New invoices in your webshop are retrieved at least once per hour. The integration retrieves both invoices and credit invoices for Magento 2.x and processes them. For Magento 1.9, credit invoices are not processed by default. You can request this option from us.

    Once an invoice has been processed, it cannot be processed again. An invoice that is modified in the webshop after it has been processed will not be adjusted in AFAS.

    VAT numbers For business orders within the EU, outside the Netherlands, a VAT number is mandatory. The integration checks for this and also verifies that the VAT number is a valid VAT number.

    VAT calculation: The integration always uses the prices in the [base_] fields, such as [base_grand_total] and [base_row_total].

    The VAT amount in the invoice lines is determined as follows:
    VAT amount = ['base_row_total_incl_tax'] - ['base_row_total']
    The VAT percentage is determined as follows:
    VAT amount/ ['base_row_total']
    If the amount excl. VAT is 0, the VAT percentage defaults to 21%. Unfortunately, this cannot be adjusted.

    Based on the VAT percentage, the VAT code and the general ledger account in AFAS are determined. We notice that some Magento webshops make their own corrections to the VAT in their invoices. The VAT then does not exactly match the VAT of the products. This results in incorrect VAT percentages, such as 8% instead of 9% and 22% instead of 21%. The integration cannot correct this and will give an error message if 8% and 22% do not appear in the webshop's VAT settings. We generally see this problem occur when using small amounts. Unfortunately, the integration does not have an adequate solution for this.


    Field-level specification invoices
    Specification Magento invoices +-
    Below is a specification at the field level for retrieving invoices from Magento 2.x webshops.
    Name field Values from Magento order
    Factor for multiplying amounts In the Magento credit invoices, the amounts are listed as positive amounts. This is because debit invoices and credit invoices are separate entities. In Magento, you therefore have two types of invoices, debit and credit, and both types have a positive amount. Therefore, the integration uses a factor = 1 for debit invoices and a factor = -1 for credit invoices.
    Invoice-identifier [entity_id] Please note, to keep those IDs unique between debit and credit invoices, the integration places a 1 before the invoice ID of the credit invoice. This is why you see a multiplication by the factor.
    Invoice number [increment_id] from the Magento invoice
    Orderid [order_id]
    Order number [increment_id] from the Magento order. If it is configured for the merchant that the order number is leading, then for the order number a C_ is placed.
    Affiliate number Is determined based on the underlying order
    • See [extension_attributes][payment_additional_info] from the Magento order
    • Loop through the different arrays
    • Determine the value value at key channel_id
    Order-identifier This is determined based on the URL in the field [order]
    Invoice date [created_at]
    ICP indication An invoice is an ICP invoice if:
    • The merchant does not have a contract with margin.
    • The invoice has no VAT
    • The country is an EU country other than the sales country
    International indication An invoice is an international invoice if:
    • The invoice has no VAT.
    • The country is a country outside the EU.
    Payment method The payment method is determined as follows based on the field [paymethod]:
    • If the payment method [paymethod] occurs in the credentials settings - and is thus configured on the dashboard https://uwkoppeling.webwinkelfacturen.nl, tab Configuration, then that payment method is used. When checking if the payment method exists, a so-called cleanUp action is performed. Hyphens and capital letters are ignored.
    • If the payment method [paymethod] is not found and the name contains the word transfer, back, invoice or rekening, the payment method becomes banktransfer.
    • If the name contains the word ideal, the payment method becomes ideal.
    • If the name contains the word paypal, the payment method becomes paypal.
    • If the name contains the word afterpay, the payment method becomes afterpay.
    • If the name contains the words mister and cash, the payment method becomes mistercash.
    • If the name contains the words credit and card, maestro, visa or mastercard, the payment method becomes creditcard.
    • In all other cases, the payment methods will be default.
    Paymentmethod-id [paymethod_id]
    Total amounts incl or excl VAT The amounts in the order can be incl. or excl. VAT. This is determined by the field [taxes_included]. This value is important for determining the Total incl and the Total excl, see below.
    Total incl [base_grand_total]. The base_ part ensures that the amount is taken in the webshop's base currency.
    Total VAT [base_tax_amount]
    Total excl Total incl VAT - Total VAT
    Shopping cart values These values are read via [base_subtotal] and [base_subtotal_inc_tax]
    Specification Magento invoices lines +-
    Name field Values from Magento order
    Name product [name], special characters are removed as much as possible
    Amount [qty]
    Amount incl VAT [base_row_total_incl_tax]; for the unit amount we divide by the quantity
    Amount excl VAT [base_row_total]; for the unit amount we divide by the quantity
    VAT Amount with discount [base_row_total_incl_tax] - [base_row_total]; for the unit amount we divide by the quantity
    VAT percentage The VAT percentage is tricky with Magento invoices because the Magento API provides these prices in 2 decimals, which quickly results in a percentage of 20%, 22%, 8% or 10% for small amounts. There is a workaround, but that requires programming work on the side of the Magento webshop.
    • default: field VAT amount / [base_row_total]. This percentage is rounded to 2 decimals.
    • workaround 4-decimals: field [extension_attributes][tax_amount4_decimals] / [extension_attributes][base_row_total4_decimals]. This percentage is rounded to 2 decimals.
    Discount [base_discount_amount] for the discount amount incl VAT. For the discount excl VAT [base_discount_amount] - [base_discount_tax_compensation_amount].
    Line prices incl and excl discount These are calculated from the discount and the unit prices. The unit prices are multiplied by the quantity.
    The shipping costs are added as a separate invoice line The amounts are determined based on [total_shipping], [shipping_tax_percentage] and [invoice_row_taxes_included] as in other lines. This line is only added for an amount other than 0.
    The payment costs are added as a separate invoice line The amounts are determined based on [paymethod_costs], [extra_payment_option_price] and [invoice_row_taxes_included] as in other lines. This line is only added for an amount other than 0.
    The surcharges are added as separate lines to the invoice The amounts are determined based on [extra_costs], [credit_point_discount], [invoice_row_taxes_included] as in other lines. The amount is only added for an amount other than 0. This leads to a maximum of 2 extra lines.
    Accounts and VAT codes from AFAS These are determined based on the settings in the integration, the delivery country of the invoice and the VAT percentages. The type for invoice lines is turnover / revenue, for the shipping costs line shipping / shipping costs and payment costs payment / payment costs.

    8.Day-to-day: To AFAS

    This data is processed to AFAS:

    Creating orders / sales transactions
    The invoices from Magento are imported into AFAS as financial entries or orders. For each invoice, the VAT and general ledger account are provided as configured during the installation of the integration.
    When creating entries / orders, new debtors and/or products may be added to AFAS.

    Cost center It is possible to provide one default cost center to the order or sales transaction. One default cost center is possible per integration. Contact webcare@webwinkelfacturen.nl stating the license key to make use of this.

    Create debtors
    When processing customer information, it is first checked whether the customer has been processed before. If so, this AFAS debtor is used as the debtor for the AFAS order or financial entry. If the customer is not yet known, they are added to AFAS. Matching is based on email address. Please note: The integration only creates debtors. The integration does not modify debtors.

    Create products
    When processing to AFAS orders incl. products, products that are not yet in AFAS will be added. See here for an explanation of how product codes are determined FAQ. The product is assigned VAT group 1 if the product has 9% or 6% in the sales line. Otherwise, the new product is assigned VAT group 2. The product is automatically placed in AFAS item group 900. Ensure that this is also configured in the AFAS administration, otherwise the entries may go wrong.
    Please note: The integration only creates products. The integration does not modify products.

    The rules for matching products between Magento and AFAS can be found in this FAQ be read.

    Automatically sending invoices
    The integration creates an order or financial entry in AFAS, not an invoice. Therefore, the integration cannot ensure that the invoice is automatically sent to the customer.


    Field-level specification AFAS

    Field-level specification of the AFAS financial booking.+-
    AFAS Financiële boeking
    Name Example Note
    Paragraph
    Year 2023 Invoice date year (Magento order)
    period(Peri) 03 Invoice date month (Magento order)
    UniqueId(UnId) 3 Administration - One administration is possible per integration.
    Journal(JoCo) 01 Journal
    (AutoNumber)AuNu 1
    AFAS assigns the invoice numbers (default) - can be adjusted to the invoice or order number upon request.
    Total line
    AccountNumber(AcNr) 89302
    EnDa 2023-03-01 Order date
    BpDa 2023-03-01 Order date
    Description(Ds) ORD08725 Description - Magento order number.
    BpNr ORD08725 Payment reference - Magento invoice or order number.
    AmountDebet(AmDe) 24.95 Total price incl. VAT - debit.
    Cost center(DiC1) xxxx The default cost center if configured.
    If AFAS does not determine the invoice number - order number or invoice number
    Revenue line
    VaAs 2 1 = General ledger account. 2 = debtor
    AccountNumber(AcNr) 89302
    EnDa 2023-03-01 order date
    BpDa 2023-03-01
    Description(Ds) ORD08725, INV09854 Description - Magento order or invoice number.
    BpNr ORD08725 Payment reference - Magento invoice or order number.
    AmountDebet(AmDe) 24.95 Total price incl. VAT - debit.
    If AFAS does not determine the invoice number - order number or invoice number
    VAT lines
    VaAs 1 1 = General ledger account. 2 = debtor
    AccountNumber(AcNr) 8000
    EnDa 2023-03-01 Order date
    BpDa 2023-03-01 Order date
    Description(Ds) Garden light Description: VAT - Name in the order line - Amount excl. VAT.
    BpNr ORD08725 Entry number: Magento invoice number or order number.
    AmountCredit(AmCr) 20.62 VAT amount - credit.
    VatId(VaId) 101 VAT account
    If AFAS does not determine the invoice number - order number or invoice number.
    Any rounding difference is processed in the VAT amounts if the rounding difference is 5 cents at most.
    Field-level specification of the AFAS order. +-
    Name Example Note
    Paragraph
    OrderNumber (OrNu) [number] Magento - invoice or order number.
    OrderDate(OrDa) [date] Magento - order date..
    DebtorID(DbId) [debtornr] AFAS debtor ID
    Unit [division] Administration - Per integration, the administration is fixed.
    CurrencyId(CuId) EUR Currency - This option is disabled by default. You can contact us if you wish to use this.
    InclVat(InVa) true Total price incl. VAT (true), unless afasexcltax is configured.
    War ***** Default for the warehouse, can be overwritten via the settings
    Reference(Re) [notes] Comment - if present.
    FRef [number] InvoiceReference (payment reference) Magento Invoice number invoice number
    line
    Description(Ds) [name] Description
    Ledger account as configured on the dashboard.
    Quantity(QuUn) 1 Amount
    ItemCode(ItCd) [productid] Productcode
    Unitprice(Upri) excl. / incl. VAT Unit price, as configured on the dashboard.
    Field-level specification of the AFAS customer. +-
    Name Example Note
    CuId EUR Not editable
    IsDb true Not editable
    PaCd 14 Not editable
    PersonDetails
    Padadr true Not adjustable
    AutoNum true Not editable
    MatchPer 7 Not editable
    SpNm false Not editable
    FiNm Karin
    Last name de Wit
    ViGe 0 Not editable
    EmAd info@sponiza.nl
    AdresDetails
    CoId NL AFAS country code
    PbAd false Not editable
    StAd Not editable
    Ad Stationstraat
    HmNr 12
    ZpCd 1000 AA
    Rs Amsterdam
    Field-level specification of the AFAS product. +-
    Name Example Note
    AutomaticID(AuId) false
    ItemCode(ItCd) [ArticleKey]
    ChDs false
    Group(Grp) 900
    BiSt false
    BiUn *****
    VaRc [Vattype] VAT type
    CostPrice(CoPrice) [costprice]
    SalePrice(SaPrice) [priceIncl] Unit price INCL.
    BatchCode(BaCo) [eannumber] Product Number

    9.Support

    We believe it is important that you as online retailer have direct access to information about the integration whenever you want. That is why every customer has a personal dashboard.
    Read more Support .... Read less Support ....

    Persoonlijk

    Explanation tabs dashboard

    On the Dashboard >> Report you can see which invoices from your Magento webshop, and when, have been transferred to AFAS.

    At Dashboard >> Errors you can see which invoices have not been processed. Via the blue Process button you can (re)submit the invoice. Via the red Report problem button you can create a ticket with us.

    At Dashboard >> Open the invoices are listed that have not yet been processed because they do not yet have the correct status in the webshop. Every night jobs run to review the status again and still process the invoice.

    At Dashboard >> Configuration the settings of your integration are listed. You can adjust the settings there.

    At Dashboard >> Profile invoices are available for download. You can also specify an additional email address here for sending emails and stop the integration.

    What if invoices are missing in AFAS

    If invoices are missing in AFAS we recommend following the steps below:
    1. Log in to the dashboard: https://uwkoppeling.webwinkelfacturen.nl. The username and password are included in the registration email.
    2. Go to the Errors tab and check if invoice is there. You may need to adjust the search period if the invoice is from a previous month. If you find invoice in this overview:
      1. Check the error code and verify whether you can resolve it yourself.
      2. If yes resolve the issue and click the blue Process button to resubmit the invoice.
      3. If not use the red Report problem button to create a ticket with us.
      4. Note if there are multiple errors, please create only 1 or 2 tickets. We will automatically see the other issues.
    3. Go to the Report tab and see if invoice is listed there. If so, you'll often see an identifier for AFAS (in the purple section of the overview) that you can use to search for invoice.
    4. Go to the Open tab and check if invoice is there.
    5. If you cannot resolve the issue, you can always create a ticket via the green Ask us button.

    You can send any other questions or comments to webcare@webwinkelfacturen.nl. For a quick response, please always include the license key and as much information as possible. If you encounter any problems during installation, please let us know where you're experiencing the issue. And if there's an error message, please include that as well. If you think invoices is missing, please provide the number and date. This way, we can perform a more targeted search and tell you what's wrong.

    We have an extensive FAQ-section on the website. Pay particular attention to these sections: https://faq.webwinkelfacturen.nl/category/24/magento.html and https://faq.webwinkelfacturen.nl/category/69/afas.html.

    Would you rather have us do the installation of the integration for you? That is possible. Send an email to webcare@webwinkelfacturen.nl with the request. For an installation, we charge € 39.50 excl. VAT. For installations, we need access to the webshop and the accounting system.

    We can perform migrations for invoices that took place in the past. The request procedure and method are described in this faq. For migrations we charge €67.50 excl. VAT per 1000 invoices.