Creating and Configuring the Data Source

Script
Select the script Lucanet xP&A #3700-xP&A.SQL.FOS (the name may be truncated in the dropdown list). This script is executed during the data import.

Application
Select where the script is executed, e.g. Execute on the server.

Import type
Select one of the following import types:

• Transaction figures – imports transaction figures
• Balances – imports balances
• Transaction figures incl. automatic contra entry – imports transaction figures with automatic contra entries into planning data levels (not for the actual data level).
• Transaction figures or balances (selection when importing) – the user chooses transaction figures or balances when executing the import.

Accounting periods per year

Select the number of periods per fiscal year (e.g. 12).
The app supports 12 periods per fiscal year.

Activate to use a dimension from xP&A as transaction currency for the execution settings and select the Dimension for transaction currency.

The area Cost centers in the Balance Sheet is only visible if you activated the import of the cost center dimension.

Select if you want to Use default cost centers always (recommended) , or if you want to Use specified cost centers (e.g. from the reporting entities or assignment table).

Select if and how values shall be reclassified during the import:

• Attach suffix to account name
• Present intercompany postings on separate accounts
• Reclassify debtors with credit balances and creditors with a debit balance

Add the reporting entities that can be selected for import and fill in the table columns:

• Displayed name – name as shown in the UI
• Abbreviation in Lucanet 
• ID in data source – name of the reporting entity in Lucanet. Must match the exact name in Lucanet, as this is used as the target of the import.
• First month of the fiscal year – e.g. 1 for January
• Category – optional category
• Folder – optional folder

• Split data imports during first execution: If activated, data imports are split during the first execution.
• Categorize data imports: If activated, data imports are categorized as specified in the table above.
• Use folders: If activated, folders are used for organizing data imports as specified in the table above.
• Adjust name of the month: If activated, the name of the month is adjusted with a specified prefix or suffix.

Table to define the exports created in xP&A that are to be imported into Consolidation & Financial Planning. Specify the following:

Export ID: ID of the export from xP&A whose values are to be read (selectable options are based on the script configuration).

Do not refresh xP&A export: If activated, the export from xP&A is not executed again on the next import; previously exported data can be used. If no export has been run yet for this export ID, the export will still be executed. 

Option to filter the variables to be imported from xP&A

The following options can be selected:

• Selected variables – Recommended option allowing you to select an entire section or individual variables. 
  Selecting a section is less maintenance-heavy: new variables added to that section in xP&A are automatically included on the next refresh.
• All variables: All variables from the xP&A export are imported as accounts, except those marked as Exclude variable in the Variables table.

Table to define specific variables to be imported (if you do not want to import All variables) or excluded from the import. The table contains the following columns:

• Variable – variable from xP&A to import as an account (Refresh updates the list).
• Multiply value by -1 – if activated, values for that variable are multiplied by -1. 
  
  xP&A typically stores revenue as positive values, but CFP uses debit/credit logic where revenue (P&L credit) must be imported as negative to display correctly.
  
  You can apply this option per variable, per section, or globally via this checkbox at the bottom.
• Exclude variable – if activated, the variable is excluded (when All variables is selected).

If activated, all values are multiplied by -1.

xP&A typically stores revenue as positive values, but CFP uses debit/credit logic where revenue (P&L credit) must be imported as negative to display correctly.

You can apply this option per variable, per section, or globally via this checkbox at the bottom.

Option to specify which currency should be used when importing values. 

Choose between As specified currency (uses the currency from xP&A) or As default currency (uses the entity's default currency in CFP).

Scenarios from xP&A whose values are to be imported into CFP.

The selection options can be updated by clicking Refresh.

If your model spans more than one year into the future, specify how many extra years to include.

Optionally add a prefix or suffix to a specific dimension to control how values are mapped (e.g. for sub-ledger account differentiation).