This guide walks you through how Alaan connects with MS Dynamics 365 Finance & Operations( MS F&O) from setup and authentication to data sync and export transactions. It’s broken down into three key sections:
🔑 Integration Scope
Supports integration with one company/legal entity
Automated data syncing between Alaan and MS F&O
Creation of general journal entries in MS F&O for Alaan transactions
Attachment of receipts to transactions for detailed tracking
Syncs automatically every 24 hours, with an option to sync manually anytime from the Alaan web app
Supports only the cloud version of MS F&O (offline is not supported)
DSSAPICreation.axmodel file saved on your local machine.
✅ What’s Included
✅ Supported Features | ❌ Unsupported Features |
Import and link the chart of accounts to categories | Import and map vendors/suppliers |
Import tax codes |
|
Create expenses in MS F&O (supported as journal entries in draft status) |
|
Create receipts in MS F&O |
|
Import and map expense tracking tags |
|
Create bank accounts |
|
Split expenses and export as different line items |
|
Include details like spender name, merchant, memo, FX and invoice number |
|
🔄 Data Flow Overview
From | To | Data Shared |
MS F&O | Alaan | -Subsidiaries (Companies) List -Bank Accounts -Financial Dimensions -Journals -Chart of Accounts -Tax Codes List |
Alaan | MS F&O | -General Journals (Transaction Data) -Attachments (Receipts and Invoices) |
🛠 Step-by-Step Guide
Step 0: Authenticate
Obtain OAuth credentials:
Client ID, Client Secret, Tenant ID, and Scope URL.
Configure these credentials in the Alaan Web App.
Test the connection to verify successful authentication.
How to find Client ID:
Go to the Azure Portal.
Navigate to Azure Active Directory from the left-hand menu.
Select App registrations.
Click on the application you have registered for, or create a new one by selecting New registration.
On the application Overview page, you’ll find the Client ID.
How to find Client Secret:
In the same application under App registrations, go to Certificates & secrets in the left-hand menu.
Click + New client secret.
Provide a description and set an expiration period.
Click Add.
Copy the Client Secret value. This value will be displayed only once, so please make sure to save it securely.
How to find Tenant ID:
Navigate to Azure Active Directory > Overview.
Under the Tenant Information section, you’ll find the Tenant ID.
How to find the Scope URL
Scopes define the permissions your app needs to access specific resources.
In F&O, the format for the Scope URL is typically:
https://<your-environment>.cloudax.dynamics.com/.default
Where to find the Scope URL:
<your-environment>is the name of your Dynamics 365 environment (e.g.,dsss-uat.sandbox.operations.eu.dynamics.comfor your sandbox environment).The
/.defaultpart indicates that you are requesting the default set of permissions for the app registered in Azure AD.
Step 1: Install Required Bundles
Download and install the integration bundle on your MS F&O system.
Save the Exported Model:
Save the DSSAPICreation.axmodel file in a folder, such as C:\\Backup and verify that the file is visible in the selected folder.
Open Command Prompt as Administrator
Search for "cmd" in the Windows search bar.
Right-click on Command Prompt and select Run as Administrator.
Locate the AOSService Bin Directory.
Navigate to Folder> Access C:\\AOSService\\PackagesLocalDirectory\\bin in File Explorer.
Change Directory in Command Prompt
cd C:\\\\\\\\AOSService\\\\\\\\PackagesLocalDirectory\\\\\\\\bin
Import the Model using ModelUtil. Adjust the file path if the model file is stored in a different location.
ModelUtil.exe -import -metadatastorepath=C:\\\\\\\\AosService\\\\\\\\PackagesLocalDirectory -file=C:\\\\\\\\Backup\\\\\\\\DSSAPICreation.axmodel
If the import is successful, a confirmation message will appear indicating the DSSAPICreation model was imported.
Step 2: Setup Process
Select the company for integration.
Sync the following data:
Tax codes
Chart of accounts and bank accounts
Choose an existing bank account or create a new one in F&O.
Complete the setup by confirming the mappings.
Once integrated, you can begin exporting transactions. Learn more:
⚙️ Manage MS Dynamics 365 Finance & Operations
Map categories to your Account
Mapping expense categories to MS F&O's chart of accounts is optional but recommended.
Navigate to Settings in the Alaan web application.
Click on Expense Accounts.
Select an existing expense category or create a new one.
Assign a corresponding Chart of Accounts (Expense Account) for the category.
Sync MS F&O
Navigate to Settings > MS F&O in the Alaan web application.
Click on Instant Sync (top-right corner).
The sync process will start and take up to 5 minutes to complete.
Disconnect Integration
Navigate to Settings > MS F&O.
Click on Disconnect.
Confirm the action to disable the integration.
Change Bank Account
Navigate to Settings > MS F&O.
Click on Change Bank Account. Choose the desired bank account and connect it to Alaan.
Enable/Disable Vendor Mapping
Navigate to Settings > MS F&O.
Toggle the Vendor Mapping switch to enable or disable it.
Troubleshooting
Invalid OAuth Token: Regenerate a new token from your settings.
Incorrect Field Mapping: Review and update your field mappings directly in the Alaan Web App.
Wrong Company Selected During Setup: Disconnect and reconnect the account, then re-map the fields as needed.
Model Import Fails: Verify file path and permissions. Ensure Command Prompt is running as Administrator.
File Not Found: Double-check the path to DSSAPICreation.axmodel in C:\\Backup or the specified folder.
Need help? Contact the Customer Success Team if you face any issues or if you need further customisation.