Bank Data Export or Import and Data Exchange Definition Setup in Business Central (D365BC)

Freelancer Madhavi

2️⃣Bank Export/Import, Data Exchange Definition Setup, and Import Bank Statement in D365BC. ▪️▪️▪️▪️▪️▪️▪️▪️▪️▪️▪️▪️▪️▪️▪️▪️ Check these Reports to Match Bank Reconciliation Statement (BRS) in Business Central: - Cash Book✅ Bank Book✅ ------------------------------------------------- #cashBook #bankBook #brs #bankreconciliationstatement #microsoftdynamics365businesscentral  ---------------------------------------------------------------------- The Bank Account Reconciliation video would be published in 3 Parts: - 1️⃣BRS - Guidelines on Errors Solution in D365BC. 2️⃣Bank Export/Import, Data Exchange Definition Setup, and Import Bank Statement in D365BC. 3️⃣Bank Account Reconciliation Posting and Result Analysis in D365BC. --------------------------------------------------------------- Bank Reconciliation Statements (BRS) are prepared to Reconcile Cash Book Balances with Bank Statements.  ▪️BRS helps in identifying errors, detecting fraud, tracking interest/fees, and confirming receipts. ------------------------------------------------------------------------------------------------------------- Note: Here, I am using Demo (Sample) Company, Cronus India Ltd. ---------------------------------------------------------------------------------------------------------------- Here in Business Central (D365 BC), Bank Reconciliation Statements (BRS) = Bank Account Reconciliation. In Standard Accounting System we are familiar with the terminology of BRS (Bank Reconciliation Statement). ------------------------------------ Agenda of the Video▶️: To Share Some Basic Steps of Importing Bank Account Statement into the ERP System, to ignore the Error while working on Bank Account Reconciliation Page/Screen to Match BRS (Bank Reconciliation Statement) in Business Central (D365BC). ------------------------------------------------------------------------------------------------------- ✅Hint 1: In the Next Upcoming Videos, we'll learn How-to define & assign Data Exchange Definition, and Bank Export/Import Setup with associated Bank Account Card. ✅Hint 2: Read the related Short-Blog post on this Topic... https://navisionfunctionalexpert.com/... ✅Hint 3: How-To Define, Data Exchange Definition (card/page Setup)...https://navisionfunctionalexpert.com/...

Transcript

00:00Welcome to my channel, I am Glansal Mathew and today we are going to discuss about setup

00:17for bank account reconciliation statement.

00:21For bank account reconciliation statement, we need a setup.

00:27One of the setup is Export-Import.

00:31For Export-Import setup is same.

00:37Click on Export-Import.

00:39You will get this screen.

00:42This is the list page.

00:44For Export-Import setup is same.

00:49I have created the first line.

00:53Let me show you.

00:59Bank Statement File Format Result.

01:04You can setup the file.

01:08Define the bank statement file layout yourself.

01:14You can also check from here.

01:17Upload a bank statement file so that we can detect the format and match the column definition.

01:23OK.

01:28Skip.

01:40I have kept 3.

01:44Date Column Number.

01:49Amount Description.

01:52Amount will be on 3rd column.

01:55Description will be on 2nd column.

01:59Date Format.

02:02DD, MM, YM.

02:08Decimal Separator.

02:11You can keep a dot or comma.

02:25Let's try.

02:26Test the Bank Statement File Format.

02:32Boost.

02:34Now I have created a file.

02:40See.

02:42This is the preview of my file.

02:48Next.

02:50Check.

02:52You are all set.

02:54You want to attach this format to a bank account now.

02:57So you can import bank transaction right away.

03:02Which bank account?

03:03You can give the format code.

03:06Whatever you want to give here.

03:08Like.

03:11Bank.

03:14Import.

03:25Let's take the first one.

03:33You can take the second one.

03:35Otherwise, it will overwrite.

03:37Let's take the second bank.

03:39Because it is already defined for zero.

03:42Let's put it here.

03:45Done.

03:46We have also made this one.

03:49Like this.

03:54Okay.

03:55You can also make it like this.

03:59System will boost the maximum for you.

04:03You have to take the code.

04:05The name of the code you want to keep.

04:07It has a description.

04:09Direction Import.

04:11Processing Code Unit.

04:13System has taken it.

04:141270.

04:15You can also check by clicking on it.

04:18Code Unit.

04:211270.

04:23Okay.

04:24Launcher General.

04:27And like this.

04:31It is an exchange launcher.

04:33Because data is being exchanged.

04:35That's why.

04:39Here you have to assign the code of the data definition.

04:44You can choose the new one.

04:49Or you can make a new one.

04:51You can choose from the list.

04:55After that.

04:57System will take the rest of the things.

05:01You can check like this.

05:03And.

05:09We will also check the data definition.

05:12Okay.

05:20This one is also new.

05:26You can check what the system has taken.

05:30In the system.

05:31You can check the entire header.

05:33We took the code.

05:35Already a description has been captured in it.

05:40Bank Statement Import.

05:42Reading Writing.

05:43XML Code.

05:451220.

05:46Exchange Data Handling Code Unit.

05:521240.

05:541240.

05:56Okay.

05:57We will also check the right-hand side.

05:59File Encoding Windows.

06:03Column Separator, Comma.

06:07More.

06:09Yes.

06:12Column.

06:14C.

06:17Description.

06:18And.

06:20System.

06:23This.

06:26More.

06:29Line Definition.

06:33Line Definition.

06:38Field Mapping.

06:42Line Field Mapping.

06:44With the.

06:45Related Table.

06:46Which table?

06:47Table is.

06:50Bank Account Reconciliation Line.

06:53274 Table ID.

06:55This will be connected to this.

06:58After that.

07:00You also need a Mapping Code Unit.

07:02Mapping Code Unit.

07:03Specifies the code unit.

07:05That is used to map the specified column.

07:07Or XML data elements.

07:09So fields.

07:10Microsoft Dynamics 365.

07:12Check here.

07:141248 Code Unit.

07:15Process Bank Account Reconciliation Line.

07:17This is mapping with the line.

07:20I.

07:22The column I made.

07:23123.

07:25Its mapping is here.

07:27If you make more columns.

07:29You.

07:30Here.

07:31Or mapping.

07:33Is.

07:34Check.

07:37Up to.

07:40Bank Account Reconciliation.

07:43Shortcut.

07:46Shortcut.

07:49Up search.

07:52Up to.

07:55Up to.

07:58Up to.

08:01Right.

08:04NBL.

08:07No Bank Statement Line Exists.

08:10No.

08:13Bank Statement Line.

08:16Or.

08:19No.

08:22According.

08:25Mapping.

08:28Mapping.

08:31Mapping.

08:34Mapping.

08:37Transfer Tab.

08:40Already.

08:43Okay.

08:46Maximum.

08:49Okay.

08:52Okay.

08:55Data Import.

08:58Import Bank Statement.

09:01File.

09:04File.

09:07File.

09:10File.

09:13A.

09:16A.

09:19A.

09:22C.

09:25C.

09:28C.

09:31C.

09:34C.

09:37C.

09:40C.

09:43C.

09:46C.

09:49C.

09:52C.

09:55C.

09:58C.

10:01C.

10:04C.

10:07C.

10:10C.

10:13C.

10:16C.

10:19C.

10:22C.

10:25C.

10:28C.

10:31C.

10:34C.

10:37C.

10:40C.

10:43C.

10:46C.

10:49C.

10:52C.

10:55C.

10:58C.

11:01C.

11:04C.

11:07C.

11:10C.

11:13C.

11:16C.

11:19C.

11:22C.

11:25C.

11:28C.

11:31C.

11:34C.

11:37C.

11:40C.

11:43C.

11:46C.

11:49C.

11:52C.

11:55C.

11:58C.

12:01C.

12:04C.

12:07C.

12:10C.

12:13C.

12:16C.

12:19C.

12:22C.

12:25C.

12:28C.

12:31C.

12:34C.

12:37C.

12:40C.

12:43C.

12:46C.

12:49C.

12:52C.

12:55C.

12:58C.

13:01C.

13:04C.

13:07C.

13:10C.

13:13C.

13:16C.

13:19C.

13:22C.

13:25C.

13:28C.

13:31C.

13:34C.

13:37C.

13:40C.

13:43C.

13:46C.

13:49C.

13:52C.

13:55C.

13:58C.

14:01C.

14:04C.

14:07C.

14:10C.

14:13C.

14:16C.

14:19C.

14:22C.

14:25C.

14:28C.

14:31C.

14:34C.

14:37C.

14:40C.

14:43C.

14:46C.

14:49C.

14:52C.

14:55C.

14:58C.

15:01C.

15:04C.

15:07C.

15:10C.

15:13C.

15:16C.

15:19C.

15:22C.

15:25C.

15:28C.

15:31C.

15:34C.

15:37C.

15:40C.

15:43C.

15:46C.

15:49C.

15:52C.

15:55C.

15:58C.

16:01C.

16:04C.

16:07C.

16:10C.

16:13C.

16:16C.

16:19C.

16:22C.

16:25C.

16:28C.

16:34C.

16:37C.

16:40C.

16:43C.

16:46C.

16:49C.

16:52C.

16:55C.

16:58C.

17:01C.

17:04C.

17:07C.

17:10C.

17:13C.

17:16C.

17:19C.

17:22C.

17:25C.

17:28C.

17:31C.

17:34C.

17:37C.

17:40C.

17:43C.

17:46C.

17:49C.

17:52C.

17:55C.

17:58C.

18:01C.

18:04C.

18:07C.

18:10C.

18:13C.

18:16C.

18:19C.

18:22C.

18:25C.

18:28C.

18:31C.

18:34C.

18:37C.

18:40C.

18:43C.

18:46C.

18:49C.

18:52C.

18:55C.

18:58C.

19:01C.

19:07C.

19:10C.

19:13C.

19:16C.

19:19C.

19:22C.

19:25C.

19:28C.

19:31C.

19:34C.

19:37C.

19:40C.

19:43C.

19:46C.

19:49C.

19:52C.

19:55C.

19:58C.

20:01C.

20:04C.

20:07C.

20:10C.

20:13C.

20:16C.

20:19C.

20:22C.

20:25C.

20:28C.

20:31C.

20:34C.

20:37C.

20:40C.

20:43C.

20:46C.

20:49C.

20:52C.

20:55C.

20:58C.

21:01C.

21:04C.

21:07C.

21:10C.

21:13C.

21:16C.

21:19C.

21:22C.

21:25C.

21:28C.

21:31C.

21:34C.

21:37C.

21:40C.

21:43C.

21:46C.

21:49C.

21:52C.

21:55C.

21:58C.

22:01C.

22:04C.

22:10C.

22:13C.

22:16C.

22:19C.

22:22C.

22:25C.

22:28C.

22:31C.

22:34C.

22:37C.

22:40C.

22:43C.

22:46C.

22:49C.

22:52C.

22:55C.

22:58C.

23:01C.

23:04C.

23:07C.

23:10C.

23:13C.

23:16C.

23:19C.

23:22C.

23:25C.

23:28C.

23:31C.

23:34C.

23:37C.

23:40C.

23:43C.

23:46C.

23:49C.

Category

Transcript

Recommended