1. Objective and Scope

1.1. Objective of this Operation

The purpose of this activity is to extract reports that indicate the evolution of travel expenses recorded at cost centers.

1.2. Scope

This procedure applies to company 7523

2. Definitions

See Finance Glossary:

• Cost Center
• WP1

3. Tasks description

This activity is performed every D+5 of each month, for the GBU's:

• Novecare
• Soda Ash
• Aroma

3.1. I do the extraction of  the monthly report

In SAP, WP1 system, go to the transaction FBL3N 

Click on the icon  to select the variant

Use the following variant

Run the transaction 

Extract to excel:

Delete the first line 

At this point you should open the main file Grupo Drive T > MERCOSUR TEAM > RCS > Relatórios de Despesas de Viagens and Unhide 'base dinamica' sheet:

Copy and past all the extracted file on the base dinamica sheet, in a cumulative way. (last line)

After, pull all the formulas from column J - N until the last line filled with the new informations.

Now you have to update all the sheets with names:

Enter in each one and click inside of the pivot table, click in Options in PivotTable Tools, then Change Data Souce:

Update the information filling the last line

Then click Refresh:

You have to do this in all the sheets.

After update all, go to sheet 'Evolução dos gastos YYYY', where YYYY means the current year:

Here we have all the informations compiled. This data must be updated too.

Create a new table for the month you are reporting as below:

Change the month in the top:

Make sure that any cell is without errors.

Look if the table below is summing all the cells correctly:

In the right of the main chart, there are the total values hidden in white collor:

Here you can fill the total of the month reported, as same the other are. These informations will feed the main chart. 

After finished, you can send the report to Eduardo Conigero

Do not forget to hide the unnecessary sheets 'instrução', 'responsáveis' e 'base dinâmica'

End of document.