Model entry PCC consolidation

Use Tabular Model entry PCC consolidate feature to automatically consolidate model entry data from different PCC child or core returns.

Note: This feature should only be run within PCC aggregated level return ie. not within PCC cell or PCC core return.

To begin:
1. Click Consolidate > Model entry PCC Consolidation function in the ribbon.

2. The PCC Consolidation screen consists of 2 grids:

Return selection grid
This grid only shows all returns (with PCC cell or PCC core status) with the same reference date and reference period type as the current return. Select the return to be consolidated in this grid.
QRT selection grid
In this grid, choose which model entry sheets in the current workbook should be consolidated into. By default, all model entry sheets are included for consolidation, but user can filter the list by deselecting the checked box.
Then click Run consolidation button to proceed.

3. Once the process is done, generated PCC consolidation report will be opened.

The population of the entity/rff/map code field

To distinguish what data comes from which return (cell or core) to PCC Aggregated level return RFF/Map code is converted according to settings in RFF tab in Return setup.
For example, if we select 2 cell returns to consolidate.

In Return Setup those two companies have this System codes F2 and F3 accordingly

So when consolidation will be finished RFF/MAP code will be converted for data from 1st return to F2 and for data from 2nd return to F3 (like on screnshot)