Finance | Project Operations, Human Resources, ...

Convert csv file into Bank Format BAI2

(0) Share

Report

Posted on by simonsmith101

Hi Folks,

We have a requirement to activate advance bank rec functionality for a bank account that does not offer statements in one of the accepted formats (Australia its BAI2). Client has asked how easy it would be to convert a csv file from bank into the BAI2 Format. Does anyone have any suggestions for this or alternative suggestions?

Thanks

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi Simon,

You don't necessarily need a BAI2 statement to import bank statements into D365FO.

With electronic reporting you can also use CSV files and import them.

Of course this requires a new setup of an electronic reporting configuration but is doable.

A friend of mine demonstrated this some time ago at an online webinar of the AXUG.

Probably have a look at the recording and/or talk to one of your developers about this electronic reporting alternative.

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

simonsmith101 2 on at

Like (0)

Report
Copy link

Link copied!

Thanks Ludwig.

Could you send me a link to the recording possibly

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hello Simon,

Here is the link:

www.axug.com/.../advanced-bank-reconciliation-and-se

You need to be registered /logged into the axug website to access the files.

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

simonsmith101 2 on at

Like (0)

Report
Copy link

Link copied!

Thanks Ludwig. I will take a look. Much appreciated

Was this reply helpful? Yes No
simonsmith101 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig

Its saying I am not authorised. I then applied for full membership and the address email bounced .

Simon

Was this reply helpful? Yes No
Benjamin Michael 5 on at

Like (0)

Report
Copy link

Link copied!

Hi Simon,

I hope you're doing well.

I'm checking in to see if you've been able to get a solution to this requirement.

Was this reply helpful? Yes No
simonsmith101 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Benjamin. We managed to create an ER report to convert it. Cheers
[quote user="simonsmith101"]
Hi Folks,

We have a requirement to activate advance bank rec functionality for a bank account that does not offer statements in one of the accepted formats (Australia its BAI2). Client has asked how easy it would be to convert a csv file from bank into the BAI2 Format. Does anyone have any suggestions for this or alternative suggestions?

Thanks
[/quote]

Was this reply helpful? Yes No