GP to BC Compare: Customer 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 CUSTOMERS 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 |
|
18 |
21 |
Customer Card |
188 |
|
RM00101 |
Customer Master |
Customer Maintenance |
103 |
|
222 |
300 |
Ship-To Address |
36 |
|
RM00102 |
Customer Address Master |
Customer Address
Maintenance |
33 |
|
13 |
5116 |
Salesperson/Purchaser
Card |
31 |
|
RM00301 |
Salesperson Master |
Salesperson Maintenance |
39 |
This next table shows the best and most important field matches for the customer master records between Dynamics GP and Business Central.
|
Business Central |
|
Dynamics GP |
|
The Dynamics Mindset |
||
|
Table 18 |
|
Table RM00101 |
|
GP to BC CUSTOMER Field
Mapping Notes |
||
|
Field |
Field Length |
|
Field |
Field Length |
|
**Filtered and Mapped
Fields |
|
No. |
Code 20 |
|
CUSTNMBR |
15 |
|
Auto-numbering available
in BC |
|
Name |
Text 100 |
|
CUSTNAME |
64 |
|
|
|
Bill-to Customer No. |
Code 20 |
|
CPRCSTNM |
15 |
|
BC concept for
Parent/Child may not align functionally |
|
Contact |
Text 100 |
|
CNTCPRSN |
60 |
|
|
|
Name 2 |
Text 50 |
|
STMTNAME |
64 |
|
If mapped this way, BC
is 14 char less than GP |
|
Search Name |
Code 100 |
|
SHRTNAME |
15 |
|
|
|
Ship-to Code |
Code 10 |
|
ADRSCODE |
15 |
|
BC is 5 char less than GP |
|
UPS Zone |
Code 2 |
|
UPSZONE |
3 |
|
|
|
Shipment Method Code |
Code 10 |
|
SHIPMTHD |
15 |
|
BC is 5 char less than GP; may not align functionally |
|
Address |
Text 100 |
|
ADDRESS1 |
60 |
|
|
|
Address 2 |
Text 50 |
|
ADDRESS2 |
60 |
|
BC is 10 char less than GP |
|
Country/Region Code |
Code 10 |
|
COUNTRY |
60 |
|
BC Region/Country (table
9, page 10) |
|
City |
Text 30 |
|
CITY |
35 |
|
BC is 5 char less than GP |
|
State (County) |
Text 30 |
|
STATE |
29 |
|
|
|
ZIP Code (Post Code) |
Code 20 |
|
ZIP |
10 |
|
BC has optional Post
Code (table 225, page 367) |
|
Phone No. |
Text 30 |
|
PHONE1 |
20 |
|
BC only allows numbers |
|
Fax No. |
Text 30 |
|
FAX |
20 |
|
BC only allows numbers |
|
Salesperson Code |
Code 20 |
|
SLPRSNID |
15 |
|
BC uses a shared
Salesperson/Purchaser card (table 13, page 5116) |
|
Preferred Bank Account
Code |
Code 20 |
|
CHEKBKID |
15 |
|
Customer-preferred bank
(not GP Checkbook ID) |
|
Payment Terms Code |
Code 10 |
|
PYMTRMID |
20 |
|
BC is 10 char less than GP; BC Payment Terms (table 3, page 4) |
|
Credit Limit ($) |
Decimal 20 |
|
CRLMTAMT |
numeric |
|
|
|
Currency Code |
Code 10 |
|
CURNCYID |
15 |
|
BC only needs currency
if not functional; Currency (table 4, page 5) |
|
Blocked |
Option |
|
INACTIVE |
|
|
BC Blocked/Unblocked; GP
Active/Inactive |
|
Registration No. |
Text 50 |
|
TAXEXMT1 |
25 |
|
|
|
Tax Exemption No. |
Text 30 |
|
TAXEXMT2 |
25 |
|
|
|
Tax Registration No.
(VAT) |
Text 20 |
|
TXRGNNUM |
25 |
|
BC is 5 char less than GP |
|
Priority |
Integer |
|
CUSTPRIORITY |
small int |
|
|
|
Combine Shipments |
Boolean |
|
SHIPCOMPLETE |
tiny int |
|
|
This table shows the Dynamics GP customer 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 |
|
Table RM00101 |
|
GP to BC CUSTOMER Field
Mapping Notes |
|
Field |
|
**UN-Mapped Fields |
|
ADDRESS3 |
|
BC does not have Address
3 |
|
BALNCTYP |
|
Open Item or Balance
Forward |
|
BANKNAME |
|
GP Customer Bank Name |
|
BNKBRNCH |
|
GP Customer Bank Branch |
|
CBVAT |
|
GP Cash Basis VAT |
|
CCode |
|
BC Region/Country (table
9, page 10) |
|
CCRDXPDT |
|
Customer Credit Card
Expiration Date |
|
COMMENT1 |
|
BC does not have
user-defined fields on the customer |
|
COMMENT2 |
|
BC does not have
user-defined fields on the customer |
|
CRCARDID |
|
Customer Credit Card ID |
|
CRCRDNUM |
|
Customer Credit Card
number |
|
CREATDDT |
|
System-generated |
|
CRLMTPAM |
|
Credit Limit Amount |
|
CRLMTPER |
|
Credit Limit Period
Bucket |
|
CRLMTTYP |
|
Credit Limit Type |
|
CUSTCLAS |
|
BC Customer Template is closest concept to GP Classes. Also consider Customer
Posting Groups in BC for default GL accounts |
|
CUSTDISC |
|
GP Customer Discounts |
|
DECLID |
|
GP Tax Declarant ID |
|
DEFCACTY |
|
|
|
DEX_ROW_ID |
|
System-generated |
|
DEX_ROW_TS |
|
System-generated |
|
DISGRPER |
|
BC handles grace period
on the Finance Charge Terms |
|
DOCFMTID |
|
|
|
DUEGRPER |
|
BC handles grace period
on the Finance Charge Terms |
|
FINCHDLR |
|
Finance Charge Amount |
|
FINCHID |
|
BC uses Finance Charge
Terms (table 5; page 494) |
|
FNCHATYP |
|
Finance Charge Type |
|
FNCHPCNT |
|
Finance Charge Percent |
|
FRSTINDT |
|
System-generated |
|
GOVCRPID |
|
|
|
GOVINDID |
|
|
|
GPSFOINTEGRATIONID |
|
|
|
HOLD |
|
BC does not have a
comparable Customer Hold feature; use Blocked instead |
|
INCLUDEINDP |
|
GP Include in Depot
Management |
|
INTEGRATIONID |
|
|
|
INTEGRATIONSOURCE |
|
|
|
KPCALHST |
|
GP option flag; not
relevant to BC |
|
KPDSTHST |
|
GP option flag; not
relevant to BC |
|
KPERHIST |
|
GP option flag; not
relevant to BC |
|
KPTRXHST |
|
GP option flag; not
relevant to BC |
|
MINPYDLR |
|
Miminum Payment Amount |
|
MINPYPCT |
|
Mimimum Payment Percentage |
|
MINPYTYP |
|
Minimum Payment Type |
|
MODIFDT |
|
System-generated |
|
MXWOFTYP |
|
None/Unlimited |
|
MXWROFAM |
|
Max writeoff
amount |
|
NOTEINDX |
|
System-generated |
|
ORDERFULFILLDEFAULT |
|
GP Back Order or Cancel
Document |
|
PHONE2 |
|
|
|
PHONE3 |
|
|
|
Post_Results_To |
|
GP Multicurrency |
|
PRBTADCD |
|
GP Primary Customer
Address ID |
|
PRCLEVEL |
|
Price Level |
|
PRSTADCD |
|
GP Ship To Address ID |
|
RATETPID |
|
GP Multicurrency |
|
Revalue_Customer |
|
GP Multicurrency |
|
RMARACC |
|
GP posting account; maps
to General, Customer, and General Product Posting Groups |
|
RMAVACC |
|
GP posting account; maps
to General, Customer, and General Product Posting Groups |
|
RMCOSACC |
|
GP posting account; maps
to General, Customer, and General Product Posting Groups |
|
RMCSHACC |
|
GP posting account; maps
to General, Customer, and General Product Posting Groups |
|
RMFCGACC |
|
GP posting account; maps
to General, Customer, and General Product Posting Groups |
|
RMIVACC |
|
GP posting account; maps
to General, Customer, and General Product Posting Groups |
|
RMOvrpymtWrtoffAcctIdx |
|
GP posting account; maps
to General, Customer, and General Product Posting Groups |
|
RMSLSACC |
|
GP posting account; maps
to General, Customer, and General Product Posting Groups |
|
RMSORACC |
|
GP posting account; maps
to General, Customer, and General Product Posting Groups |
|
RMTAKACC |
|
GP posting account; maps
to General, Customer, and General Product Posting Groups |
|
RMWRACC |
|
GP posting account; maps
to General, Customer, and General Product Posting Groups |
|
SALSTERR |
|
Sales Territory |
|
Send_Email_Statements |
|
BC uses Document Sending
Profiles |
|
STADDRCD |
|
GP Statement To Address ID |
|
STMTCYCL |
|
GP Customer Statement
Cycle |
|
TAXSCHID |
|
BC taxes map to Tax
Areas (table 318, page 464) and Jurisdictions (table 320, page 466) |
|
USERDEF1 |
|
BC does not have
user-defined fields on the customer |
|
USERDEF2 |
|
BC does not have
user-defined fields on the customer |
|
USERLANG |
|
|
This table shows the Business Central customer 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 18 |
|
GP to BC CUSTOMER Field
Mapping Notes |
|
Field |
|
**UN-Mapped Fields |
|
Allow Line Disc. |
|
Customer-specific
discount configuration option |
|
Allow Multiple Posting
Groups |
|
GL Posting Configuration |
|
Amount |
|
BC auto-summary field |
|
Application Method |
|
Manual, or Oldest First |
|
Balance |
|
BC auto-summary field |
|
Balance ($) |
|
BC auto-summary field |
|
Balance Due |
|
BC auto-summary field |
|
Balance Due ($) |
|
BC auto-summary field |
|
Balance on Date |
|
BC auto-summary field |
|
Balance on Date ($) |
|
BC auto-summary field |
|
Bank Communication |
|
Language option for bank
communication |
|
Base Calendar Code |
|
Customer-specific
calendar |
|
Bill-To No. of Blanket
Orders |
|
BC auto-summary field |
|
Bill-To No. of Credit
Memos |
|
BC auto-summary field |
|
Bill-To No. of Invoices |
|
BC auto-summary field |
|
Bill-To No. of Orders |
|
BC auto-summary field |
|
Bill-To No. of Pstd. Cr. Memos |
|
BC auto-summary field |
|
Bill-To No. of Pstd. Invoices |
|
BC auto-summary field |
|
Bill-To No. of Pstd. Return R. |
|
BC auto-summary field |
|
Bill-To No. of Pstd. Shipments |
|
BC auto-summary field |
|
Bill-To No. of Quotes |
|
BC auto-summary field |
|
Bill-To No. of Return
Orders |
|
BC auto-summary field |
|
Block Payment Tolerance |
|
BC customer config
option |
|
Budgeted Amount |
|
|
|
Cash Flow Payment Terms
Code |
|
BC Cash Flow Forecasting
module config |
|
CFDI Customer Name |
|
For Community
Development Financial Institution reporting |
|
CFDI Export Code |
|
For Community
Development Financial Institution reporting |
|
CFDI General Public |
|
For Community
Development Financial Institution reporting |
|
CFDI Period |
|
For Community
Development Financial Institution reporting |
|
CFDI Purpose |
|
For Community
Development Financial Institution reporting |
|
CFDI Relation |
|
For Community
Development Financial Institution reporting |
|
Chain Name |
|
|
|
Check Date Format |
|
BC format option |
|
Check Date Separator |
|
BC format option |
|
Collection Method |
|
|
|
Comment |
|
BC does not have
user-defined fields on the customer |
|
Contact Graph Id |
|
System-generated |
|
Contact ID |
|
System-generated |
|
Contact Type |
|
BC Service Contract
option |
|
Contract Gain/Loss
Amount |
|
BC Service Contract
profitability |
|
Copy Sell-to Addr. to Qte From |
|
BC Customer Address
option |
|
Coupled to Dataverse |
|
For BC sync to D365
Sales (CRM) |
|
Coupled to Dataverse |
|
For BC sync to D365
Sales (CRM) |
|
Cr. Memo Amounts |
|
BC auto-summary field |
|
Cr. Memo Amounts ($) |
|
BC auto-summary field |
|
Created At |
|
System-generated |
|
Created By |
|
System-generated |
|
Credit Amount |
|
BC auto-summary field |
|
Credit Amount ($) |
|
BC auto-summary field |
|
CURP No. |
|
BC Electronic Document
config (European) |
|
Currency Id |
|
System-generated |
|
Customer Disc. Group |
|
Customer Discounts is a
new concept for GP users |
|
Customer Posting Group |
|
GL Posting Configuration |
|
Customer Price Group |
|
BC Pricing for customer
sales |
|
Customergroup Code |
|
|
|
Debit Amount |
|
BC auto-summary field |
|
Debit Amount ($) |
|
BC auto-summary field |
|
Department Code |
|
BC Global dimension |
|
Disable Search by Name |
|
|
|
Document Sending Profile |
|
BC customer config
option |
|
Email |
|
This resides on the
Internet Information window in GP (SY01200) |
|
EORI Number |
|
BC Electronic Document
config (European) |
|
Exclude from Payment
Practices |
|
BC vendor payment
reporting |
|
Fin. Charge Memo Amounts
($) |
|
BC auto-summary field |
|
Fin. Charge Terms Code |
|
BC uses Finance Charge
Terms (table 5; page 494) |
|
Finance Charge Memo
Amounts |
|
BC auto-summary field |
|
Format Region |
|
1033 is United States |
|
Gen. Bus. Posting Group |
|
GL Posting Configuration |
|
GLN |
|
BC Electronic Document
config (European) |
|
Home Page |
|
This resides on the
Internet Information window in GP (SY01200) |
|
IC Partner Code |
|
BC Intercompany |
|
Intrastat Partner Type |
|
Intrastat config
(European) |
|
Inv. Amounts ($) |
|
BC auto-summary field |
|
Inv. Discounts ($) |
|
BC auto-summary field |
|
Invoice Amounts |
|
BC auto-summary field |
|
Invoice Copies |
|
|
|
Invoice Disc. Code |
|
Invoice Discounts is a
new concept for GP users |
|
Language Code |
|
Customer-specific
language config option |
|
Last Date Modified |
|
System-generated |
|
Last Modified Date Time |
|
System-generated |
|
Last Statement No. |
|
System-generated |
|
Location Code |
|
Fulfillment
warehouse/location for the customer |
|
Mobile Phone No. |
|
|
|
Modified At |
|
System-generated |
|
Modified By |
|
System-generated |
|
Net Change |
|
BC auto-summary field |
|
Net Change ($) |
|
BC auto-summary field |
|
No. Of Archived Doc. |
|
BC auto-summary field |
|
No. of Blanket Orders |
|
BC auto-summary field |
|
No. of Credit Memos |
|
BC auto-summary field |
|
No. of Invoices |
|
BC auto-summary field |
|
No. of Orders |
|
BC auto-summary field |
|
No. of Pstd. Credit Memos |
|
BC auto-summary field |
|
No. of Pstd. Invoices |
|
BC auto-summary field |
|
No. of Pstd. Return Receipts |
|
BC auto-summary field |
|
No. of Pstd. Shipments |
|
BC auto-summary field |
|
No. of Quotes |
|
BC auto-summary field |
|
No. of Return Orders |
|
BC auto-summary field |
|
No. of Ship-to Addresses |
|
BC auto-summary field |
|
No. Series |
|
System-generated |
|
Other Amounts |
|
BC auto-summary field |
|
Other Amounts ($) |
|
BC auto-summary field |
|
Our Account No. |
|
Account number with
customer |
|
Outstanding Invoices |
|
BC auto-summary field |
|
Outstanding Invoices ($) |
|
BC auto-summary field |
|
Outstanding Orders |
|
BC auto-summary field |
|
Outstanding Orders ($) |
|
BC auto-summary field |
|
Outstanding Serv. Orders
($) |
|
BC auto-summary field |
|
Outstanding Serv.Invoices($) |
|
BC auto-summary field |
|
Partner Type |
|
BC Intercompany; Company
or Person |
|
Payment Method Code |
|
Payment Method is a new
concept for GP users. |
|
Payment Method Id |
|
System-generated |
|
Payment Terms Id |
|
System-generated |
|
Payments |
|
BC auto-summary field |
|
Payments ($) |
|
BC auto-summary field |
|
Place of Export |
|
|
|
Pmt. Disc. Tolerance ($) |
|
BC auto-summary field |
|
Pmt. Discounts ($) |
|
BC auto-summary field |
|
Pmt. Tolerance ($) |
|
BC auto-summary field |
|
Prepayment % |
|
BC Customer prepayment
option for orders |
|
Price Calculation Method |
|
For Community
Development Financial Institution reporting |
|
Prices Including Tax |
|
BC tax config for VAT |
|
Primary Contact No. |
|
BC uses Contact Cards on
customers (table 5050, page 5050) |
|
Print Statements |
|
BC customer config
option |
|
Privacy Blocked |
|
BC feature limits access
to the Customer |
|
Profit ($) |
|
BC auto-summary field |
|
Refunds |
|
BC auto-summary field |
|
Refunds ($) |
|
BC auto-summary field |
|
Reminder Amounts |
|
BC auto-summary field |
|
Reminder Amounts ($) |
|
BC auto-summary field |
|
Reminder Terms Code |
|
BC uses Reminder Terms
(table 292; page 431) |
|
Reserve |
|
BC sales item
reservation config |
|
Responsibility Center |
|
BC labeling and grouping
option |
|
RFC No. |
|
BC Electronic Document
config (European) |
|
RowVersion |
|
System-generated |
|
Sales ($) |
|
BC auto-summary field |
|
SAT Tax Regime
Classification |
|
For Community
Development Financial Institution reporting |
|
Sell-to No. Of Archived Doc. |
|
BC auto-summary field |
|
Serv Shipped Not Invoiced($) |
|
BC auto-summary field |
|
Service Zone Code |
|
BC Service Code for
services transactions |
|
Shipment Method Id |
|
System-generated |
|
Shipped Not Invoiced |
|
BC auto-summary field |
|
Shipped Not Invoiced ($) |
|
BC auto-summary field |
|
Shipping Advice |
|
Complete or Partial |
|
Shipping Agent Code |
|
Shipping company for
vendor products |
|
Shipping Agent Service
Code |
|
Shipping company service
option for customer delivery |
|
Shipping Time |
|
Expected days for
transit |
|
State Inscription |
|
BC Electronic Document
config (European) |
|
Statistics Group |
|
|
|
System ID |
|
System-generated |
|
Tax Area Code |
|
BC Tax Config |
|
Tax Area ID |
|
System-generated |
|
Tax Identification Type |
|
BC Legal Entity/Natural
Person |
|
Tax Liable |
|
BC Tax Config |
|
Telex Answer Back |
|
BC Customer banking
config option |
|
Telex No. |
|
BC Customer banking
config option |
|
Territory Code |
|
BC picklist for
assigning to Contacts (table 286, page 429) |
|
Use GLN in Electronic
Documents |
|
BC Electronic Document
config (European) |
|
Validate EU VAT Reg. No. |
|
System-generated |
|
VAT Bus. Posting Group |
|
GL Posting Configuration |
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!