Annual customer list reprint

Prerequisites

List of criteria

Parameter	Parameter title	Type
numrpt	Query number	L
impselections	Print selections (Local menu No, Yes)	M1

Report description

 Each part of the report contains the following information:

Header

• The query number
• The company code
• The threshold (the threshold applied at the time of the extraction is not stored. In case of reprinting, the threshold displayed in the report corresponds to the threshold set at the time of printing and not to the threshold used during the initial calculation)
• The main general ledger currency
• The declaration dates

'Entry detail' part

• The information is sorted by EU VAT number and customer. For each EU VAT number/customer combination, the extracted invoice lines are displayed.
• The invoices are then sorted by ascending invoice number and VAT rate.
  In case of multiple VAT rate invoices, the invoice lines are displayed grouped by VAT rate.
• The amounts are processed and totaled according to two different methods:
  
• If the VAT management has the 'Submitted' type, the amount is displayed in the Turnover ex tax column.
• If the VAT management has the 'VAT account' type, the amount is displayed in the Tax column.
  
• If the threshold has not been reached, but there is at least one credit memo, the sub-total is displayed in italics.

The VAT management is dependent on the box selected in the Tax management block in the Accounts function (GESGAC).

'Summary' part

• The various tax excluded and VAT turnover amounts, sorted by EU VAT number and customer code and name.
• The turnover figures below the declaration threshold are not considered. Therefore they are not displayed in this part.

The turnover declaration threshold is defined by the BELCUSTSD - Annual customer listing threshold parameter (chapter LOC, group BEL).