Enter in system in IT language, so that the reports may be retrieved in Italian language.

1. Objective and Scope

1.1. Objective of this Operation

The purpose of this document is to explain how to retrieve the Journal Entries Book from SAP the Journal entries book, known by in Italy as the Libro Giornale. This is one of the accounting books required by Italian law that contains the records of all the is one of the accounting books required by Italian law and contains the record of all accounting movements of a companya company. 

The objective is to prepare and check consistency of extract the data to print for each company, verify its consistency, and prepare it for printing. The information output is sent via PDF to be uploaded by CAM in an electronic archivegenerated in PDF format and then provided for upload to the electronic archive. This upload is performed by an external consultant and is only possible if the required rules are followed and the procedure is executed exactly as described.

Important: the procedure must never be executed twice in real mode. Once run in real mode, it cannot be run again without support from DT.

1.2. Scope

This procedure applies to the following Italian companies:

2. Definitions

See Finance Glossary:

• CAM

3. Tasks description

3.1. Periodicity

The procedure is performed on a monthly basis but can only be started when we have the confirmation that the closing of the previous year is finalized.  Afterwards it can be performed on a monthly basis.

This means that for months of December we will perform it first in test mode, in real mode can only be done after the procedure "Final postings for year end closure", also known as, Diversi a Diversi is done. Afterwards it can be performed on a monthly basis.December has to be performed in test mode and information sent sent to CAM to ensure we prepare the 

3.2. I retrieve from SAP the Libro Giornale (PF1)

3.2.1. I check if the tables are updated

 Before starting the extractions for the current year you have to update the tables for program ZIBELJ10:

1) For that enter in SM30;

2) In field Table/View select T900 and click in display:     Image Removed

     Image Added

3) As soon as you have access to the details you can select Position and in field PROG add ZIBELJ10 to visualize the information you need to add.

Image RemovedImage Added

4) Click in Display> Change bottom (highlighted in yellow):

Image RemovedImage Added

 Then choose New Entries:

 Image RemovedImage Added

and add:

Image Added

Image Removed Example: ZIBELJ10             0279                20XX  000000

Save it. 

 ADD one entry for each company 

3.2.2. I run transaction Z1F_IT_ZIBELJ11 in test mode and ensure consistency of data

Run transaction Z1F_IT_ZIBELJ11 with the following variants:

Confirm that the fields indicated are updated with:

• • Fiscal Year: current year
  • Posting date: previous period
  • Year of Print: current year
  • NEW DOCUMENT JOURNAL is selected
  • Test is selected

Image Added Image Removed

Execute the transaction in test mode and ensure the following checks:

• • On the third page of the monthly report we need to check if the carry-over balance is correct (should be the same as previous period with the exception of January):

 If in January:

Image RemovedImage Added

In February the report need to be be:

Image RemovedImage Added

• • Last numbering page of the month and the first page of the following month should be sequential (with the exception of January):

If in January ends with 510 pages:

Image RemovedImage Added

In February the report needs to bestart with 511 page:

Image RemovedImage Added

• • The numbering of the report must be sequential:

Image RemovedImage Added

• • Penultimate page of the report should evidence the balance of the report:

Image RemovedImage Added

3.2.3. I run transaction Z1F_IT_ZIBELJ11 in real mode 

If all checks are consistent, go back in transaction Z1F_IT_ZIBELJ11:

 - Unselect the test mode;

 - Run the transaction in background.

3.2.4. I download and archive the data extracted

Go to SM37 and make a quick check on the spool to ensure the numbering is correct and download the data in .pdf format. 

Depending of the company we can have more than 500 pages to be printed. As the electronic archive accepts only 500 pages we have to create as many pdf as necessary (500 by 500 pages).

To facilitate the rule for the name of the files can be like exemplified CCCC_LIBGIO_XXXX_YY_ZZ where:

• • • CCCC – Company Code
    • XXXX – Year
    • YY – Month
    • ZZ – pdf file number (00,01,02,03….)

