Update for Brazilian Sped ECF Layout 0004 in Microsoft Dynamics 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.

Microsoft Dynamics AX 2012 R3

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.