Import bank Statement from Excel

(0) Share

Report

Posted on by himanshu kumar

950

i want to import bank statement from excel through code but i m unable to find the fields which will be hit when we insert data......can u tell me about those table and fields or give me excel template through which i can easily import.......thanx in advance

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Bilal Issa 4,370 on at

Like (0)

Report

Hi ,

there is a standard functionality that you can use , please check the link below.

technet.microsoft.com/.../jj729765.aspx

Regards,

Bilal

Was this reply helpful? Yes No
himanshu kumar 950 on at

Like (0)

Report

it is for XML but if we want to import from excel we have to write code.....i want to know that code and the template of excel(Including all fields) used for inserting record

Was this reply helpful? Yes No
Bilal Issa 4,370 on at

Like (0)

Report

have you considered saving excel as xml and use standard code, that will save you any conflict with upgrades in future ?

Was this reply helpful? Yes No
himanshu kumar 950 on at

Like (0)

Report

hii Bilal

i have written the code in class.....would u tell me where m doing mistake if i give the xpo of the project......

thanx in advance

Was this reply helpful? Yes No
Suggested answer

Bashir Ahmad 5,248 on at

Like (0)

Report

Try this ti import data:

www.systemsltd.com/.../5-ways-import-your-data-microsoft-dynamics-ax-2012

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi himanshu,

i'm facing same situation can you please tell me how you solve it by excel sheet,

Thanks,

Regards,

Osama

Was this reply helpful? Yes No