For the companies with only a file the name is XXX_LIBGIO_2021_01_00.PDF.

Archive the documents in Google Drive / IT LIBRO GIORNALE and inform CAM that the process is completed sharing the documents extracted.

3.3. I retrieve from SAP the Libro Giornale (WP1)

Enter in system in IT language, so that the reports may be retrieved in Italian language.

3.3.1. I run transaction S_ALR_87012287 in test mode and ensure consistency of data

Run transaction S_ALR_87012287 with the following variant:

Confirm that the fields indicated are updated with:

• • • Company Code: 8090
    • Fiscal Year: Current year
    • Posting date: previous period
    • Test Run: Selected

Image RemovedImage Added

Execute the transaction in test mode and ensure the checks as explained in step 3.2.2.

3.3.2. I run transaction S_ALR_87012287 in real mode

If all checks are consistent, go back in transaction S_ALR_87012287: 

 - Unselect the test mode;

 - Run the transaction in foreground.

3.3.3. I download and archive the data extracted

Depending of the company we can have more than 500 pages to be printed.

As the electronic archive accepts only 500 pages we have to create as many pdf as necessary (500 by 500 pages), go to printer icon and print 500 by 500 pages.

Image RemovedImage Added

To facilitate the rule for the name of the files can be like exemplified CCCC_LIBGIO_XXXX_YY_ZZ where:

• • • CCCC – Company Code
    • XXXX – Year
    • YY – Month
    • ZZ – pdf file number (00,01,02,03….)

For the companies with only a file the name is XXX_LIBGIO_2021_01_00.PDF

Archive the documents in Google Drive / IT LIBRO GIORNALE and inform CAM that the process is completed sharing the documents extracted.

3.4. I retrieve from SAP the Libro Giornale (PE1)

          Enter in system in IT language, so that the reports may be retrieved in Italian language.

3.4.1. I run transaction S_ALR_87012287 in test mode and ensure consistency of data

Run transaction S_ALR_87012287 with the following variant:

Confirm that the fields indicated are updated with:

Image Removed

Execute the transaction in test mode and ensure the checks as explained in step 3.2.2.

3.4.2. I run transaction S_ALR_87012287 in real mode

If all checks are consistent, go back in transaction S_ALR_87012287: 

 - Unselect the test mode;

 - Run the transaction in foreground.

3.4.3. I download the data extracted

Depending of the company we can have more than 500 pages to be printed.

As the electronic archive accepts only 500 pages we have to create as many pdf as necessary (500 by 500 pages), go to printer icon and print 500 by 500 pages with the following parameters:

Image Removed

To facilitate the rule for the name of the files can be like exemplified CCCC_LIBGIO_XXXX_YY_ZZ where:

• • • CCCC – Company Code
    • XXXX – Year
    • YY – Month
    • ZZ – pdf file number (01,02,03….)

Archive the documents in Google Drive / IT LIBRO GIORNALE and inform CAM that the process is completed sharing the documents extracted.

4. Errors handling

If for some reason in the checks you detect inconsistencies in the page numbering sequence, totals carry forward or sequence number you have to contact IS DT via Syra to reset the report, indicate . data from the latest period that was considered valid and ran without issues.

Image Added

Indicate as much information as possible and the last report extracted sequences to support the request like *two different scenarios are expected start from January or any other month...

In case If you need to run the transaction a second time for the same period after running the first time in real mode you have to send a request to IS to reset not only the page numbering but also the sequence number of the report, for example: 

Image Removed

want to start from January

In the sequence of a wrong manipulation of data during the execution of transaction Z1F_IT_ZIBELJ11, please update program name: ZIBELJ11. 

Sine we will start extractions from January please update the program as follows 

Company Code: 6428
Fiscal Year: 2025
Page:1
Debit Amount: 0
Credit Amount: 0
Posting Date: 01.01.2025
Entered on: 01.01.2025
Seq. Number: 1

If you want to updated starting any other month, please retrieve the data from the last month corretly extracted. 

 for example: 

Image Added

End of document.