Truncate AxDB database log

Recently on one of the environments with the below error

After investigation, found an issue with the MSSQL_Logs drive got full

So I figure the issue by truncating or shrinking of database log by following the below steps.

Truncate the transaction log

1. Right-click the AxDB database and select Properties -> Options.
2. Set the recovery model to Simple and exit the menu.
3. Right-click the database again and select Tasks -> Shrink -> Files.
4. Change the type to Log .
5. Under Shrink action, select Reorganize pages before releasing unused space and click OK.

Migrating Security Configuration in D365 F&O

Migrating Security Configuration in D365 F&O

Data Management in D365 F&O

Data Management in D365 F&O

Embedded Power BI reports in D365 F&O

Embedded Power BI reports in D365 F&O

Import data using DMF project in X++

Import data using DMF project in X++

Import DMF Projects using flow (Power Automate)

Import DMF Projects using flow (Power Automate)

Migrating Security Configuration in D365 F&O

Pending Invoice – Data Entities

Pending Invoice – Data Entities

Migrating Security Configuration in D365 F&O

AX / D365FO – Call Power Automate / Logic App from X++ code

Upload configuration files for BAI2 format

Purpose:

In this document I will be performing process to import bank statement using BAI2 format in D365 F&O.

1.    Go to System administration –> Data management.

2.    Click Import, enter job name description.

Set parameters for import document

Note: Change to Standard view if the below screen is not visible.

Select as follows:

1.    Set Name: BAI2.

2.    Set Source data format: XML-Element.

3.    Set Entity name: Bank statements.

4.    Click View map and then again click View map.

5.    On following screen, go to Transformation tab.

Note : Files can be downloaded from AOT resource

Now, the three files have to be uploading using following steps.

1.    Click new.

2.    Upload file (BAI2CSV-to-BAI2XML.xlst)

3.    Click new.

4.    Upload file (BAI2XML-to-Reconciliation.xslt)

5.    Click new.

6.    Upload file (BankReconciliation-to-Composite.xslt)

7.    Click Apply transforms.

Create bank statement format

Navigation: Cash and bank management a Setup a Advanced bank reconciliation a Bank statement format.

1.    Set Statement format: BAI2

2.    Set Name: BAI2

3.    Set Processing group: BAI2

4.    Set File type: txt

Import bank statement

Note: This is the sample BAI2 File which will be imported in MS D365: F&O.

Navigation: Cash and bank management –> Bank statement reconciliation –>Bank statements.

On following form, click Import Statement

1.    Set Bank account: MOTLE914.

2.    Set Statement format: BAI2.

3.    Now upload the file and click OK then statement will be generated.

Note :  If the import is successful, you will receive a message that states that your statement was imported. If the import wasn’t successful, in the “Data Management” workspace, in the “Job History” section, find the job. Click “Execution details” for the job to open the “Execution Summary” page, and then click “View Execution Log” to view the import errors.