CLADR --> FIAS Storage and import of FIAS into system for Russia in Microsoft Dynamics AX

Introduction

The official RF Tax authority site informed that since January 1, 2018, the KLADR format will not be supported any longer. FIAS format must be used instead of KLADR.

Web interface to receive information from FIAS itself is located by the following link:

http://fias.nalog.ru/NewsViewPage.aspx?id=10020

Files with data from FIAS in DBF, XML formats and files with data in CLADR format are located by the following link:

http://fias.nalog.ru/

This functionality provides the interrelation between the records from CLADR and FIAS in the address dictionary in the system. All records from CLADR should be updated by the first import.

Note  For Microsoft Dynamics AX 2012 R3 and R2:

/// <summary>

/// Creates new records in FIASOperationStatuses_RU table

/// </summary>

/// This job create new records in FIASOperationStatuses_RU table for hotfix (4052196).

/// Before starting the job ensure the following:

/// 1. The above-mentioned hotfix is installed.

static void createFIASOperationStatuses(Args _args)

{

FIASOperationStatuses_RU fIASOperationStatuses_RU;

;

fIASOperationStatuses_RU.OperationDescription = 'Удаление';

fIASOperationStatuses_RU.OperationStatus = '30';

fIASOperationStatuses_RU.FIASOperationType_RU = FIASOperationType_RU::DeleteOperation;

fIASOperationStatuses_RU.insert();

fIASOperationStatuses_RU.OperationDescription = 'Удаление вследствие удаления вышестоящего объекта';

fIASOperationStatuses_RU.OperationStatus = '31';

fIASOperationStatuses_RU.FIASOperationType_RU = FIASOperationType_RU::DeleteOperation;

fIASOperationStatuses_RU.insert();

fIASOperationStatuses_RU.OperationDescription = 'Переподчинение вследствие слияния вышестоящего объекта';

fIASOperationStatuses_RU.OperationStatus = '41';

fIASOperationStatuses_RU.FIASOperationType_RU = FIASOperationType_RU::ResubordinationOperation;

fIASOperationStatuses_RU.insert();

fIASOperationStatuses_RU.OperationDescription = 'Прекращение существования вследствие присоединения к другому адресному объекту';

fIASOperationStatuses_RU.OperationStatus = '42';

fIASOperationStatuses_RU.FIASOperationType_RU = FIASOperationType_RU::DeleteOperation;

fIASOperationStatuses_RU.insert();

fIASOperationStatuses_RU.OperationDescription = 'Переподчинение';

fIASOperationStatuses_RU.OperationStatus = '50';

fIASOperationStatuses_RU.FIASOperationType_RU = FIASOperationType_RU::ResubordinationOperation;

fIASOperationStatuses_RU.insert();

fIASOperationStatuses_RU.OperationDescription = 'Переподчинение вследствие переподчинения вышестоящего объекта';

fIASOperationStatuses_RU.OperationStatus = '51';

fIASOperationStatuses_RU.FIASOperationType_RU = FIASOperationType_RU::ResubordinationOperation;

fIASOperationStatuses_RU.insert();

fIASOperationStatuses_RU.OperationDescription = 'Прекращение существования вследствие переподчинения вышестоящего объекта';

fIASOperationStatuses_RU.OperationStatus = '52';

fIASOperationStatuses_RU.FIASOperationType_RU = FIASOperationType_RU::DeleteOperation;

fIASOperationStatuses_RU.insert();

fIASOperationStatuses_RU.OperationDescription = 'Прекращение существования вследствие дробления';

fIASOperationStatuses_RU.OperationStatus = '60';

fIASOperationStatuses_RU.FIASOperationType_RU = FIASOperationType_RU::DeleteOperation;

fIASOperationStatuses_RU.insert();

}

User guidance

1. Import the last existing version of CLADR.

2. Setup the Russian address format. (Organization administration\ Setup\ Addresses)

1. Setup operations to confirm the legality of the absence of records in the FIAS (removal, relocation, termination of existence) (Organization administration\ Setup \Addresses FIAS operation statuses). If the import functionality does not find an active appropriate record for CLADR in FIAS, but there is a record with the listed operation, that means the record in CLADR may be deleted as well.

1. Import from FIAS.

FIAS archive has to be uploaded from the following official site:

http://fias.nalog.ru/ExtendedSearchPage.aspx

It is recommended to store the archive at the same server where AOS is placed.

4.1 Abbreviations import (Organization administration\ Setup\ Addresses\ Abbreviations). Analyzing this log, user may select the lines needed to be imported in the system.

The name of Abbreviations file looks as AS_SOCRBASE_*.XML.

To reflect the differences between abbreviations in CLADR in FIAS, the uploaded file should be chosen on the Abbreviations import form. Push the Load abbreviations button.

The Check all diff / Uncheck all diff button marks or unmarks the not equal records.

The Import selected button changes the existing abbreviations in system.

4.2  Import FIAS addresses (Organization administration\ Setup\ Addresses\ Import from FIAS).

The goal of this functionality is to establish the correspondence between the records from CLADR and FIAS in the address dictionary in the system. All records from CLADR should be updated by the first import. The following updates may be executed in different regimes.

As a result of addresses import, the address formats will be updated according to the formats setups, and the addresses itself for not actual in CLADR addresses. (For example, when a parent object was changed for a dependent object.)

• If the Full import flag is ON, the additional states may be chosen for import.

If the states existing in the system need to be also fully updated, user has to list them as well. If the existing states are not presented in the list, these states will be only updated with the last changes from FIAS.

Note User should follow up himself the last data depended updates from FIAS. It is important to update all existing updates to ensure the completeness.

• If the Full import flag is OFF, only last changes will be updated for states existing in the system.

Note The partly updates must be executed systematically for all existing updates in FIAS. If any are missed, the full update is required.

• Import of houses and rooms may be executed optional.

1. Log of not found in FIAS. (Organization administration\ Setup\ Addresses\Log of not found in FIAS).

Records are considered identical if:

• For the first upload, the records in the AX DB and FIAS have the same set of fields (Region, District, City, City district or settlement, Street) (StateId, CountyId, City, District, Street).

• Reloading FIAS or date as dependent parts of FIAS, there is a code FIAS (AOGUID) in the system.

If any records from CLADR are not found in FIAS, the system reflects them in the log. Analyzing the log user can make the decision about deleting these records from system as well.

1. The Log of addresses import (Organization administration\ Setup\ Addresses\Log of addresses import) contains statistics of addresses import operations.

1. Create address.

The Building Complement, Building, Apartment fields are fulfilled automatically. Also manual editing of these fields is available.

Hotfix information