Programme SAP REBRDAICMS - Registro de Apuração do ICMS - DAICMS

Description
This Report creates the Legal Book 'Registro de Apuração do ICMS(DAICMS). It reads the data of the Notas Fiscais, Conhecimentos andFICA documents that have been posted during the selected period andaccumulates, sorts and displays them accordingly to brazilian utilitycompany requirements. In addition to that, it collects special postingsthat were created manually but without creating a Nota Fiscal or aConhecimento or a FICA document from different accounts. These accountshave to be created and maintained by the user before starting thisReport.
The Output consists of the Registro de Apuração do ICMS, containingonly ICMS information (DAICMS).

Precondition
Maintainance of the table EBRLIVICMS using transaction EBR_LIVICMS :
To read the relevant data for the last part the book that can begenerated by this report, the user has to create and maintain thefollowing G/L accounts (with line item display set to 'ACTIVE') percompany code and branch and maintain the fields in table EBRLIVICMS asdescribed below:
Outros Débitos:
assignable to row 007 with D/C indicator 1 (only credits, which meanshere: only reversals of debits) and assignable to row 002 with D/Cindicator 2 (only debits).
Outros Créditos:
assignable to row 006 with D/C indicator 1 (only credits) andassignable to row 003 with D/C indicator 2 (only debits, which meanshere: only reversals of credits).
Saldo Credor no Periodo Anterior:
assignable only to row 009 with D/C indicator 1 (only credits).
Deduções:
assignable only to row 012 with D/C indicator 1 (only credits).
The first number of each row indicator (ZXY) determines, the book(DAICMS: 0XY) the respective 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
Branch Code ... of the company's branch that issues the Registro
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.
Optional selection criteria:
Additional selection criteria:
Series ... the Nota Fiscal / Conhecimento Series number
Nota Fiscal number ... the external, not unique number of the NotaFiscal or Conhecimento
FICA Document Number

Output
The Output consists of three parts of the book, depending on theoutput selection:

  • Entradas:

  • ICMS relevant incoming 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.
    • 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 EBRLIVICMS (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 EBRLIVICMS (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.

            Recommendation
            In order to allow this report to access data efficiently, the following
            database index for table DFKKREP06 should be created:

            • Company Code, Contract Account Document Number, Net Due Date:

            • Fields: BUKRS, OPBEL, FAEDN

              Example
              ... for the maintainance of the table EBRLIVICMS:
              the entries
              company code: 0001, branch: 0001, row: 002, seq no.: 1, G/L account:xyz, D/C ind: 2
              will be interpreted in the following way:
              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/branch andreport them in the third part of the 'Registro de Apuração' under'Outros Débitos' (Row: 2).