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


Frequency

5. Remove the icon(s) when not applicable

   

References

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

ZE1FGESTRECIBOS; SM35; FK03


Forms

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


Attachments

BBVA - Net Cash

BANK AND OTHER ACCESSES ES-PT-UK



Previous OP << >> Next OP



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 booking of the direct debits receipts from BBVA.

1.2. Scope

This procedure is applicable for the following companies:

  • 0245 - SOLVAY QUIMICA (ES)

For the two bank accounts in BBVA:

  • SOLVAY QUIMICA, S.L. - ES1501824649840010018672
  • SOLVAY IBERICA, S.L. PROP - ES7001824649890010018504


2. Definitions

See Finance Glossary:


3. Tasks description

3.1. Periodicity

This procedure must be done every 10 days on the 1st, 11th and 21st of each month.

3.2. I extract bank statements from BBVA Netcash

To have access to the bank statements enter in the web site of BBVA - Net Cash.

To login use the credentials as mentioned in the file "BANK AND OTHER ACCESSES ES-PT-UK".

Once inside the BBVA bank choose:

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

Once the page is displayed choose:

  • "Estado" – Histórico
  • "Rango de fechas" – Every 10 days: if we are at beginning of the month (01) from 21 to 31 of M-1; at 11th – from 01 to 10 of M+1; at the 21th – from 11 to 20 of M+1
  • "Tipo de ficheros" – TODOS (always)


Afterwards it will ask you to choose the files we want to extract. 


You must select always "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 in your computer:



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


3.3. I perform the processes for Torrelavega

Once you have the file with the bank movements go to SAP and enter in transaction ZE1FGESTRECIBOS.

  • Once inside we must choose TORRELAVEGA process and:

Select File upload Receipts Bank from Torrelavega and execute the transaction :


It will display another screen where you will just have to select the path to the file downloaded from the bank and execute:


Once done you will receive the details of the movements that will be posted:


There is a brief check that can be done to ensure that there is missing information to post. If you look to the column highlighted in red you can see that for some lines there is no reference to an account. If this happens go to “What to do in case of missing allocation?”. 


  • Select Post Receipts from Table ZEFRE Torrelavega 


In the screen displayed change the field "Posting Date" to previous day - same as the last day of the extraction in NETCASH.


And confirm:
"Document Type" – G0 and "Bank Account" – 50601EUR30 


Execute the transaction clicking on , and the list of documents to be posted will be displayed. 

The transaction generates batch inputs that have to be processed in SM35. Normally the batch codification is similar to ZES-REC-ACRE and / or ZES-REC-GRAL.

Go to SM35 and process the batch.

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

3.3.1. I perform the changes in case of missing allocation

If the direct debit movement doesn’t have account to be posted, please follow the following steps:


1) There are some lines that we know should not be posted via this transaction. So, whenever you see reference to “IA.******” this has to be ignored. To maintain the table with only the relevant movements you can go to:


In this table you have the list of movements uploaded from the bank, if you need to ignore the movements search for them and just add an “X” in the last column. The program will consider it already posted and skip it for posting. 


2) Check if it is something new - you can search for a familiar concept or vendor name in BBVA site;


3) Search in SAP transaction FK03 for the vendor number (you can search by name or ID acreedor), if it is not clear or available or if vendor is not created please report it to CAM;

In the previous example shown, we see in table ZEFRE that the program reads the last 5 digits of the Id acreedor (+4 blank) digits: "5400B".

So you just need to add an entry in table ZEFTE:


Taking in consideration the following:


As soon as it’s completed save the changes in the table and future movements will automatically filled and posted.

For the movement already uploaded and available in the table, you can manually add the account before processing the batch input. 


End of document.