Document Properties
Kbid
F27737
Last Modified
11-Dec-2023
Added to KB
20-Jul-2016
Public Access
Everyone
Status
Online
Doc Type
Guidelines
Product
  • IOM 3.0
  • IOM 3.1
  • IOM 3.2
  • IOM 3.3
  • IOM 3.4
  • IOM 3.5
  • IOM 3.6
  • IOM 3.7
  • IOM 4.0
  • IOM 4.1
  • IOM 4.2
  • IOM 4.3
  • IOM 4.4
  • IOM 4.5
  • IOM 4.6
  • IOM 4.7
  • IOM 5.0
Guide - Generic Interfaces for External Accounting Systems

Introduction

The present guide is addressed to developers and describes the required steps to link the IOM to an external accounting system. Please refer to the Reference - IOM ImpEx Interfaces (valid to 2.0) for an overview of the the provided import and export formats.

General Configuration

This section describes the general configuration of a finance controller, i.e., external accounting system. The following queries or query snippets are to be executed on a SQL command prompt or console of the IOM database.

FinanceControllerDO

  1. Create an entry/row in the table oms."FinanceControllerDO" for the required finance controller.

    INSERT INTO oms."FinanceControllerDO"("id", "name") values 
        (nextval('"FinanceControllerDO_id_seq"') , 'Name of FinanceController')


    In these examples, an entry with a name 'Name of FinanceController' is created. Kindly use an appropriate name.

PartnerReferrerDO

  1. The added finance controller needs to be qualified as a partner for future communications (with shop).

    INSERT INTO "PartnerReferrerDO" ("id", "financeControllerRef") values 
    	(nextval('"PartnerReferrerDO_id_seq"') , (SELECT "id" FROM "FinanceControllerDO" WHERE "name" = 'Name of FinanceController'));

Shop2FinanceControllerDO

  1. Assign/map the shop to the external finance controller.

    INSERT INTO "Shop2FinanceControllerDO"("id", "financeControllerRef", "shopRef", "financeControllerShopName", "description") values 
        (nextval('"Shop2FinanceControllerDO_id_seq"') , --id 
    	(SELECT "id" FROM "FinanceControllerDO" WHERE "name" = 'Name of FinanceController'), --financeControllerRef
    	10000, --shopRef
    	'XYZ', --financeControllerShopName
    	'Debtormanagement der XYZ for Shop ABC.'); --description and end of insertion query

Additional Configuration

CommunicationPartnerDO

  • To define which bean is used to send the transmission for the specific partner referrers and transmission type.
  • It is possible to use a custom implemented sender bean which is configured in CommunicationDO.

As the following query is different for various scenarios (e.g., IOM ImpEx Creditor Management - Export Open Payments a.k.a. Unpaid Amounts of Dispatches (valid to 2.1) and IOM ImpEx Export Open Positions), please do not execute the following query as is. The columns communicationRef and sendingPartnerReferrerRef have to be manually specified with appropriate values.

INSERT INTO "CommunicationPartnerDO"("id", "decisionBeanDefRef", "splitTransmission", "communicationRef", "sendingPartnerReferrerRef", "receivingPartnerReferrerRef", "maxNoOfRetries", "retryDelay", "mergeTypeDefRef") values
    (
        nextval('"CommunicationPartnerDO_id_seq"'),
        null,
        FALSE,
        (select id from "CommunicationDO" where "key" = Name of Key), -- enter the required key here
        (select id from "PartnerReferrerDO" where "shopRef" = your shopId), -- enter the required shop ID (e.g. 10000) here
        (select id from "PartnerReferrerDO" where "financeControllerRef" = (SELECT "id" FROM "FinanceControllerDO" WHERE "name" = 'Name of FinanceController')),
        5,
        '10m',
        null
    );
Disclaimer
The information provided in the Knowledge Base may not be applicable to all systems and situations. Intershop Communications will not be liable to any party for any direct or indirect damages resulting from the use of the Customer Support section of the Intershop Corporate Web site, including, without limitation, any lost profits, business interruption, loss of programs or other data on your information handling system.
The Intershop Knowledge Portal uses only technically necessary cookies. We do not track visitors or have visitors tracked by 3rd parties. Please find further information on privacy in the Intershop Privacy Policy and Legal Notice.
Home
Knowledge Base
Product Releases
Log on to continue
This Knowledge Base document is reserved for registered customers.
Log on with your Intershop Entra ID to continue.
Write an email to supportadmin@intershop.de if you experience login issues,
or if you want to register as customer.