Group Accounting & Reporting




1. OBJECTIVE AND SCOPE

1.1   Objective of this Procedure

This procedure describes the ACTUAL 0 Management process in BFC and the further actions required.


1.2 Scope 


This procedure applies to the BFC Administration team.


2. REFERENCE DOCUMENTS

3. DEFINITIONS

GAR Team - Group Accounting & Reporting Team

BFC-Admin Team - Business Objects Financial Consolidation (Solvay's Group ConsolidationTool) Administration Team

CAM - Company Account Manager

CBCR - Country By Country Report

SU FA - Service Unit Financial Accounting

IG - Full Consolidated

IP - Proportional Consolidation

ME - Equity Method

NC - Not Consolidated

4. SUMMARY 

4.1 Principle and Context 

The ACTUAL0 is a Category used to report statutory figures, what enables to build the Shareholding structure of the Solvay Group, which becomes available in the Solvay Shareholding Structure site.

In this category are concerned either Consolidated and Not Consolidated companies. The information collected for each type of company is different, thus the documents available for them are different, as the described below:


Consolidated Companies

L4005 Investment - This document reports the number of shares that the company holds per affiliate, as well as the the number of shares that the affiliate has issued, then it is possible to know the percentage owned by the reported company. If there is any variance it is explained by flow.

L4000 Impairment (Statutory data) - This document reports the information for the impairment process on financial assets.

L4020 Shareholder's equity - This document reports the numbers of shares issued, split by mother companies. If there is any variance it is explained the variation by flow.

L4060 CBCR - Revenues and headcount - This document reports the Revenues the company had in the previous year split by trading partners. As of 2021 it was decided not collect this information in BFC. 


Not Consolidated Companies

L4005 Investment - In most of cases, the Not consolidated companies do not have affiliates, hence this document is empty.

L4020 Shareholder's Equity - This document details the information about the mother company of the entity (number of shares hold).

L4050 Financial information – This document reports the Balance Sheet and Income Statement of the entity. No detail is asked, no flow and no activity.


4.2 Responsibility

The Corporate Secretary is responsible to communicate the changes in the Solvay's structure that are performed in the PRS System.

The GAR team communicate through the Structure File, available in the GAR AODOCs Library, the changes in the Solvay's Structure.

The BFC Administration team is responsible to maintain any necessary update in ACTUAL0 category.

The CAM is responsible to enter the information in this category for the companies under his/her scope.

The SU FA is responsible to perform the quarterly checks from D1.


4.3 Overview 

At the beginning of the year the ACTUAL0 category has to be created for the current year. By principle, there is only one category per year, which is set for December (ACTUAL0 - YYYY.12).

Package generation - The list of companies to start with should correspond to the perimeter published in the Y-1 annual report. For the companies entering in the scope during the year, package should be generated as soon as the company is created in BFC following the official communication from Corporate Secretary. 

The packages stay opened along the year to allow the CAM to update the information when necessary. However, every quarter the packages have to be published and locked during two days, to allow the SU-FA Team to analyze the data and make corrections.

ACTUAL0 12.YYYY – Quarterly procedure   

  

Note: In Q1, NC companies should be excluded of the publication done by BFCAdmin on D1. NC companies are required to fill ACTUAL0 package only from Q2. 

Conso automatic run scheduling - every quarter on D1 and D2 scheduling of ACTUAL0 for SOLVAY14 V2 and SOLFULL and their related Reconciliation consos. 4 times a day 8am / 12 am / 4 pm / 10 pm.


ACTUAL0 REPORTING SETUP

The process by which data is reported is defined in the Reporting Organizer and RU Organizer. In these modules it can be defined:

  • Which reporting units should send packages and when.
    • This consists of establishing a work schedule (start and end dates for sending packages), in the Reporting Organizer, and a list of the reporting units sending the packages, in the RU Organizer.
  • Define the data entry environment.
    • Define the data entry schedules, opening balances, processing operations, controls and restrictions.
  • Manage how opening packages are generated.

After the Reporting Organizer and RU Organizer are defined the packages should be transferred to the Package Manager module, to allow the user to enter the necessary reporting data.


When there is a new company it must be created a Package for it in this category, according to the operations of companies along of the year.


ACTUAL0 SCOPES OF CONSOLIDATION

Then the Scopes for this Category have to be created. A Scope enables to group together the reporting units to be included in the consolidation process and select the consolidation method to be applied. 

For the ACTUAL0 there are two specific scopes of consolidation:

  • SOLFULL - Contain all Solvay Companies (consolidated or not). All companies are integrated at 100%.
  • SOLCONSO - Contain all Solvay Companies (consolidated or not). The companies are integrated at their ownership rate.


These Scopes should be updated according to the operations of companies along of the year.


ACTUAL0 CONSOLIDATIONS SETUP

It has to be defined three Consolidations for the ACTUAL0 category:

  • SOLFULL - To consolidate all the companies of the Group at 100%.
  • SOLCONSO - To consolidate all the companies of the Group at their ownership rate.
  • SOLVAY14 - To consolidate all the Consolidated companies.


All the Consolidations need to be updated on Quarterly basis, when the Conversion Rate Period should be changed to the one in reference.

Additionally, the Consolidation SOLVAY14 needs to have the Scope Period updated, as well, to the one in reference.


5. REPORTING SETUP

5.1 REPORTING SETUP - Reporting Organizer

In the Reporting Organizer module it is created the Category for the period (Reporting ID) and is defined the common data for the packages, as the Deadline, Folder, Set of Controls, Opening Balances, etc.


To create a new Reporting ID for the period, select the one of the previous year in the field Select Reporting IDs.

In this example, it is being created the category for 2017, so it was select as reference the category of 2016 (ACTUAL0 - 2016.12)

Then in Reporting Organizer module Open it and Save As.







The General tab defines the general properties of the reporting ID.

Enter the following information:

  • Category - ACTUAL0
  • Data entry period - YYYY.12
  • Short & Long description - Shareholding - YYYY.12





The Definition tab indicates the reporting status. It can also be specified the associated category scenario and the start and end dates for the reporting.

Enter the following information:

  • Version: A1403.
  • Start & End Date: It can be specified the scheduled start and end dates. The reporting status depends on these dates. Enter a large range, e.g. January 1st of current year to March 1st next year.








The Package tab defines the settings of the data entry environment for the packages.

Enter the following information:

  • Windows and Internet folder: ACTUAL0 - The documents that will be available for the company in this phase.
  • Internet-specific folder: ACTUAL0 - The documents that will be available for the company in this phase.
  • Set-of controls: ACT0-IG - The controls that are set to check the package data for this phase.
  • Control level to be reached: Q - This field needs a special attention, because if any the previous field is changed this one is deleted, always ensure it is filled properly.
  • Blocking - Flag the option Blocking.
  • Category: ACTUAL0.
  • Data entry period: YYYY.12 - Inform the period which the opening balances are retrieved. Always December of previous year.
  • Scope: SOLVAY14- This scope is taken into account just the consolidated companies.
  • Variant: 2 - This information is related to the consolidation rules, in this instance is the variant 2, which considers the IFRS Norms.



The Restrictions tab defines the data entry restrictions which are applied when the data is entered.

The flow F00 (Opening Balances) must be informed in Read-only Flows, this way it will not be available for edition in the package.



The Operation tab defines the settings to publish the packages. 

In the Deadline it has to be informed the date that the packages will have to be published.

It has to be changed each quarter, according to date defined in the Calendar available in the GAR AODOCs Library.



The Translation tab defines the object descriptions for the selected language. 

Both French and English should be informed: Shareholding - YYYY.12



5.2 REPORTING SETUP - RU Organizer

In the RU Organizer is defined the companies to be reported in the category.


Select all packages in the RU Organizer module from the previous year (Ctrl+A), and copy (through the icon  or Ctrl+C).




Change the period to the one that is being created and paste packages (through the icon  or Ctrl+V).

Then the reporting packages are created in RU Organizer module.

Note that the packages will have the status , meaning that they are still not available in the Package Manager module.



Before Generate the packages to the Package Manager module, ensure that all the companies are with the correct Consolidation Method (column Entity Portfolio), and if any company needs either to be added or deleted.



To make the reporting available in the Package Manager module, select all packages and with the right click choose "Generate Package at Current Site".





The package status changes to , meaning that the package are now available in the Package Manager module.






5.3 REPORTING SETUP - Package Manager

After Generate the Package to the Package Manager module, they will be available for the users to enter the data for the companies under their responsibility.

In this module it is done the follow-up on the package status (Empty, Changed, Published or Integrated). Then it is possible to check if any company is missing to report the necessary information.


6. SCOPES OF CONSOLIDATION

6.1 SCOPES OF CONSOLIDATION - SOLFULL

The Scope SOLFULL contains all the companies of the Group, either Consolidated or Not Consolidated. The rate of all companies in this scope are set at 100%.

It is defined one scope SOLFULL per year and it must be updated when there is a company operation (New company or End of a Company).


The scope is created in the BFC FC_Top, with reference to the one of the previous year.

For this, open the last version available of the scope and select the option Save As.


In this example, to create the scope for 2017, it was created as reference to the scope of 2016.


Enter the information necessary to create the new period.

  • Code: SOLFULL
  • Period: YYYY.12
  • Version: S-1



Then the scope for the new period will have been created.

Note that this scope only allows companies set as Full (FC), this way when there is the end of a company and its Consolidation Method is changed to Not Consolidated the company is automatically exclude from the scope.

Even though, in the step Scope, ensure that all companies that left the Group in the previous year are not present in the scope for the current period.


After all the information is validated the scope has to be transferred to the BFC FC_Prod platform.


6.2 SCOPES OF CONSOLIDATION - SOLCONSO

The Scope SOLCONSO contains all the companies of the Group, either Consolidated or Not Consolidated. The rate of the companies in this scope are set at their ownership rate.

It is defined one scope SOLCONSO per year and it must be updated when there is a company operation (New company or End of a Company), as well when a company changes its ownership rate.

The scope is created in the BFC FC_Top, with reference to the one of the previous year.

For this, open the last version available of the scope and select the option Save As.


In this example, to create the scope for 2017, it was created as reference to the scope of 2016.


Enter the information necessary to create the new period.

  • Code: SOLCONSO
  • Period: YYYY.12
  • Version: S-1


In the step Definition, update the period informed in the Opening Scope to the previous year.


In this example, it was informed the period 2016.12, since it was being created the scope for 2017.

By changing the Opening Period in the step Definition, all the companies that were set as Not consolidated with the rate at 0% in the previous year are automatically excluded from the scope.

Even though, in the step Scope, ensure that all companies that left the Group in the previous year are not present in the scope for the current period.


After all the information is validated the scope has to be transferred to the BFC FC_Prod platform.


6.3 SCOPES OF CONSOLIDATION - Transfer from FC_TOP to FC_Prod


BFC FC_Top

In the Administration domain select the Task List module, then open the object EXPL-ADMIN.



Click on the icon  New Transferable Object to select the type of object to be transferred.


Select the option Scope Builder.


Then within the object to be transferred, it has to be select the items.

Click on the button Select Items  and select the scopes to be transferred.

In this example, the scopes SOLCONSO 2017.12 and SOLFULL 2017.12.


It will came back to the tab Definition of the screen EXPL-ADMIN and will be shown the items selected to be transferred.

After have all items selected Save the task and close it.


With the right click on the object EXPL-ADMIN select the option Start. After this step the task has been transferred to the BFC FC_Prod platform.


BFC FC_Prod


In the Administration domain select the Task List module, select the SCAN object with right click over it select the option Start.


Then a new object will be available in Receive Objects.


Open the new object and ensure that the items are those selected in BFC FC_Top.


With the right click on the object select the option Start to run the process.


After the process finishes, validate if the the Scope was properly transferred to the Scope Builder module.


7. CONSOLIDATIONS SETUP

There are 4 consolidations for the ACTUAL0 category:

  • SOLFULL V2- To consolidate all the companies of the Group at 100%.
  • SOLCONSO V1 - To consolidate all the companies of the Group at their ownership rate. For doc L4050 - Data for NC companies.
  • SOLVAY14 V1- To consolidate all the Consolidated companies. For doc L4060 - CBCR revenues.
  • SOLVAY14 V2- To consolidate all the Consolidated companies. For doc L4000 - Impairment data.

To create a consolidation it can be done from the scratch or with reference to the version of the previous year through the Save As option.


The management of Consolidations is done in the Consolidation module within the Operation domain.

The consolidations are set for the category period, which should be informed in the field Select Report IDs, in this example ACTUAL0 - 2020.12.



To create a consolidation from the scratch select the option Consolidation Definition.


To create the consolidation with reference to another one, open the consolidation of the previous year/ period, and within the menu File choose the option Save As.

Through this option all the information are retrieved from the previous consolidation, hence the some information need to be update according to the new period.

 

7.1 CONSOLIDATIONS SETUP - SOLFULL

In the tab General should contain the following information:

  • Category: ACTUAL0
  • Data entry period: YYYY.12
  • Scope: SOLFULL
  • Variant: 2
  • Currency: EUR 
  • Long Description: Full Scope 100% - For doc L4005/L4020 - Shareholding structure

 

In the tab Properties should contain the following information:

  • Scope Period: YYYY.12
  • Version: S-1
  • Set of rules: 0C-IFRS-2103
  • Multiply thresholds by: 1
  • Conversion Rate Period: YYYY.MM
  • Conversion Rate Version: REEL


 

In the tab Opening Balances should contain the following information:

  • Category: ACTUAL0
  • Data entry period: YYYY.12 - Enter the previous year 
  • Scope: SOLFULL
  • Variant: 2
  • Currency: EUR
  • Source period: YYYY.12 - Enter the previous year


The information in the other tabs is generated automatically.

 

7.2 CONSOLIDATIONS SETUP - SOLCONSO

In the tab General should contain the following information:

  • Category: ACTUAL0
  • Data entry period: YYYY.12
  • Scope: SOLCONSO
  • Variant: 2
  • Currency: EUR 
  • Long Description: Full Scope Ownership rate - For doc L4000 - Impairment data

 

In the tab Properties should contain the following information:

  • Scope Period: YYYY.12
  • Version: S-1
  • Set of rules: 0C-IFRS-2103
  • Multiply thresholds by: 1
  • Conversion Rate Period: YYYY.MM
  • Conversion Rate Version: REEL

 

In the tab Opening Balances should contain the following information:

  • Category: ACTUAL0
  • Data entry period: YYYY.12 - Enter the previous year 
  • Scope: SOLCONSO
  • Variant: 2
  • Currency: EUR
  • Source period: YYYY.12 - Enter the previous year


The information in the other tabs is generated automatically.

 



7.3 CONSOLIDATIONS SETUP - SOLVAY14

In the tab General should contain the following information:

  • Category: ACTUAL0
  • Data entry period: YYYY.12
  • Scope: SOLVAY14
  • Variant: 2
  • Currency: EUR 
  • Long Description: Conso Scope - For doc L4000 - Impairment data



 

In the tab Properties should contain the following information:

  • Scope Period: YYYY.MM - Set for the quarterly closing of reference

Version: S-4

  • Set of rules: 0C-IFRS-2103
  • Multiply thresholds by: 1
  • Conversion Rate Period: YYYY.MM
  • Conversion Rate Version: REEL


 

In the tab Opening Balances should contain the following information:

  • Category: ACTUAL0
  • Data entry period: YYYY.12 - Enter the previous year 
  • Scope: SOLVAY14
  • Variant: 2
  • Currency: EUR

Source period: YYYY.12 - Enter the previous year


The information in the other tabs is generated automatically.


 

7.4 CONSOLIDATIONS SETUP - Quarterly Update

On a quarterly basis the periods of the Scope and the Conversion Rate in the consolidation should be updated to the one in reference.

In the tab Properties update the following fields:

  • Scope period 
  • Conversion rate period

 

8. COMPANIES OPERATIONS

8.1 COMPANIES OPERATIONS - New Companies

When the group acquires a new company, a package has to be created in the ACTUAL0 Category.

To create the package ensure that the company has already been created in BFC, otherwise follow the instructions in the Procedure:


After the communication from the Corporate Secretary, the information about the concerned company should be available in the Structure File available in the GAR AODOCs Library.


As example, it will be used the company 63280 COGENERATION ROSIGNANO S.p.a., which was acquired in January 2017.


In the BFC FC_Prod, enter in the category for the correspondent period.

In this example ACTUAL0 – 2017.12.


Within the Operation domain select the RU Organizer module.

Click on the icon  Insert Reporting Units to create the package for a new company.


Enter the BFC Code of the new company.


The package will be available in the RU Organizer module, and information needs to be confirmed before generate to the Package Manager module.

Open the package information and validate if the settings are in accordance to the Consolidation Method of the company.

By default, when a package is added through the Insert Reporting Units option, the definitions are the same than the Category created in the Reporting Organizer module, it means, the package has the definitions of a Consolidated company. Then if the new company is a not consolidated, the definitions have to be changed.


In the tab Roadmap enter the following information:

Data entry site: 0000.PROD001

Data entry Currency: The company currency

Publication site: 0000.PROD001


In the tab Package it will be informed what determines the documents that are shown at the company's package, as well as the set of rules (Validations), opening balance, and the Scope that the company is assigned on this phase.

Since the information collected for a Not Consolidated and a Consolidated company is different, this tab has some specification for each type of company.


Not Consolidated Company

Windows and Internet folder: ACTUAL0-FI - The documents that will be available for the company in this phase.

Internet-specific folder: ACTUAL0-FI - The documents that will be available for the company in this phase.

Set-of controls: ACT0-FI - The controls that are set to check the package for this phase.

Control level to be reached: Q - This field need a special attention, because if any the previous field is changed this one is deleted, always ensure it is fulfilled properly.

  • Blocking - Flag the option Blocking.

Category: ACTUAL0.

Data entry period: YYYY.12 - Inform the period which the opening balances are retrieved. Always December of previous year.

Scope: SOLFULL - This scope is taken into account all the companies in the Group's structure.

Variant: 2 - This information is related to the consolidation rules, in this instance is the variant 2, which considers the IFRS Norms.

Consolidation currency: EUR - The Group Consolidation Currency, always EUR, regardless the company currency.




Consolidated Company

Windows and Internet folder: ACTUAL0 - The documents that will be available for the company in this phase.

Internet-specific folder: ACTUAL0 - The documents that will be available for the company in this phase.

Set-of controls: ACT0-IG - The controls that is set for the company for this phase.

Control level to be reached: Q - This field need a special attention, because if any the previous field is changed this one is deleted, always ensure it is fulfilled properly.

  • Blocking - Flag the option Blocking.

Category: ACTUAL0.

Data entry period: YYYY.12 - Inform the period which the opening balances are retrieved. Always December of previous year.

Scope: SOLVAY14- This scope is taken into account just the consolidated companies.

Variant: 2 - This information is related to the consolidation rules, in this instance is the variant 2, which considers the IFRS Norms.

Consolidation currency: EUR - The Group Consolidation Currency, always EUR, regardless the company currency.


The tab Restrictions is automatically filled, but it is necessary to confirm that the option Read-only flows is set for the F00, this means that the opening balances are not available for edition.

Then save .



All the other tabs are automatically filled.




Outside the package creation/edition screen, make sure all the information is compliant.

At this stage the package is created at the "RU Organizer" module.

Its status is: The package has not been generated.



To generate the package, choose with right click the option: Generate Package at Current Site.


Then status will be changed, meaning that the package is now available at the "Package Manager" module, thus available for the users that have access for this company at this phase.


8.2 COMPANIES OPERATIONS - End of Companies

Reporting Setup


Generally, for the companies that left the Group during the course of the year, the packages remain in the ACTUAL0 - YYYY.12, however at the beginning of the next year the packages should not be generated.

A long the year the packages of these companies should stay Protect, instead locked, this way it is possible to identify the companies that left the Group.


Scope of Consolidation


When a company left the Group, the company should be updated in the Scope of Consolidation.

The companies should be set as Not Consolidated and the rate 0%.

The updated should be done in the three scopes:

  • SOLCONSO
  • SOLFULL
  • SOLVAY14

Either SOLCONSO and SOLFULL, concerns all companies, this way regardless the consolidation method of the company, it should be excluded from these scopes. It is not necessary to create an intermediate package for the company in the tab Incoming/Outgoing of the scope.

While in the scope SOLVAY14 there are only Consolidated companies, it means that just the companies IG, IP and ME can be excluded from this scope, and it should be created the intermediate package for these companies in the tab Incoming/Outgoing of the scope.

For more details of operations in the scope SOLVAY14, see the procedure: 



8.3 COMPANIES OPERATIONS - Change of Consolidation Method

The change of the method of consolidation concerns the transition from the Not Consolidated/ Equity Method/ Proportional to Full Consolidated, or vice versa. In other words, this transition is assimilated to either an increase or decrease in the rate of integration.

As soon as a company change its consolidation method the information to be reported is different, hence its setup needs to be updated accordingly, as well as the reporting setup and the scope of consolidation.

The change of consolidation method should be communicated by the Corporate Secretary and the information needs to be available in the Structure File within the GAR AODOCs Library.


Reporting Setup


In the FC_Prod, enter in the category for the correspondent period, in this instance, it should be ACTUAL0 – 2017.12.

Within the Operation domain select the RU Organizer module and open the company to be updated.



In the tab Package it will be informed what determines the documents that are shown in the company's package, as well as the set of rules (Validations), opening balance, and the Scope that the company is assigned on this phase.

The information in this tab has to be updated according to the new consolidation method.


Not Consolidated Company

Windows and Internet folder: ACTUAL0-FI - The documents that will be available for the company in this phase.

Internet-specific folder: ACTUAL0-FI - The documents that will be available for the company in this phase.

Set-of controls: ACT0-FI - The controls that are set to check the package for this phase.

Control level to be reached: Q - This field need a special attention, because if any the previous field is changed this one is deleted, always ensure it is fulfilled properly.

  • Blocking - Flag the option Blocking.

Category: ACTUAL0.

Data entry period: YYYY.12 - Inform the period which the opening balances are retrieved. Always December of previous year.

Scope: SOLFULL - This scope is taken into account all the companies in the Group's structure.

Variant: 2 - This information is related to the consolidation rules, in this instance is the variant 2, which considers the IFRS Norms.

Consolidation currency: EUR - The Group Consolidation Currency, always EUR, regardless the company currency.




Consolidated Company

Windows and Internet folder: ACTUAL0 - The documents that will be available for the company in this phase.

Internet-specific folder: ACTUAL0 - The documents that will be available for the company in this phase.

Set-of controls: ACT0-IG - The controls that are set to check the package for this phase.

Control level to be reached: Q - This field need a special attention, because if any the previous field is changed this one is deleted, always ensure it is fulfilled properly.

  • Blocking - Flag the option Blocking.

Category: ACTUAL0.

Data entry period: YYYY.12 - Inform the period which the opening balances are retrieved. Always December of previous year.

Scope: SOLVAY14- This scope is taken into account just the consolidated companies.

Variant: 2 - This information is related to the consolidation rules, in this instance is the variant 2, which considers the IFRS Norms.

Consolidation currency: EUR - The Group Consolidation Currency, always EUR, regardless the company currency.




Scope of Consolidation


Within the Operation domain, select the Scope Builder module and open the scope SOLCONSO, then choose the company that needs to be updated and change:

  • Financial Interest at Closing: Enter the rate
  • Ownership Interest at Closing: Enter the rate
  • Method at closing: Select the new method of consolidation




In the scope SOLVAY14, if a company changes from Not Consolidated to Consolidated the company needs to be added to the scope. For this, within the scope, click on the button Insert Reporting Units  and enter the company code and rates.

If the company was already present in the scope and changed the consolidation method, its information needs to be updated in accordance to the new method.



When a company change its Consolidation Method no action is needed in the Scope SOLFULL, since all companies are set as Full Consolidated.



9. PACKAGES QUARTERLY BACK-UP

As of June 2020, this procedure is no longer applicable.

It was justified in the past when GAR was managing manually each quarter corrections in ACTUAL0 not completed properly by CAM and the back up of situation before corrections was a way to avoid any debate on GAR corrections with CAM.

Since months, quality of ACTUAL0 completion has improved and based on quarterly checks from SU FA, any error has to be corrected in the pack by the Cam itself. 

In addition, those back ups are not used by anyone else.

To create the category for the period in reference follow the steps of the topic 5.1 REPORTING SETUP - Reporting Organizer.


To create the packages, copy the packages from the ACTUAL0 - YYYY.12 category of the consolidated companies. Follow the steps of the topic 5.2 REPORTING SETUP - RU Organizer.


To extract the data from the ACTUAL0 - YYYY.12 category, select the packages and with right clink choose the option Export.


Then select the format TXT and the path to save the file. Then click on Next.



Keep all dimensions flagged:

  • Category
  • Data entry period
  • Reporting unit

Then click on Next.


Keep all data flagged:

  • Package amount
  • Comment

Then click on Export.


Open the extracted file and replace the period (Ctrl+H), from YYYY.12 to the current period, then click on Replace All, save the changes and close the file.

In this example the upload will be done for the period 2017.06.


Select the category that the upload will be done, in this example ACTUAL0 - 2017.06.

Within the menu File choose the option Import.



Select the source File, keep flagged the data columns Package Amount and Comment. 

Then click on Next.


Select the file, through the option Browse it can be select the file, where it was saved.

Then click on Next.


Select the Column Separator, in this instance the file was separated by Tabs, but it could be Semicolon, Comma, etc.

Then click on Next.


Keep flagged the options:

  • Run package rules
  • Run Controls

Through this options the package is automatically saved and it is possible to know if the package has no blocking control and can be published.



Check in the column Control Status, the packages should have the status Balanced or Balanced with Warnings .

If there are packages with the status Unbalanced , it must be analyzed.

Validate if the flow F99 was properly copied.


After all validations, select the packages to be published, and with right click choose the option Publish.


Choose the option Publish after validation packages and Standard publication mode.

These options grant that the packages are validated (without blocking controls) and the published by Standard mode, meaning that will be locked after the publication.





The status of the packages will change to Published , then they have to be integrated.

So select the packages and with right click choose the option Integrate.




These packages need to be Protected in order to prevent any changes being made to them. 

After Integration, packages status has changed to Locked, and now, they must be Unlocked before they can be Protected.

So, select all the packages and with right click choose the option Unlock Package.


Select all the packages and with right click choose the option Protect.

10. OTHER ACTIONS

10.1 OTHER ACTIONS - Create New Companies

When it is communicated a new company, the new company has to be added to the GAR List and created in BFC as well. After it is created in BFC it has to added to the users filter of view, to allow them to enter the necessary data in the packages.

To ensure this additional actions, follow the procedure:




The conclusion of this procedure allows to have the well management of the ACTUAL0 category. This way, the end users are capable to enter the data in this category for the companies under their scope, and hence the GAR Team can build an accurate Shareholding Structure for the Solvay Group.


END OF PROCEDURE