Update for Brazilian Sped ECF Layout 0004 in Microsoft Dynamics AX 2012 R3

Applies to: DynamicsDynamics AX 2012 R3

Introduction


This is a country specific update from Brazil to support SPED ECF layout 4 for transactions and statements generated from 2017.

This new layout has introduced new changes in the following records:

  • Record 0000: Layout version is updated to 0004
  • Record 0020: Indicator of foreign operations
  • Block V: This new block V-DEREX is implemented to details all operation in foreign currency with banks or other institutions outside of Brazil

Overview


The following changes in configuration have been introduced in SPED ECF statement as part of new layout 4.0.

Tax statement parameters

To setup the new layout navigate to Fiscal books > Setup > Tax statements parameters and select SPED ECF and in version layout select 0004. The record 0000 will include the new layout version when the statement being generated from MR application.

DEREX block V

This new layout has introduced the generation of block V (named DEREX) where all operations with banks and other foreign entities must be detailed. Additional configuration was introduced in SPED ECF parameters form to identify these type of transactions that will be reported in block V

Derex parameters - Journal names. Identify the journal names used to register and post bank transactions for foreign accounts.

Sped ECF - Derex parameters Journal names

Derex parameters - Foreign bank account. Identify the foreign bank accounts to be reported in block V.

Sped ECF  Derex parameters bank account

Derex classification. Add and remove DEREX classification codes (Table V100) t indentify the type of bank transaction reported in the block V. 

Sped ECF Derex parameters classification

Journal entry

The DEREX classification code is available for selection in journal transactions entry form. 

SPED ECF Journal form

 

Block V


V001: Opening record

Field number

Field name

Description

1

REG

Fixed (V001).

2

IND_DAD

Content Indicator:

1 – No data. 0 – There are data.

V010: Foreing bank account identification 

Field number

Field name

Description

1

REG

Fixed (V010).

2

NOME_INSTITUICAO

Institution Name  (AX Bank Account name)

3

PAIS

Country code (ISO country code)

4

TIP_MOEDA

Currency code (ISO currency code)

 V020: Bank account details

Field number

Field name

Description

1

REG

Fixed (V020).

2

NOME

Responsible name

3

ENDERECO

Address

Example: |V020|FULANO| RUA ALFA 121 – PERDIZES – SÃO PAULO/SP – CEP: 20.000-000|XX|12345678900|12345-6|

Street name & street number & - & District & - & City & - & State & - & CEP: & Zip code

4

TIPO_DO_C

Responsible document type 

5

NI

Responsible document Id

6

IDENT_CONTA

Account num

V030: Period 

Field number

Field name

Description

1

REG

Fixed (V030)

All journal transactions that meet the DEREX parameter criteria are grouped by the month of year reported.

2

MES

Month number of posting date from journal transaction

 V100: Transantion detail grouped by DEREX code 

Field number

Field name

Description

1

REG

Fixed (V100)

All journal transactions that meet the DEREX parameter criteria

2

CODIGO

Transaction classification id

(DEREX classification code from Journal transactions)

3

DESCRICAO

Transaction classification name

(Journal description)

4

VALOR

Transaction amount

V990: CLosing block

Field number

Field name

Description

1

REG

Fixed (V990)

2

QTD_LIN_M

Quantity of registers in V block

 

Hotfix information


How to obtain the Microsoft Dynamics AX updates files

This update is available for manual download and installation from the Microsoft Download Center.

Prerequisites

You must have one of the following products installed to apply this hotfix:

  • Microsoft Dynamics AX 2012 R3

Restart requirement

You must restart the Application Object Server (AOS) service after you apply the hotfix.

If you are encountering an issue downloading, installing this hotfix, or have other technical support questions, contact your partner or, if enrolled in a support plan directly with Microsoft, you can contact technical support for Microsoft Dynamics and create a new support request. To do this, visit the following Microsoft website:

https://mbs.microsoft.com/support/newstart.aspx

You can also contact technical support for Microsoft Dynamics by phone using these links for country specific phone numbers. To do this, visit one of the following Microsoft websites:

Partners

https://mbs.microsoft.com/partnersource/resources/support/supportinformation/Global+Support+Contacts

Customers

https://mbs.microsoft.com/customersource/northamerica/help/help/contactus

In special cases, charges that are ordinarily incurred for support calls may be canceled if a Technical Support Professional for Microsoft Dynamics and related products determines that a specific update will resolve your problem. The usual support costs will apply to any additional support questions and issues that do not qualify for the specific update in question.

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained here in is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.