Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

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

Posted on by 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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,914 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,549 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans