Importing Lease Accounting Postings into Consolidation & Financial Planning

Navigate to Import and Journals | Scripts.

Right-click Scripts or a folder in the tree view and select Create | Script. The Create Script dialog is displayed as follows:

Drag and drop the downloaded script file into the dialog, or click browse and select the script file (see Creating a Script). The script is created with the name of the script file, including the version.

Navigate to Import and Journals | Scripts and select the Lucanet Lease Accounting script in the tree view.

Click Edit in the top right corner. The detail view of the script is displayed as follows, for example:

On the Configuration tab, configure the settings on the Connection tab as follows:

On the Dimension configuration tab, specify which additional information the script writes into the CFP dimensions:

On the Import configuration tab, select under Retrieve postings by whether the script assigns the postings to the accounting periods by PostingDate or by DocumentDate.

Click Save in the top right corner.

Navigate to Import and Journals | Importing data into reporting entities.

Right-click the Data sources folder and select Create | Data source. The Create data source dialog is displayed as follows:

In the Origin of the data field, select Provision via script (#2075), enter a name such as Lease Accounting in the Element name field, and click Save.

Navigate to Import and Journals | Importing data into reporting entities.

Select the new data source in the tree view and click Edit in the top right corner. The detail view of the data source is displayed as follows, for example:

In the upper area, select the Lucanet Lease Accounting script in the Drill down to posting level and Display scanned documents fields.

On the General tab, add the Lucanet Lease Accounting script to the list of scripts that are executed during the data import. Leave Application set to Execute on the server.

Still on the General tab, configure the following:

On the Reporting entities tab, add the reporting entities whose postings you want to import. Only reporting entities added here are available for selection when you execute the import. Enter the ID of the reporting entity in Lease Accounting in the ID in data source column and the first month of the fiscal year in the First month of the fiscal year column.

Click Save in the top right corner.

Navigate to Import and Journals | Importing data into reporting entities.

Right-click the Assignment tables folder and select Create | Assignment table. The Create element dialog is displayed as follows:

In the Element name field, enter a name such as Lease Accounting and click Save.

Navigate to Import and Journals | Importing data into reporting entities.

Right-click the Data imports folder, or a folder you have created below it, and select Create | Data import. The New Data Import view is displayed as follows:

Enter a Name for the data import.

In the Data source field, select the data source that executes the Lucanet Lease Accounting script.

In the Assignment table field, select the assignment table you created for Lease Accounting.

Click Save in the top right corner. The 1. Import action becomes available, and CFP prompts you to execute the data import.

Open the data import and click Edit in the top right corner.

Click 1. Import. The Provision via script (#2075) dialog is displayed as follows:

On the Configuration tab, configure the following:

Click Save. CFP executes the script, retrieves the postings from Lease Accounting, and displays the progress. The import typically takes a few minutes.

If elements delivered by the script have not been assigned to CFP elements yet, CFP displays the message Missing assignments with the number of unassigned reporting entities or cost centers, accounts, transaction types, adjustment levels, data levels, partners, and transaction currencies. This is expected for the first import.

Click 2. Assign and assign the elements delivered by the script to the elements of your CFP database (see Assigning Data). Alternatively, open the assignment table and use the Not assigned filter on each tab to complete the assignments.

The script delivers the accounts with their descriptions from Lease Accounting, for example BS Lease liabilities IFRS 16 <1 year or PL Depreciation Right-of-use assets - buildings. Assign the adjustment level delivered by the script to the adjustment level you created for the lease accounting postings, and the data level to Actual.

Click 3. Save to save the data import. The Postings section of the data import displays the imported postings with their reporting entity, data level, period, transaction currency, and adjustment level.