GP to BC Compare: Checkbook / Banking Master Record Tables
There are many differences between Dynamics GP and Dynamics 365 Business Central, but this page highlights the technical differences important to me between the primary master record tables for BANK ACCOUNTS for carrying over this information to BC. BC is not GP in the cloud, as you can see by the underlying table structure differences for these master records.
|
|
|
|
|
|
|
|
|
|
|
Business Central |
|
Dynamics GP |
||||||
|
Table ID |
Page ID |
Page Name |
Table Columns |
|
Table ID |
Table Name |
Form Name |
Table Columns |
|
270 |
370 |
Bank Account Card |
101 |
|
CM00100 |
Checkbook Master |
Checkbook Maintenance |
41 |
|
|
|
|
|
|
SY04100 |
Bank Master |
Bank Maintenance |
18 |
|
|
|
|
|
|
CM0101 |
Checkbook EFT Master |
Checkbook EFT Bank
Maintenance |
67 |
This next table shows the best and most important field matches for the bank account records between Dynamics GP and Business Central.
|
Business Central |
|
Dynamics GP |
|
Dynamics GP |
|
Dynamics GP |
|
The Dynamics Mindset |
||||
|
Table 270 |
|
Table CM00100 |
|
Table SY04100 |
|
Table CM00101 |
|
GP to BC CHECKBOOK Field
Mapping Notes |
||||
|
Field |
Field Length |
|
Field |
Field Length |
|
Field |
Field Length |
|
Field |
Field Length |
|
**Filtered and Mapped
Fields |
|
No. |
Code 20 |
|
CHEKBKID |
15 |
|
|
|
|
CHEKBKID |
15 |
|
|
|
Name |
Text 100 |
|
DSCRIPTN |
30 |
|
|
|
|
|
|
|
|
|
Address |
Text 100 |
|
|
|
|
ADDRESS1 |
60 |
|
|
|
|
|
|
Address 2 |
Text 50 |
|
|
|
|
ADDRESS2 |
60 |
|
|
|
|
BC is 10 char less than GP |
|
City |
Text 30 |
|
|
|
|
CITY |
35 |
|
|
|
|
BC is 5 char less than GP |
|
State |
Text 30 |
|
|
|
|
STATE |
29 |
|
|
|
|
|
|
ZIP Code |
Code 20 |
|
|
|
|
ZIPCODE |
10 |
|
|
|
|
|
|
Country/Region Code |
Code 10 |
|
|
|
|
COUNTRY |
60 |
|
CCode |
6 |
|
BC Region/Country (table
9, page 10) |
|
Phone No. |
Text 30 |
|
|
|
|
PHNUMBR1 |
20 |
|
|
|
|
BC only allows numbers |
|
Fax No. |
Text 30 |
|
|
|
|
FAXNUMBR |
20 |
|
|
|
|
|
|
Currency Code |
Code 10 |
|
CURNCYID |
15 |
|
|
|
|
ISOCURRC |
15 |
|
BC only needs currency
if not functional; Currency (table 4, page 5) |
|
Last Check No. |
Code 20 |
|
NXTCHNUM |
20 |
|
|
|
|
|
|
|
Last/Next Check number |
|
Blocked |
Option |
|
INACTIVE |
|
|
|
|
|
|
|
|
BC Blocked/Unblocked; GP
Active/Inactive |
|
Bank Account No. |
Text 30 |
|
BNKACTNM |
15 |
|
DDTRANUM |
9 |
|
EFTBankAcct |
35 |
|
BC is 5 char less than GP |
|
Transit No. |
Text 20 |
|
|
|
|
TRNSTNBR |
9 |
|
EFTTransitRoutingNo |
10 |
|
|
|
Bank Branch No. |
Text 20 |
|
|
|
|
BNKBRNCH |
20 |
|
EFTBankBranch |
5 |
|
|
|
IBAN |
Code 50 |
|
|
|
|
|
|
|
IntlBankAcctNum |
35 |
|
|
This table shows the Dynamics GP bank account master table fields not included in the matched field mapping above.
Many simply don’t fit, or their purpose is conceptually or fundamentally different or incompatible with a clean, straight mapping of data from GP to Business Central.
|
Dynamics GP |
|
The Dynamics Mindset |
|
CM00100 |
|
GP to BC CHECKBOOK
MASTER Field Mapping Notes |
|
Field |
|
**UN-Mapped Fields |
|
ACTINDX |
|
GL Posting Account |
|
ADPVADLR |
|
|
|
ADPVAPWD |
|
|
|
BANKID |
|
BC does no have a Bank master |
|
CashInTransAcctIdx |
|
GL Posting Account |
|
CHBKPSWD |
|
GP checkbook password |
|
CHKBKTYP |
|
|
|
CMPANYID |
|
|
|
CMUSRDF1 |
|
BC does not have
user-defined fields on the customer |
|
CMUSRDF2 |
|
BC does not have
user-defined fields on the customer |
|
CREATDDT |
|
System-generated |
|
CRNCYRCD |
|
|
|
CURNCYPD |
|
|
|
CURRBLNC |
|
|
|
DDACTNUM |
|
GP Payroll |
|
DDINDNAM |
|
GP Payroll |
|
DDTRANS |
|
GP Payroll |
|
Deposit_In_Progress |
|
System-generated |
|
DepositRateTypeID |
|
GP Multicurrency |
|
DEX_ROW_ID |
|
System-generated |
|
DUPCHNUM |
|
Allow duplicate check
numbers |
|
DYCHTCLR |
|
|
|
DYDEPCLR |
|
|
|
Last_Reconciled_Balance |
|
System-generated |
|
Last_Reconciled_Date |
|
System-generated |
|
LOCATNID |
|
|
|
MODIFDT |
|
System-generated |
|
MXCHDLR |
|
Max check amount |
|
Next_Deposit_Number |
|
System-generated |
|
NOTEINDX |
|
System-generated |
|
OVCHNUM1 |
|
GP checkbook password |
|
PaymentRateTypeID |
|
GP Multicurrency |
|
Reconcile_In_Progress |
|
System-generated |
|
Recond |
|
System-generated |
|
XCDMCHPW |
|
|
|
Dynamics GP |
|
The Dynamics Mindset |
|
SY04100 |
|
GP to BC BANK MASTER
Field Mapping Notes |
|
Field |
|
**UN-Mapped Fields |
|
ADDRESS3 |
|
BC does not have Address
3 |
|
DEX_ROW_ID |
|
System-generated |
|
NOTEINDX |
|
System-generated |
|
PHNUMBR2 |
|
|
|
PHONE3 |
|
|
|
Dynamics GP |
|
The Dynamics Mindset |
|
CM00101 |
|
GP to BC CHECKBOOK EFT
Field Mapping Notes |
|
Field |
|
**UN-Mapped Fields |
|
AcctHolder |
|
|
|
BankIDNum |
|
|
|
BankInfo1 |
|
|
|
BankInfo2 |
|
|
|
BankInfo3 |
|
|
|
BankInfo4 |
|
|
|
BankInfo5 |
|
|
|
BankInfo6 |
|
|
|
DEX_ROW_ID |
|
System-generated |
|
DomDirDbtCollectFile |
|
GP export pathname |
|
DomDirDbtRefundFile |
|
GP export pathname |
|
DomPmtsFile |
|
GP export pathname |
|
EFTBankBranchCode |
|
BC uses Data Exchange
Definitions |
|
EFTBankCheckDigit |
|
BC uses Data Exchange
Definitions |
|
EFTBankCode |
|
BC uses Data Exchange
Definitions |
|
EFTBankCoName |
|
BC uses Data Exchange
Definitions |
|
EFTBankType |
|
BC uses Data Exchange
Definitions |
|
EFTBlockingFactor |
|
BC uses Data Exchange
Definitions |
|
EFTCommunicationFile |
|
GP export pathname |
|
EFTCommunicationType |
|
BC uses Data Exchange
Definitions |
|
EFTCompanyID |
|
BC uses Data Exchange
Definitions |
|
EFTDataCentreCode |
|
BC uses Data Exchange
Definitions |
|
EFTFormatCode |
|
BC uses Data Exchange
Definitions |
|
EFTNextFileNo |
|
BC uses Data Exchange
Definitions |
|
EFTPMNextNumber |
|
BC uses Data Exchange
Definitions |
|
EFTPMPostBankRecSummary |
|
BC uses Data Exchange
Definitions |
|
EFTPMPrenoteFile |
|
GP export pathname |
|
EFTPMPrenoteGracePeriod |
|
BC uses Data Exchange
Definitions |
|
EFTPMPrenoteRequired |
|
BC uses Data Exchange
Definitions |
|
EFTPMReconcile |
|
BC uses Data Exchange
Definitions |
|
EFTPMServClassAll |
|
BC uses Data Exchange
Definitions |
|
EFTPMServClassBus |
|
BC uses Data Exchange
Definitions |
|
EFTPMServClassCorp |
|
BC uses Data Exchange
Definitions |
|
EFTPMServClassForeign |
|
BC uses Data Exchange
Definitions |
|
EFTPMServClassPersonal |
|
BC uses Data Exchange
Definitions |
|
EFTPMTrxNumbers |
|
BC uses Data Exchange
Definitions |
|
EFTPreTransitDigit |
|
BC uses Data Exchange
Definitions |
|
EFTPriorityCode |
|
BC uses Data Exchange
Definitions |
|
EFTReference |
|
BC uses Data Exchange
Definitions |
|
EFTRMBankFormat |
|
BC uses Data Exchange
Definitions |
|
EFTRMNextNumber |
|
BC uses Data Exchange
Definitions |
|
EFTRMPostBankRecSummary |
|
BC uses Data Exchange
Definitions |
|
EFTRMPrenoteFile |
|
GP export pathname |
|
EFTRMPrenoteGracePeriod |
|
BC uses Data Exchange
Definitions |
|
EFTRMPrenoteRequired |
|
BC uses Data Exchange
Definitions |
|
EFTRMReconcile |
|
BC uses Data Exchange
Definitions |
|
EFTRMServClassAll |
|
BC uses Data Exchange
Definitions |
|
EFTRMServClassBus |
|
BC uses Data Exchange
Definitions |
|
EFTRMServClassForeign |
|
BC uses Data Exchange
Definitions |
|
EFTRMServClassPersonal |
|
BC uses Data Exchange
Definitions |
|
EFTRMServiceClassCorp |
|
BC uses Data Exchange
Definitions |
|
EFTServiceClassCode |
|
BC uses Data Exchange
Definitions |
|
EFTSmallCoName |
|
BC uses Data Exchange
Definitions |
|
EFTUseOriginatingCur |
|
BC uses Data Exchange
Definitions |
|
FedResBankNum |
|
|
|
FedResBranch |
|
|
|
FedResClient |
|
|
|
ForeignPmtsFile |
|
GP export pathname |
|
RMUSEEFTNUM |
|
GP use EFT numbers in
Receivables |
|
TXRGNNUM |
|
|
This table shows the Business Central bank account master table fields not included in the matched field mapping above.
Many simply don’t fit, or their purpose is conceptually or fundamentally different or incompatible with a clean, straight mapping of data from GP to Business Central.
|
Business Central |
|
The Dynamics Mindset |
|
Table 270 |
|
GP to BC BANK ACCOUNT
Field Mapping Notes |
|
Field |
|
**UN-Mapped Fields |
|
RowVersion |
|
System-generated |
|
Amount |
|
|
|
Automatic Stmt. Import
Enabled |
|
BC uses Data Exchange
Definitions |
|
Balance |
|
BC auto-summary field |
|
Balance ($) |
|
BC auto-summary field |
|
Balance at Date |
|
BC auto-summary field |
|
Balance at Date ($) |
|
BC auto-summary field |
|
Balance Last Statement |
|
BC auto-summary field |
|
Bank Acc. Posting Group |
|
|
|
Bank Clearing Code |
|
BC uses Data Exchange
Definitions |
|
Bank Clearing Standard |
|
BC uses Data Exchange
Definitions |
|
Bank Code |
|
BC uses Data Exchange
Definitions |
|
Bank Communication |
|
BC uses Data Exchange
Definitions |
|
Bank file Name |
|
|
|
Bank Name |
|
|
|
Bank Statement Import
Format |
|
BC uses Data Exchange
Definitions |
|
Bank Stmt. Service
Record ID |
|
BC uses Data Exchange
Definitions |
|
Chain Name |
|
|
|
Check Date Format |
|
Default format for
printing on checks |
|
Check Date Separator |
|
Default format for
printing on checks |
|
Check Report ID |
|
System-generated |
|
Check Report Name |
|
|
|
Check Transmitted |
|
|
|
Client Name |
|
|
|
Client No. |
|
|
|
Comment |
|
System-generated |
|
Contact |
|
|
|
Created At |
|
System-generated |
|
Created By |
|
System-generated |
|
Credit Amount |
|
BC auto-summary field |
|
Credit Amount ($) |
|
BC auto-summary field |
|
Credit Transfer Msg.
Nos. |
|
|
|
Creditor No. |
|
|
|
Customergroup Code |
|
|
|
Debit Amount |
|
BC auto-summary field |
|
Debit Amount ($) |
|
BC auto-summary field |
|
Department Code |
|
|
|
Direct Debit Msg. Nos. |
|
System-generated |
|
Disable Automatic
Payment Matching |
|
|
|
Disable Bank
Reconciliation Optimization |
|
|
|
EFT IAT Export Format |
|
BC uses Data Exchange
Definitions |
|
Email |
|
|
|
Enable for Intercompany
transactions |
|
|
|
E-Pay Export File Path |
|
|
|
E-Pay Trans. Program
Command |
|
|
|
E-Pay Trans. Program
Path |
|
|
|
Export Format |
|
BC uses Data Exchange
Definitions |
|
Format Region |
|
|
|
Home Page |
|
|
|
Input Qualifier |
|
|
|
Language Code |
|
|
|
Last ACH File ID
Modifier |
|
System-generated |
|
Last Date Modified |
|
System-generated |
|
Last E-Pay Export File
Name |
|
System-generated |
|
Last E-Pay File Creation
No. |
|
System-generated |
|
Last Payment Statement
No. |
|
System-generated |
|
Last Remittance Advice
No. |
|
System-generated |
|
Last Statement No. |
|
System-generated |
|
Match Tolerance Type |
|
|
|
Match Tolerance Value |
|
|
|
Min. Balance |
|
|
|
Mobile Phone No. |
|
|
|
Modified At |
|
System-generated |
|
Modified By |
|
System-generated |
|
Name 2 |
|
|
|
Net Change |
|
BC auto-summary field |
|
Net Change ($) |
|
BC auto-summary field |
|
No. Series |
|
System-generated |
|
Our Contact Code |
|
|
|
Payment Export Format |
|
BC uses Data Exchange
Definitions |
|
Payment Reconciliation
No. Series |
|
System-generated |
|
Positive Pay Export Code |
|
BC uses Data Exchange
Definitions |
|
Search Name |
|
|
|
SEPA Direct Debit Exp.
Format |
|
BC uses Data Exchange
Definitions |
|
Statistics Group |
|
|
|
SWIFT Code |
|
|
|
System ID |
|
System-generated |
|
Telex Answer Back |
|
|
|
Telex No. |
|
|
|
Territory Code |
|
|
|
Threshold Code |
|
|
|
Total on Checks |
|
BC auto-summary field |
|
Transaction Import
Timespan |
|
|
|
Use as Default for
Currency |
|
|
Author’s note and Disclaimer:
Mapping ERP systems is a complex and subjective task for any one person.
Significant differences between GP and BC will require you to learn more deeply about the product to perform a successful implementation.
There is more than one way to map particular fields, but I think you’ll get a lot out of the references provided.
I am not infallible, so let me know if you spot an issue I need to update. I don’t want to present anything factually incorrect here, however how you map your data in real life is up to you.
I needed to know the differences that really matter between the master records in both Dynamics GP and Business Central. I hope you gain value from my analysis and notes.
As I do more BC implementations, and if / when BC changes, I’ll keep this up to date, and make adjustments and add additional notes where needed. I’ll also work on filling in any holes to make this complete because these are MY personal reference pages too.
Some of the tables on the individual pages probably won’t render very well on some mobile devices, but try tipping it horizontally instead!