SAP SFTP AFAS Integration

Prices are retrieved from SAP SFTP and send to TARGET

Prices are synced based upon pricegroups. One on One Customer specific Prices are by default not supported. It is advisable to have a customer sync in place to have the customer on the correct group to have the group specific prices available.

Process >

We check if the product exists, if it exists we check if the customer/price group exists. If both checks are ok we create a price for this specific customer group.

Process

Customers can be synced from SAP SFTP to AFAS.

APIcenter differentiates in creating the customer based on the source data received. If APIcenter receives a company name from the source, then a company debtor is created with the underlying contact. If there is no company, then a person debtor is created.

Customers are also created via Orders, this sync is not needed for an order flow but only in case if you want to sync customers between various systems.

Process

Stock can be synced from SAP SFTP to TARGET.

Settings

Different types of stock calculations are supported. By default the available stock - sales reservations is send.

You can set the value towards target system if you want to have the stock managed or not.

Process

Shipments can be retrieved from SAP SFTP and synced to AFAS.

With this shipment flow we create a shipment in the target system. We set the track and trace value and a transporter.

Be aware that split up shipments can create strange behavior on the integration as some systems do not support split up shipments.

Process

Products can be synced from SAP SFTP toAFAS. Within this sync, different types of products are supported. APIcenter gathers the data from SAP SFTP, then it is run through APIcenter to have the correct settings, values, and formats before it is sent to AFAS. Products are created or updated based on the SKU.

You can differentiate within APIcenter the behavior between creating and updating products. For example, when APIcenter creates a product and sends in the long description from the SAP SFTP, but if you enrich the data after this in AFAS, you don't want to have it overwritten with an update. For this, you can set a checkbox to update the product info.

Product types

Supported product types : Simple, variant/configurable products.

Attributes/Features

Besides the generic and custom added fields from SAP SFTP, Item Attributes from SAP SFTP are also supported. These need to be manually mapped in APIcenter.

Attributes are used for creating configurable products, like size/color/options. Features are used as extra information fields, think about the country of origin, type, delivery time, etc.

Categories

Images

Images are supported from SAP SFTP to AFAS.

Datamapper

You can map additional fields that are available in the API. For a default working integration, we have already mapped the basic fields that are needed, for example:

Fields

• Name/Title
• SKU
• Long Description
• Short Description
• Price excl. tax or incl. tax
• Quantity
• EAN/GTIN
• Currency

Process

Within this flow we set product relations, cross sell / up-sell and related products. This doesn't fit in the regular product flow as the products already needs to be created before we create a product relationship.

Orders can be synced from SAP SFTP to AFAS.

Process

You can set the status on which orders are sent, like only the paid orders.

Once APIcenter retrieves the order data, it is processed, and missing data (for example, administration ID) is added, and the sendOrder starts.

First, APIcenter checks if the order already exists; if it exists, we skip the order. If it does not exist, APIcenter checks if the customer exists and, depending on the outcome, creates or updates the customer. APIcenter checks if all products exist, and then the order is committed.

APIcenter differentiates in creating the customer based on the source data received. If APIcenter receives a company name from the source, then a company debtor is created with the underlying contact. If there is no company, then a person debtor is created.

The check if a customer is exists is based on the email address.

Order types

SAP SFTP supports Quotations, Orders, Invoices, DirectInvoices and financial mutations,

An order can be created in AFAS

Settings

There are multiple settings important for the flow to be working correctly. You can set your debtor ledger account, Payment Terms, Administration ID via the Wizard.

Standard we offer functionality to make specific mappings like payment terms and methods from the AFAS to the SAP SFTP.

p>

Do you want to make use of a default debtor? This is also available by default in APIcenter.

For a complete overview please check the documentation.

Datamapper

By default APIcenter supplies a mapping that makes sure you can send an order towards SAP SFTP. You can also make adjustments to this yourself.

Default fields that are mapped are for example:

• Customer Name
• Billing address street
• Number
• Postal code
• City
• Country
• Shipping address street
• Number
• Postal Code
• City
• Country
• SKU
• Quantity
• Price