Connector Architecture

Posting Journal Lines in Business Central

The MS Dynamics - Business Central - Accounting connector is started by a Webhook notification defined in Mambu. The Webhook is triggered by the Accounts Updated event, which is fired after performing the End of Day actions, to ensure that information is up to date and in accordance with all posted transactions. Once started, the connector then executes the following processes:

  1. Post corresponding Dimension Values in Business Central for new Mambu Entity Items (Branches, Loan and Deposit products) that were created since the previous run;
  2. Retrieve the Journal Lines from Mambu based on creation date and store them in batches;
  3. Process the batches by enriching each Journal Line with additional information;
  4. Post the enriched Journal Lines to Business Central.

connectorArchitecturePostingJournalLines

Posting Dimension Values in Microsoft Dynamics 365 Business Central as part of Initial sync

Dimensions in Microsoft Dynamics 365 Business Central are used to group or categorize data for the purpose of analysis. Dimensions consist of Dimension Values which are attached to Journal Lines in order to provide some more details and to conduct a meaningful analysis.

The integration requires four Dimensions which correspond to the Mambu entity types to be manually added in Business Central:

  1. Dimension related to the Mambu Branches
  2. Dimension related to the Mambu Products (Loan and Deposit products)
  3. Dimension related to the Mambu Clients (Clients and Groups)
  4. Dimension related to the Mambu Accounts (Loan and Deposit accounts)

The Dimension Values associated with these Dimensions have the following structure:

  • Branch Dimension Value fields:
    • Code - stores the Mambu branch ID (unique value);
    • Name - stores the Mambu branch name.
  • Product Dimension Value fields:
    • Code - stores the Mambu loan product/deposit product ID (unique value);
    • Name - stores the Mambu loan product/deposit product name.
  • Client Dimension Value fields:
    • Code - stores the Mambu individual client/group ID (unique value);
    • Name - stores the Mambu individual client/group name.
  • Account Dimension Value fields:
    • Code - stores the Mambu loan account/deposit account ID (unique value);
    • Name - stores the Mambu loan account/deposit account name.

Notes:

  1. Business Central has certain limitations for the Dimension Value parameter values:
    • The length of the Code value must be less than or equal to 20 characters.
    • The length of the Name value must be less than or equal to 50 characters.
  2. The branch, product, client, and account entities from Mambu are automatically posted in Business Central as Dimensions Values during the setup process.

connectorArchitecturePosingDimensionValues