Freelancer Madhavi
Freelancer Madhavi
  • 2 months ago
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/...

Category

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

Recommended

12:38
I
Up next
First DAX Measures in Power BI
expertiseexcelerate
4:15
Where to change effective dates for voucher in tally erp 9
tallygame
12:50
Time Intelligence Dates and Drilldown Functionality in Power BI
expertiseexcelerate
4:20
Flexibility of DAX Measures in Power BI
expertiseexcelerate
23:04
Reconcile Bank Accounts in Business Central - Import, Match, Post Bank Statement | BRS Matching Rule
Freelancer Madhavi
0:32
STOP Ads in your Phone!
Freelancer Madhavi
14:17
Bank Account Reconciliation | Bank Reconciliation Statement - Guidelines on Errors Solution | Business Central #D365BC
Freelancer Madhavi
8:32
Custom Design or Manually Create Data Exchange Definition in Business Central - Bank Account Statement (Posted BRS) Report
Freelancer Madhavi
6:17
Undo / Reverse a Bank Account Reconciliation | Reverse Posted Bank Account Statement | Undo BRS in Business Central
Freelancer Madhavi
2:08
Bank Account Card | Concept of Bank Account Posting Group AND Bank Statement Import Format Setup
Freelancer Madhavi
0:55
Print or View Bank Account Statement Report using Statement Number in Business Central
Freelancer Madhavi
11:06
BANK RECONCILIATION STATEMENT | BRS | Accounting | LetsTute Accountancy
LetsTute
10:00
GST on Bank Charges Transaction - Setup, Entries & Voucher Report in Business Central (D365BC)
Freelancer Madhavi
7:18
How to reconcile bank account with statement in Tally ERP9 -English
tallygame
0:56
Bank Charges Reports in Business Central | Overview on Posted Bank Payment Voucher & GST Return | Short !
Freelancer Madhavi
4:34
Currency Code in G/L Account Card in Business Central | For Foreign Trade Transactions
Freelancer Madhavi
5:28
#UAN Invalid Bank account no. kindly update your bank account details through self mode or employer
Rmitanchal
1:01
Cash Ledger Account Report in Business Central
Freelancer Madhavi
9:46
Reverse or Refund TDS Entries in Business Central | TDS Adjustment Journal #tdsDeductedAtSource #adjustment #journal #D365BC
Freelancer Madhavi
9:25
Reverse TCS Entries in Business Central | TCS Adjustment Journal
Freelancer Madhavi
19:08
Import from Foreign Vendor in Business Central | Purchase Goods from Foreign Vendor in D365BC | Purchase Import and Sales Export (Part-3)
Freelancer Madhavi
0:36
Shubho Mahalaya #navdurga #navratri #maaDurga
Freelancer Madhavi
7:44
How-to Create Custom Bonded Warehouse in Business Central | Define Setup for Purchase Import and Sales Export (Part-1)
Freelancer Madhavi
13:45
Generate QR Code for a Sales Invoice in Business Central | Scan to Pay QR Code of a Sales Bill #googlelens #Upi #d365bc
Freelancer Madhavi
1:38
QR Code - Update Information for Posted Sales Invoice in Business Central
Freelancer Madhavi