Skip to main content

Dynamics GP to Business Central - Bank Rec Tables

 


Bank Reconciliation is the process of matching your company's internal bank records (cash ledger) with the bank statement provided by your financial institution. It helps ensure accuracy in cash reporting, detect discrepancies like missing entries or fraud, and maintain up-to-date balances in your ERP system.

Both Dynamics GP and Dynamics 365 Business Central support bank reconciliation, but they handle it differently in terms of process and data structure.


BANK RECONCILIATION TABLES

GP TableDescriptionBC TableBusiness Central Equivalent
CM00100Checkbook Master270Bank Account
CM10100Deposit Work (unposted)1690
81		Bank Deposit Header
Gen. Journal Line
CM20100Bank Rec Journal271
17		Bank Account Ledger Entry (Posted)
General Ledger Entry
CM20200Transactions271Bank Account Ledger Entry
CM20201Transaction Totals271Aggregated Bank Account Ledger Entries (via reports)
CM20300Receipts271Bank Account Ledger Entry (Deposit = TRUE or via Type)
CM20400Distributions17G/L Entry
CM20500Reconciliation Headers273
274		Bank Acc. Reconciliation Header
Bank Acc. Reconciliation Line
CM20501Reconcile Adjustments273Bank Acc. Reconciliation Line (Adjustment Type)
CM20502Outstanding Transactions History271Bank Account Ledger Entry
(click on Total Outstanding Checks)
CM20600Transfers274General Journal Line (Bank Transfer Template)
CM30200Transaction History271Bank Account Ledger Entry (historical view)
CM30300Receipt History271Bank Account Ledger Entry (Deposit Receipt filter)

Labels:

Comments

Post a Comment

Popular posts from this blog

D365 Business Central - Table Information Page

  Whether you're a Business Central power user, consultant, or developer, sometimes you just want a quick look under the hood of your environment. That’s where Table Information comes in—a hidden gem in Business Central that gives you insight into what’s happening behind the scenes. Why Use the Table Information Page? Understanding what tables are being used, how large they are, and how many records they contain is especially helpful when: Diagnosing performance issues  Cleaning up test or training environments  Estimating storage impact  Reviewing customizations or ISV extensions  Step-by-Step: How to Access Table Information Here’s how you can view detailed info about every table in your current company: Go to “Tell Me” Search Press Alt + Q or click the magnifying glass 🔍 in the upper-right corner. Type: “Table Information” Select the Table Information page from the search results. Explore the Page You’ll see a list of all tables...
Post a Comment
Read more

DUG Webinar: Dynamics GP to Business Central - The Ultimate Beginner's Guide

This session is designed to give you a head start in working with Business Central so you quickly feel at home in transitioning from Dynamics GP to BC without the hustle of reading through hundreds of pages of documentation. What you'll learn: Mastering the user interface of Business Central Navigating in Business Central Editing records in Business Central Creating new records in Business Central Finding records in Business Central Personalizing the user interface of Business Central Being prepared to work with Business Central on a daily basis
Post a Comment
Read more

GP Assessment Tool

Migration Assessment :    Migration assessment (bcmigrationassessments.com) Microsoft official Documentation:    Migrate on-premises GP data to Business Central online overview - Business Central | Microsoft Learn
Post a Comment
Read more