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: Country Accounting



Responsibility area: N/A


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

(To be filled!)(error)

Frequency

5. Remove the icon(s) when not applicable

 (To be confirmed!)(error)

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

BBVA Netcash


To be filled! << >> To be filled!



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

  • PORTUGAL
    • 0306 - SOLVAY PT PROD QUIM 
      Note: 
      For Martorell, company 5696, the procedure is performed by Local Finance 


2. Definitions

See Finance Glossary:


3. Tasks description

3.1. Periodicity

This procedure must be done on a daily basis. 

3.2. Responsibilities

RtR BO (change RtR BO)(error): 

  • Apply the procedure;
  • Analyze and provide feedback to Front Office  (change front office)(error) 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 Netcash (please confirm the title)(error)

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 


Once logged in choose:

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


 




When the page is displayed choose:

  • "Estado" - Histórico
  • "Rango de fechas" – Previous day
  • "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:



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: 

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. 

 

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

Another screen is displayed with additional fields to change:

  • "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 (0245)
  • "Solvay Acc. Number in BBV" – Bank account Number (always the same).
  • "Financial Acc for Solvay" – G/L account associated (always 591EUR3454).



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

 


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). 

 

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

3.3.3. I run the process BBVA Barcelona

Once the process is finished for Torrelavega the same has to be done for BARCELONA, which includes company 3454 and also the process for the Portuguese company 0306. 
This process is done in two parts using transaction ZE1FGESTBARRI:
Select "Process BBVA Barcelona" to select all bank movements in company 3454 and execute the transaction  . 

 


In the screen displayed change the following fields:

  • "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).


Execute the transaction by clicking on  . 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: 

 

Execute the transaction  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);


For the remaining fields, no change is done:

  • "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)


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. 

 


Go to SM35 and process the batch inputs generated.

 
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.

3.3.5. 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;
  • In  as we are performing the postings related to the previous day select it in the "Rango de Fechas" (Desde/Hasta)
  • And click on  .





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. 


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

  • ES_BARRIDO to check all companies with movements with 3454;
  • ES_BARRIDO3454 to check all the postings done in company 3454, with all companies.
  • Posting date: previous day


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


Also in company 3454, you should find reflected in the company all the movements highlighted: 


End of document.