Description
This report creates the Legal Book 'Registro de Apuração do ICMS(Modelo 9). It reads the data of thenotas fiscais andconhecimentos that havebeen posted during the selected period and accumulates, sorts anddisplays them according to Brazilian laws. In addition, it collectsspecial postings that were created manually but without creating a NotaFiscal or a Conhecimento from different accounts. These accounts haveto be created and maintained by the user before starting this report.
The Output consists - depending on the selections made on the selectionscreen - in up to three 'books':
the Registro de Apuração do ICMS, containing onlyICMS information
the Registro de Apuração do ICMS -Substituição tributáriaintrastate, containing Substituição tributária information concerningtransactions within the state of the reporting company
the Registro de Apuração do ICMS - Substituição tributária interstate,containing Substituição tributária information concerning transactionswith companies situated in states different from the state of thereporting company
RESET N1

Precondition
Maintainance of the table J_1BLB09:
To read the relevant data for the last three parts of each of the threebooks that can be generated by this report, the user has to create andmaintain the following G/L accounts (with line item display set to'ACTIVE') per company code and business place and maintain the fieldsin table J_1BLB09 as described below:
Outros Débitos:
assignable to row 007/107/207 with D/C indicator 1 (only credits, whichmeans here: only reversals of debits) and assignable to row 002/102/202with D/C indicator 2 (only debits).
Outros Créditos:
assignable to row 006/106/206 with D/C indicator 1 (only credits) andassignable to row 003/103/203 with D/C indicator 2 (only debits, whichmeans here: only reversals of credits).
Saldo Credor no Periodo Anterior:
assignable only to row 009/109/209 with D/C indicator 1 (only credits).
Deduções:
assignable only to row 012/112/212 with D/C indicator 1 (only credits).
The first number of each row indicator (ZXY) determines, in which ofthe three possible books (ICMS: 0XY, Substituição tributáriaintrastate: 1XY, Substituição tributária interstate: 2XY) therespective postings will appear.
If there are several accounts of the same type (belonging to the samerow indicator), then they have to be numbered - for this purpose usethe field Sequence number in the table.
Mandatory selection criteria:
Nota Fiscal selection criteria:
Company code ... of the company that issues the Registro
Business place ... of the company's business place that issues theRegistro
Posting date ... first and last date of the period for whichposted documents shall be reported in the Registro
Output selection:
Selection of postings:
Here, you select, if the report will show only information on incomingand/or outgoing Notas Fiscais, or if also the 'Apuração' part will begenerated
ICMS / Substituição tributária:
Here, you select, which of the three possible books (see descriptionabove) will be generated.
Optional selection criteria:
Additional selection criteria:
Series ... the Nota Fiscal / Conhecimento Series number
Nota Fiscal number ... the external, non-unique number of the NotaFiscal or Conhecimento

Output
The output consists of up to three books; each of them may contain upto five parts, depending on the output selection:

• Entradas:

ICMS-relevant incoming goods, condensed and sorted byCFOP number (withoutextension), or by state of the partner in the case of the Substituiçãotributária interstate book.

• Saídas:

ICMS-relevant outgoing goods, condensed and sorted by CFOP number(without extension), or by state of the partner in the case of theSubstituição tributária interstate book.

• Débito do Imposto:

ICMS tax debits - the relevant amounts resulting from the 'Saídas'-partand other debits/reversals of other credits that were not created via aNota Fiscal or Conhecimento but posted directly via FI. The amountsappearing here are read directly from special FI accounts which have tobe maintained by the user and which are linked to this report via thetable J_1BLB09 (See above).

• Crédito do Imposto:

ICMS tax credits - the relevant amounts resulting from the 'Entradas'-part and other credits/reversals of other debits/credits from formerperiods that were not created via a Nota Fiscal or Conhecimento butposted directly via FI. The amounts appearing here are read directlyfrom special FI accounts which have to be maintained by the user andwhich are linked to this report via the table J_1BLB09 (See above).

• Apuração do Saldo:

Final determination of the tax debit to be paid or the tax credit to betransported to the next period.

Example
For the maintainance of the table J_1BLB09, the following entries:
Company code,,Business place,,Row,,Seq.no.,,G/L account,,D/C ind.
0001,,0001,,002,,1,,xyz,,2
will be interpreted as follows:
The report 'Registro de Apuração do ICMS' will read the debit postings(D/C ind = 2) in account number xyz for the given company/businessplace and report them in the third part of the 'Registro de Apuração'within the first of the three possible books (ICMS book) under 'OutrosDébitos' (Row: 2).