Recapitulative statement

• Group (field GRP)

Enter a company group to extract values for the group.

• Company (field CPY)

Enter a company.

• Legislation (field LEG)

This field displays the legislation for the selected company.

• Site (field FCYLIN)

Enter a site for the selected company to limit the extraction to that site. This field is not available if you enter a company group.

• Tax identifier (field CRN)

This field displays the tax identifier for the company or company group.

• EU VAT no. (field GEREECNUM)

Displays the EU VAT No.:

• In the header information, this fields relates to the legal master data of the company or group of companies, depending on the entered selection.
• In the table, this field relates to the EU VAT No. of the BP.

• ELMA5 ID (field GERCODELMA)

Displays the ELMA5 ID  according to the legal master data of the company or group of companies. The ELMA5 ID is provided by the German fiscal authorities and is only needed for Recapitulative Statements with more than 1000 detail lines.

• Start date (field DATDEB)

Enter a date rate to select records within those dates. The date range can only be a calendar month, a calendar quarter, or a calendar year. Generating the statement for a calendar year is only for internal reconciliation purposes, and it is not an official declaration time range.

• End date (field DATFIN)

Enter an end date for records to be include or the end date for the validity of an configuration entry.

• Currency (field CUR)

This field displays the currency from main legal ledger.

• Exclude invalid entries (field FLGVALIDON)

If activated, invalid records will be suppressed on data processing (and consequently not exported later). Only available when parameter GERRSEXTMP - Temporary journal export (chap. LOC, group GER) is active.

• field FLG

This traffic light-like indicator displays the status of an entry:

• Green: all necessary information available
• Yellow: Warning, because the result contains temporary postings. No export possible
• Red: Error, because the result contains missing information or documents with wrong status like simulated, template etc. No export possible.

A detailed information about the status of each entry is displayed in the "Result" tab in the column "Comment".

• EU VAT no. (field GEREECNUM)

Displays the EU VAT No.:

• In the header information, this fields relates to the legal master data of the company or group of companies, depending on the entered selection.
• In the table, this field relates to the EU VAT No. of the BP.

• Turnover (field AMTTRN)

Amount considered in the Recapitulative Statement.

• Tax (field TAX)

Displays the tax code of the entry.

• Turnover type (field TRNTYP)

Displays the type of the turnover. It is determined by the matching between turnover types and tax rules defined in the Recapitulative Statement Parameter screen.

• Country (field CRY)

Displays the BP's country.

• Amount (field AMTTOT)

Total amount of turnover for the displayed entries.

• field CUR

• Number of lines (field POSTOT)

Number of lines in result.

• Status (field STA)

Status information for the result.

• field FLG

This traffic light-like indicator displays the status of an entry:

• Green: all necessary information available
• Yellow: Warning, because the result contains temporary postings. No export possible
• Red: Error, because the result contains missing information or documents with wrong status like simulated, template etc. No export possible.

A detailed information about the status of each entry is displayed in the "Result" tab in the column "Comment".

• EU VAT no. (field GEREECNUM)

Displays the EU VAT No.:

• In the header information, this fields relates to the legal master data of the company or group of companies, depending on the entered selection.
• In the table, this field relates to the EU VAT No. of the BP.

• Customer (field OFFACC)

This field is used to specify the contra account.
 The counterpart of each entry line is updated upon creation. If left blank, it will be initialized upon journal posting.

• Turnover (field AMTTRN)

Amount considered in the Recapitulative Statement.

• VAT code (field TAX)

Displays the tax code of the entry.

• BP tax rule (field VACBPR)

This column relates to the accompanying BP tax rule. The BP tax rule must have the setting EU (intra-community) tax.

• Document type (field TYP)

This information is compulsory.

The invoice type suggested by default is linked to the SIVTYP - User invoice type parameter. You can modify it if necessary by choosing an invoice type from the list of invoice types that have been defined.
The customer invoice type:

• is used for the Sales and BP Customer invoices;
• identifies a category of invoice (invoice, credit memo etc.) along with a posting structure for the posting of the invoices;
• is associated with a type of journal for which a counter (manual or automatic) is specified.
  Notes:

• If no counter is specified in the journal type and no journal number is manually specified on invoice entry the program will attribute a journal number according to the counter set up in the Counter assignment table.
• When no journal type is associated to the invoice type the journal type specified on the automatic journal is used (as well as the associated counter).

On invoice entry, only an invoice type with a legislation and company group consistent with those of the company linked to the sales site can be entered.
For further information, click here.

• Document no. (field NUM)

Displays the document number of the underlying invoice.

• Description (field DESVCR)

Description text of the document.

• Turnover type (field TRNTYP)

Displays the type of the turnover. It is determined by the matching between turnover types and tax rules defined in the Recapitulative Statement Parameter screen.

• County (field CRY)

Displays the BP's country.

• Comment (field COMMENT)

Displays a descriptive comment for the entry. In case of red (errors) or yellow (warnings) status, the reason is displayed in more detail.