Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Import bank statement ...
Finance forum

Import bank statement using Electronic reporting

(0) ShareShare
ReportReport
Posted on by Maxim_msk

Hi,
i’m trying to import bank statement using configuration Bank statement RU.

One of the issues is what txt file from bank contains empty lines between documents:

1CClientBankExchange
ВерсияФормата=1.01
Кодировка=Windows Отправитель=Альфа-Бизнес Онлайн Получатель=
ДатаСоздания=30.07.2019
ВремяСоздания=20:32:03
ДатаНачала=30.07.2019
ДатаКонца=30.07.2019
РасчСчет=111

СекцияРасчСчет
ДатаНачала=30.07.2019
ДатаКонца=30.07.2019
РасчСчет=111
НачальныйОстаток=9.98
ВсегоПоступило=0.00
ВсегоСписано=1.68
КонечныйОстаток=7.30
КонецРасчСчет

СекцияДокумент=Платежное поручение
...
КонецДокумента

СекцияДокумент=Платежное поручение
...
КонецДокумента

КонецФайла

If i try import file with any empty line after РасчСчет tag i get error and nothing import.
If i try RUN in mapping then i get XML but it’ to small and doesn’t see documents

Цитата:
<?xml version="1.0" encoding="UTF-8"?>
-<Root>
<Item Type="DataContainerList" Name="BankStatementTotals"/>
-<Item Type="DataContainer" Name="CompanyInfo">
<Item Type="Date" Name="DocumentDate">01/01/1900 00:00:00</Item>
</Item>
<Item Type="DateTime" Name="CreationDateTime">1900-01-01T01:00:00+01:00</Item>
<Item Type="String" Name="MessageIdentification">02;30.07.2019;30.07.2019;111</Item>
<Item Type="DataContainerList" Name="Payments"/>
</Root>

Could you help how to set up GER to import such files?

Categories:
  • Maxim_msk Profile Picture
    Maxim_msk on at
    RE: Import bank statement using Electronic reporting

    Ludwig, I tried to change ER format in derived configuration adding empty line in many ways but nothing yet helped to beat this empty lines error.

    For other issues I successfully made changes with help of colleagues in model mapping. So in theory if someone can describe what to do I may do this.

    Maybe you know ER configuration which import any other file with empty lines?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Import bank statement using Electronic reporting

    Hi Maxim,

    There seems to be something missing in the ER model.

    If you do not have much time and do not want to try and test changing the model, expressions and mappings yourself then the best option is opening a support ticket with MS.

    There must be other companies operating in the same country/region that run into the same issue and MS should fix it for you an all other D365FO users.

    So, please open a support case with them.

    That should be the fastest and easiest way to get this fixed.

    Best regards,

    Ludwig

  • Maxim_msk Profile Picture
    Maxim_msk on at
    RE: Import bank statement using Electronic reporting

    Hi Ludwig,

    Error:

    Evaluating expression for path 'model/$Totals'.

    Evaluating expression for path 'MessageIdentification'. Evaluating expression for path 'format/IncomingFile/File/$PeriodStart'. Not all data was read from file.

    Path to import Cash and bank / Periodic / Third party bank / Import from client bank.

    I use standard MS configuration Payment model / Bank statement RU

    Yes, this is format to import bank statement in so-called 1C format, specific for Russian banks.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Import bank statement using Electronic reporting

    Hello maxim,

    What does the error message say?

    Is the model and configuration something that you created yourself or provided by MS from LCS?

    That must be a Russian specific format, right?

    Regards,

    Ludwig

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans