Import bank statement BAI file format

(0) Share

Report

Posted on by Yuji

4,131

Hi,

I was working on the Australian bank imort feature. However I can't find any Australian bank provided any BAI file format files. Do you know if there is anyway to support the Australian banks (Westpac, NAB etc.).

Thanks,

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Mea_ 60,284 on at

Like (0)

Report

Hi Yuji,
Please check https://docs.microsoft.com/en-us/dynamics365/unified-operations/financials/cash-bank-management/set-up-advanced-bank-reconciliation-import-process "Set up the import of BAI2 bank statements" section.

Was this reply helpful? Yes No
PK Axapta 140 on at

Like (0)

Report

Hi,

In which transformation file we have to make a change to import BSB and bank account number successfully (for AUS banks). I mean file contains BSB and account number in single field....how can we break them and import them successfully in their respective fields (first 6 digits into BSB and next 9 digits into account number field) during importing the statement from bank statement form.

BAI2CSV-to-BAI2XML

BAI2XML-to-Reconciliation

BankStmtImport_BankReconiliation_to_Composite

Many thanks in advance.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Peter, have you find the solution to your issue?

We are facing the same one and I'm still struggling with LCS AUS packages and .xlst transformation files...

Thanks!

Was this reply helpful? Yes No
Suggested answer

Abhi.singh 10 on at

Like (0)

Report

We changed it here

This was the change, basically to ignore the first 6 char. Also had another version as CBA file was sending 4 char BSB (technically SB as last 4 are state and branch :-) )

Was this reply helpful? Yes No