Tasks to be completed when documenting an operation (from creation to publication)

 1. Enter the Title of the operation / page

2. Add the following Labels : 

    • Scope of applicability: ww, country_accounting 

    • Country or group of countries (if applicable): belux, china, france, italy, lam, nam, uk_ie, bulgaria, dach, netherlands, iberia, poland, latvia, australia, india, japan, south_korea, thailand, singapore

    • Unit and Domain according to the List of labels to be used in the Finance Service Line space

      • E.g. 1: WW Operation in Financial Accounting under domain "Central Finance Processes & Compliance":
        • Labels to be used: ww, financial_accounting, central_fin_proc_compliance

      • E.g. 2: France Operation in Financial Accounting:
        • Labels to be used: country_accounting, france, financial_accounting
          (for country operations, the Domain is always country_accounting)


3. Fill in all fields as described above

 4. Once the description of the operation is completed, ensure it is approved and published by launching the SBS-Finance approval workflow 




Domain: Central Finance Processes & Compliance



Responsibility area: Analyze BFC packages re-opening requests


Table of contents 

By default the table of contents displays Heading 1 & Heading 2 (other levels can be added)



Scope

3. Remove the icon when not applicable


ERP

4. Remove the icon(s) when not applicable


Frequency

5. Remove the icon(s) when not applicable

 

References

6. Add the link to SAP transaction(s) (when it exists)


Forms

7. Insert the links accordingly and change the link text with the OP name


Attachments

8. Add the link to attachments or external links



Previous OP << >> Next OP



1. Objective and Scope

1.1 Objective of this Operation

The objective of this procedure is to show how to retrieve the data to the BFC reopening packages analysis.

1.2 Scope

2. Definitions

See Finance Glossary:

3. Tasks description

3.1. I collect worldwide data for BFC packages re-opening requests

3.1.1. BFC data

The BFC publication data is sent by e-mail everyday after the closure is done. Take the last one sent which have the most update file:

Open the file, make a filter by Publication Type and take only the corrections (this is the information about the re-openings)

3.1.2. Qliksense Data

The reopening data in qliksense will be available in the link Qliksense:

Click with the right bottom in the box with D4 Closure Details - MM YYYY → download as → and data 

And download the file:

In the file, the information about the re-openings after the deadline is in the column D:

3.1.3. Google Form Request Data

In the google drive all the re-openings requested by the robot are listed:

The information like package, company, period, type of adjustment will support to the analysis.


3.2. I compile data and statistics on BFC packages re-opening requests

3.2.1. Make the analysis


Make the pivot tables to compare the data in the 3 sources for re-openings in the quarter:





It is important to have the comparison between the quarters, to see if the numbers are increasing or decreasing:


Ps.: Profit in inventory is not considered as reopening for the analysis purposes, but the information should be in the presentation

The way to make the analysis can change due to the needs of the quarters, but it is important to have listed in the main information like reopening by region, type of adjustment

  
Keep the information by quarter as well:


Make a comparison between the quarters to see if the most re-opening companies remains the same, if so it need to be analyzed deeply.

3.2.2. Step 2 of Task 2


3.3. I compile data of top entries

3.3.1 Data sent by GAR


Every quarter the top entries should be listed in the same presentation of BFC re-openings:


Send an email to GAR team asking the list of top entries of the quarter



Use the file to make a table and inform it in the presentation comparing with the last quarter:



3.4. I compile data of Actual 0

3.4.1 Actual 0 Data

Ask for BFC admin team the report of the companies that were not published by the CAM. Open the file and categorize by the companies by region:

Create chart to show the percentage of companies that were posted by BFC Admin: 


Keep the comment about the the importance of publishing the actual zero to the consolidation process.


3.5. I share information on the BFC packages re-opening requests

Share the presentation with all the Finance Service Line






End of document.

 


Tasks to be completed when documenting an operation (from creation to publication)

 1. Enter the Title of the operation / page

2. Add the following Labels : 

    • Scope of applicability: ww, country_accounting 

    • Country or group of countries (if applicable): belux, china, france, italy, lam, nam, uk_ie, bulgaria, dach, netherlands, iberia, poland, latvia, australia, india, japan, south_korea, thailand, singapore

    • Unit and Domain according to the List of labels to be used in the Finance Service Line space

      • E.g. 1: WW Operation in Financial Accounting under domain "Central Finance Processes & Compliance":
        • Labels to be used: ww, financial_accounting, central_fin_proc_compliance

      • E.g. 2: France Operation in Financial Accounting:
        • Labels to be used: country_accounting, france, financial_accounting
          (for country operations, the Domain is always country_accounting)


3. Fill in all fields as described above

 4. Once the description of the operation is completed, ensure it is approved and published by launching the SBS-Finance approval workflow 




Domain: Central Finance Processes & Compliance



Responsibility area: Analyze BFC packages re-opening requests


Table of contents 

By default the table of contents displays Heading 1 & Heading 2 (other levels can be added)



Scope

3. Remove the icon when not applicable


ERP

4. Remove the icon(s) when not applicable


Frequency

5. Remove the icon(s) when not applicable

 

References

6. Add the link to SAP transaction(s) (when it exists)


Forms

7. Insert the links accordingly and change the link text with the OP name


Attachments

8. Add the link to attachments or external links



Previous OP << >> Next OP



1. Objective and Scope

1.1 Objective of this Operation

The objective of this procedure is to show how to retrieve the data to the BFC reopening packages analysis.

1.2 Scope

2. Definitions

See Finance Glossary:

3. Tasks description

3.1. I collect worldwide data for BFC packages re-opening requests

3.1.1. BFC data

The BFC publication data is sent by e-mail everyday after the closure is done. Take the last one sent which have the most update file:

Open the file, make a filter by Publication Type and take only the corrections (this is the information about the re-openings)

3.1.2. Qliksense Data

The reopening data in qliksense will be available in the link Qliksense:

Click with the right bottom in the box with D4 Closure Details - MM YYYY → download as → and data 

And download the file:

In the file, the information about the re-openings after the deadline is in the column D:

3.1.3. Google Form Request Data

In the google drive all the re-openings requested by the robot are listed:

The information like package, company, period, type of adjustment will support to the analysis.


3.2. I compile data and statistics on BFC packages re-opening requests

3.2.1. Make the analysis


Make the pivot tables to compare the data in the 3 sources for re-openings in the quarter:





It is important to have the comparison between the quarters, to see if the numbers are increasing or decreasing:


Ps.: Profit in inventory is not considered as reopening for the analysis purposes, but the information should be in the presentation

The way to make the analysis can change due to the needs of the quarters, but it is important to have listed in the main information like reopening by region, type of adjustment

  
Keep the information by quarter as well:


Make a comparison between the quarters to see if the most re-opening companies remains the same, if so it need to be analyzed deeply.

3.2.2. Step 2 of Task 2


3.3. I compile data of top entries

3.3.1 Data sent by GAR


Every quarter the top entries should be listed in the same presentation of BFC re-openings:


Send an email to GAR team asking the list of top entries of the quarter



Use the file to make a table and inform it in the presentation comparing with the last quarter:



3.4. I compile data of Actual 0

3.4.1 Actual 0 Data

Ask for BFC admin team the report of the companies that were not published by the CAM. Open the file and categorize by the companies by region:

Create chart to show the percentage of companies that were posted by BFC Admin: 


Keep the comment about the the importance of publishing the actual zero to the consolidation process.


3.5. I share information on the BFC packages re-opening requests

Share the presentation with all the Finance Service Line






End of document.