Finance | Project Operations, Human Resources, ...

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

(0) Share

Report

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...

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Microsoft on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
PK mishra 115 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Microsoft on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No