Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / handle a new Column in...
Finance | Project Operations, Human Resources, ...
Suggested answer

handle a new Column into the Bank Statement Lines table [BankStmtISOReportEntry]

(0) ShareShare
ReportReport
Posted on by PK mishra 115

6518.ab.png

I have added new field ,Description in BankStmtISOReportEntry table . Bank Statement format is MT940 . 

{1:F01axisINBBADEL0000000000}{2:I940CRESCHZFXARSN}{4:
:20:2503465687
:25:00155000004589
:28C:00001/001
:60M:C201026INR948256879,59
:61:201023C53539,66S940ACCTSERVREF
:86:70000273TERMINAL 1 CARDS SETTL. 2/10/19
:61:201023D81,67S940ACCTSERVREF
:86:70000273TERMINAL 1CREDIT VOUCHER2/10/19
:61:201023C30054,00S940ACCTSERVREF
:86:DELHIVERY PRIV-Abcdefghizklfor test
:61:201023C847,60S940ACCTSERVREF
:86:PayZapp - Abcdefghizklfor test 23/10/2020
:62M:C201026INR94913836,18
-}

Now i want to Upload above Bank statement Line in Ax . & each 86 tag Line have to upload in  ,Description  Field Which i newly created Field in Bank Statement Line .

So my question is How to add New Tag/Column in MT940TXT-to-MT940XML & MT940XML-to-Reconciliation in these xml files & how to Push Data of New Tag/column to table [BankStmtISOReportEntry] new field i.e. Description.  Thanks .. Please Help...

  • Suggested answer
    Microsoft Profile Picture
    Microsoft on at
    RE: handle a new Column into the Bank Statement Lines table [BankStmtISOReportEntry]

    Yes, I just checked there is no entity available for this table: BankStmtISOReportEntry.

    but you can try to create entity and just included your needed field in the entity.

    1. In Visual studio, In the application suite project, right click to add a new item: data entity.

    2. then follow the wizard to select the table and the needed field for the entity.

    3. Build the entity.

    4. in workspace, try to upload the file by the newly created data entity and have a test.

  • PK mishra Profile Picture
    PK mishra 115 on at
    RE: handle a new Column into the Bank Statement Lines table [BankStmtISOReportEntry]

    Jasmine Thanks For Response,

    I have add a new field 6 days ago only .

    I try but i didnt find exact entity In AX R3 , If You Know ,Please Tell me , Thanks in advance.

  • Suggested answer
    Microsoft Profile Picture
    Microsoft on at
    RE: handle a new Column into the Bank Statement Lines table [BankStmtISOReportEntry]

    When you add a new field in the table.  and want to bulk upload info to AX,

    you can try to find and update existing related entity to include this new field. then have a try.

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

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans