Data can be exchanged in both directions between Lucanet Consolidation & Financial Planning (CFP) and Lucanet xP&A (Extended Planning and Analysis). CFP provides actual data for planning in xP&A; modelled planning data can be transferred back from xP&A into CFP.
This guideline describes the end-to-end process and points to the detailed instructions for each step.
Before starting, ensure your xP&A models are built with the following in mind:
Prerequisite
Description
Variables will be mapped to GL accounts
Think about this upfront: The CFP assignment tables are used to map each output variable to the correct general ledger account.
Entity dimension must be present
Variables must be split by a dimension that can be mapped to CFP reporting entities or cost centers. Preferably, use the Organization element dimensions synced from CFP for a 1:1 match. Alternatively, a custom dimension can be used and mapped manually.
Work with output sections in your model
Create a dedicated section (e.g. "Sales outputs") containing only the variables you want to transfer back to CFP. This simplifies selection during data source configuration and reduces maintenance.
Configure accounting rules
Configure accounting rules since xP&A typically writes a one-sided posting (and debit/credit checks are always applied). You need contra entries to ensure balanced postings. Note: If you model out the full debit/credit logic in xP&A (e.g. when it comes to detailed revenue and working capital predictions), you can also work without accounting rules. In order to do so, select a different import type (e.g. transaction figures) during the data source configuration.