Agenda of the Video: Based on any Company Requirement, we can manually assign Columns for BRS Report using Data Exchange Definition Setup.
➡️To create a Customised Bank Statement Report, take the help of a Developer or Technical Consultant.
✅Hint: BRS = Bank Reconciliation Statement,
OR
Bank Account Statement (Report).
#brs #statement #StatementReport #microsoftdynamics365businesscentral #d365bc #finance #bankBook #bankreconciliationstatement #microsoft
---------------------------------------------------------------------------
✅Topic: Custom Design or Manual Creation of Data Exchange Definition Setup (for Import Bank Statement, File Format) in Business Central
Report Name = Statement Report
Number of Columns = 6
➡️1️⃣ Transaction Date✅
➡️2️⃣ Description (Transaction Details)✅
➡️3️⃣ Statement Amount✅
➡️4️⃣ Value Date (Bank Clearing Date)✅
➡️5️⃣ Related Party Name✅
➡️6️⃣ Related Party Transaction Details (Reference)✅
---------
You may also add...
➡️7️⃣ Check (Cheque) Number (No.)✅
➡️8️⃣ Check (Cheque) Date (issue date)✅
➡️➡️9️⃣ Debit (Dr.) Amount✅
➡️1️⃣0️⃣ Credit (Cr.) Amount✅
---------
Outcome➡️ Match Balance as per Company Bank Book = Balance as Per Pass Book (Bank Book).
Read the related Blog Post: ➡️https://navisionfunctionalexpert.com/...
-------------------------------------------------------------------------
