1. Objective and Scope

1.1. Objective of this Operation

The aim of this document is to provide an operational guide for the SAP/R3 ERP PF1 environment concerning the management of bank accounts for the ES and PT companies. 
This procedure allows you to transfer the balances or movements of the bank accounts belonging to companies linked to the business group, to a single centralizing cash account in company 3454.

1.2. Scope

This procedure is applicable for the following companies:

• SPAIN

• 0245 - SOLVAY QUIMICA (ES)
  

• 3396 - ELECTROL. DE TORRELAVEGA
3454 - SOLVAY IBERICA
PORTUGAL0306 - SOLVAY PT PROD QUIM 
Note: 
For Martorell, company 5696, the procedure is performed by Local Finance 

• 
  

  Note
  title Note

  
  
  

2. Definitions

See Finance Glossary:

• ERPCAM
• PF1

3. Tasks description

3.1. Periodicity

This procedure must be done on a daily basis. 

3.2. Responsibilities

RtR BO (change RtR BO)FO: 

• Apply the procedure;
• Analyze and provide feedback to Front Office  (change front office) about to CAM about the discrepancies and issues encountered;
• Update the procedure whenever is necessary. 

3.3. I manage the bank accounts

3.3.1. I extract the bank statements from BBVA

(please confirm the title)

Netcash

To have access to the bank statements enter in the website of BBVA Netcash.

To login use the following credentials:

• "Cód. Empresa o Institución" – 20034107
• "Cód. Usuario" - SOLVAY
• "Clave de acceso" - Solvay3 

Image Added

Once logged in choose:

• Información de Cuentas|
• Módulo de tesorería

Image Added
Image Removed 
Image Removed
When the page is displayed choose:

• "Estado" - Histórico"Rango de fechas" – Previous dayPendientes
• "Tipo de ficheros" – TODOS (always)

NOTE:
If the previous day is a Friday you must perform the task also for Saturday and Sunday. This means that on Mondays the procedure should be done with a date from Friday to Sunday but for the posting date you must consider is the last working day (Friday). 
Next, it will ask you to choose the files to extract:

Image AddedImage Removed

You must always select "MARCAR TODOS" and click "GENERAR FICHERO".
It will display another screen asking if you want to receive the file. Select "RECIBIR FICHERO" and save it to your computer: Image Removed

Image Added

The document will be, by default, saved under name "ModuloTesoreria.ISM".

3.3.2. I run the process BBVA Torrelavega

Once you have the file with the bank movements, go to SAP and enter in transaction ZE1FGESTBARRI. 
Next, choose one by one the sites to which we will run the procedure. 

Image RemovedImage Added 

Select Process BBVA TORRELAVEGA (company 0245) and execute the transaction Image Removed. 

Another screen is displayed with additional fields to change:

• "Posting Date" – Date of the posting (previous day same as the extraction in NETCASH 

  /

  Warning
  If the previous day is a Friday, consider the date of posting the working day of Friday

  );

  .

  
  

• "File name" – Go to your computer and select the file extracted from NETCASH.

For the remaining fields, no change is done:

• "Company Code" – Fixed fields (0245)
• "Solvay Acc. Number in BBV" – Bank account Number (always the same).
• "Financial Acc for Solvay" – G/L account associated (always 591EUR345450601EUR30 and 50603EUR30).

Image RemovedImage Added

Execute the transaction by clicking on Image Removed and on  and a list of documents will be produced: 

Image Removed 

This does not mean that the documents were posted. The transaction generates batch inputs that have to be processed in SM35. Normally the batch codification is similar to ZEBARBBV***/ ZEBARRI2*** (where **** is the company code). Image Removed  ZEBARRI20245

Image Added 

Once the batch input is processed the documents posted will be similar to: Image Removed

3.3.3. I

Image Removed

Image Removed

perform the Traspaso Agrupado

Go To FBL3N:

G/L account 5080900000

Company Code 0245

Actual date

Layout:  /ES0245_BANK

Make a filter by text TRASP. AGRUPADO TRASP. ORI: 4649-001-0001850 46490

Image Added

And then update all the information on template Trnsf 245 Conta 5080900000 p. 50603EUR30 and make the posting on transaction ZZF_POSTING_FILE.

3.3.4

• "Posting Date" – Date of the posting (previous day same as the extraction in NETCASH / If the previous day is a Friday, consider the date of posting the working day of Friday);
• "File name" – Go to your computer and select the file extracted from NETCASH.

For the remaining fields, no change is done:

• "Company Code" – Fixed fields (3454)
• "Solvay Acc. Number in BBV" – Bank account Number (always the same).
• "Financial Acc for Solvay" – G/L account associated (always 591EUR3454).

Image Removed

Execute the transaction by clicking on Image Removed . A list of documents will be produced and the batch inputs created. Go to SM35 and process the batch inputs generated (as explained previously).

3.3.4. I run the process BBVA Portugal

Go back to the main transaction ZE1FGESTBARRI and select "Process BBVA Portugal" to account the bank movements in company 0306 and its reflections in company 3454: 

Image Removed 

Execute the transaction Image Removed and in the screen displayed change the following fields:

• "Posting Date (DDMMAA)" – Date of the posting (previous day same as the extraction in NETCASH / If the previous day is a Friday, consider the date of posting the working day of Friday);

• "Solvay Acc. Number in BBV" – Bank account Number (always the same)
• "Financial Acc for Solvay" – G/L account associated (always 591EUR3454)
• "Cta. Sap BBV non-resident" – G/L account associated to the movements (50601EUR30)

Image Removed

Once you execute the transaction it will request you to search for the file extracted from NETCASH.
Once selected the transactions will show you the list of documents produced and the batch inputs will be created. 

Image Removed 

Go to SM35 and process the batch inputs generated.

Image Removed 
NOTE:
When performing the procedure for Portugal, you are performing postings in the Portuguese companies and in 3454. 
Due to this if you need to cancel any document related to Portugal you have to cancel both sides (PT company and 3454), the data in the bank and the data in the financial account.

. I perform the final check

As a final check you should open again BBVA net cash and select:

• "Saldos y movimientos"
• Select the bank accounts of the company for which you want to display the information;

Image Added

• In  account as In Image Removed as we are performing the postings related to the previous day select it in the "Rango de Fechas" (Desde/Hasta)
• And click on Image Removed on  .

Image AddedImage Removed


With this you will be able to see all the bank movements that existed for the company on the previous day and the final balance of the account. Image Removed

Image Added

For this procedure procedure is relevant update all the relevant information on the template 0245_50601EUR30_BBVA_es1501824649840010018672. 

is the one with description "TRASPASO DE APUNTES AGRUPADOS". 
At the same time, go to transaction FBL3N in  in SAP, using variants::

• G/L Account 50601EUR30 and 50603EUR30 one at a time;
• Company Code
• ES_BARRIDO to check all companies with movements with 3454;
• ES_BARRIDO3454 to check all the postings done in company 3454, with all companies0245.
• Posting date: previous day
• Layout:  /ES0245_BANK

Then you may confirm that in the centralizing account of company 0245 you find the related movements: Image Removed

Image Added

Also in company 3454, you should find reflected in the company all the movements highlighted: 
Image RemovedFBL3N make a extraction go to » List » Export » Local File » Spreadsheet and save as xls:

Image Added

Now you can match with all the information on templates

0245_50601EUR30_BBVA_es1501824649840010018672 for G/L account 50601EUR30

0245_50601EUR30_BBVA_es1501824649840010018504 for G/L account 50603EUR30

End of document.