GP to BC Compare: Vendor 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 VENDORS 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 |
|
23 |
26 |
Vendor Card |
164 |
|
PM00200 |
PM Vendor Master |
Vendor Maintenance |
109 |
|
288 |
425 |
Vendor Bank Account |
34 |
|
SY06000 |
EFT Bank Information |
Vendor EFT Bank
Maintenance |
37 |
|
224 |
368 |
Order Address |
24 |
|
PM00300 |
PM Address Master |
Vendor Address
Maintenance |
28 |
|
2224 |
2369 |
Remit Address |
22 |
|
|
|
|
|
This next table shows the best and most important field matches for the vendor master records between Dynamics GP and Business Central.
|
Business Central |
|
Dynamics GP |
|
The Dynamics Mindset |
||
|
Table 23 |
|
Table PM00200 |
|
GP to BC VENDOR Field
Mapping Notes |
||
|
Field |
Field Length |
|
Field |
Field Length |
|
**Filtered and Mapped
Fields |
|
Vendor No. |
Code 20 |
|
VENDORID |
15 |
|
Auto-numbering available
in BC |
|
Name |
Text 100 |
|
VENDNAME |
64 |
|
|
|
Name 2 |
Text 50 |
|
VNDCHKNM |
64 |
|
BC is 14 char less than
GP |
|
Search Name |
Code 100 |
|
VENDSHNM |
15 |
|
|
|
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 |
|
BC has optional Post
Code (table 225, page 367) |
|
Country/Region Code |
Code 10 |
|
CCode |
6 |
|
BC Region/Country (table
9, page 10) |
|
Phone No. |
Text 30 |
|
PHNUMBR1 |
14 |
|
BC only allows numbers,
needs formatting |
|
Fax No. |
Text 30 |
|
FAXNUMBR |
14 |
|
BC only allows numbers,
needs formatting |
|
UPS Zone |
Code 2 |
|
UPSZONE |
3 |
|
BC is 1 char less than
GP |
|
Shipment Method Code |
Code 10 |
|
SHIPMTHD |
15 |
|
BC is 5 char less than
GP; may not align functionally |
|
Our Account No. |
Text 20 |
|
ACNMVNDR |
20 |
|
|
|
Federal ID No. |
Text 30 |
|
TXIDNMBR |
10 |
|
|
|
Blocked |
Option |
|
VENDSTTS |
integer |
|
BC Blocked/Unblocked; GP
Active/Inactive |
|
Currency Code |
Code 10 |
|
CURNCYID |
15 |
|
BC only needs currency
if not functional; Currency (table 4, page 5) |
|
Tax Registration No. |
Text 50 |
|
TXRGNNUM |
25 |
|
|
|
Tax Identification Type |
Option |
|
TEN99TYPE |
integer |
|
BC Legal Entity/Natural
Person; GP Not a 1099 Vendor, Div, Int, Misc, NEC |
|
Payment Terms Code |
Code 20 |
|
PYMTRMID |
20 |
|
BC Payment Terms (table
3, page 4) |
|
Priority |
Integer |
|
PYMNTPRI |
char -3 |
|
BC is 9 char number; GP
is 3 char alphanumeric |
This table shows the Dynamics GP vendor 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 PM00200 |
|
GP to BC VENDOR Field
Mapping Notes |
|
Field |
|
**UN-Mapped Fields |
|
ACPURIDX |
|
GP posting account; maps
to General, Vendor, and General Product Posting Groups |
|
ADDRESS3 |
|
BC does not have Address
3 |
|
BRTHDATE |
|
|
|
CBVAT |
|
|
|
CHEKBKID |
|
BC does not have default
Bank Account; determined during payment run |
|
COMMENT1 |
|
BC does not have
user-defined fields on the vendor |
|
COMMENT2 |
|
BC does not have
user-defined fields on the vendor |
|
COUNTRY |
|
BC uses the
Country/Region codes and descriptions (table 9, page 10) |
|
CREATDDT |
|
System-generated |
|
CREDTLMT |
|
BC does not have Vendor
credit limits |
|
CRLMTDLR |
|
BC does not have Vendor
credit limits |
|
CRTCOMDT |
|
|
|
CRTEXPDT |
|
|
|
DECLID |
|
|
|
DEX_ROW_ID |
|
System-generated |
|
DEX_ROW_TS |
|
System-generated |
|
DISGRPER |
|
BC does not have
discount grace period |
|
DOCFMTID |
|
|
|
DUEGRPER |
|
BC does not have due
date grace period |
|
DXVARNUM |
|
|
|
FREEONBOARD |
|
GP has None, Origin, or
Destination |
|
GOVCRPID |
|
|
|
GOVINDID |
|
|
|
HOLD |
|
BC does not have a
similar vendor hold function |
|
KGLDSTHS |
|
GP option flag; not
relevant to BC |
|
KPCALHST |
|
GP option flag; not
relevant to BC |
|
KPERHIST |
|
GP option flag; not
relevant to BC |
|
KPTRXHST |
|
GP option flag; not
relevant to BC |
|
LaborPmtType |
|
|
|
MAXINDLR |
|
|
|
MINORDER |
|
|
|
MINPYDLR |
|
|
|
MINPYPCT |
|
|
|
MINPYTYP |
|
|
|
MODIFDT |
|
System-generated |
|
MXIAFVND |
|
|
|
MXWOFAMT |
|
BC uses Payment
Tolerances, set at the module, not the vendor |
|
NOTEINDX |
|
GP posting account; maps
to General, Vendor, and General Product Posting Groups |
|
ONEPAYPERVENDINV |
|
BC does not have a
vendor option to split payments by invoice |
|
PARVENID |
|
|
|
PHNUMBR2 |
|
BC does not have Phone 2 |
|
PHONE3 |
|
BC does not have Phone 3 |
|
PMAPINDX |
|
GP posting account; maps
to General, Vendor, and General Product Posting Groups |
|
PMCSHIDX |
|
GP posting account; maps
to General, Vendor, and General Product Posting Groups |
|
PMDAVIDX |
|
GP posting account; maps
to General, Vendor, and General Product Posting Groups |
|
PMDTKIDX |
|
GP posting account; maps
to General, Vendor, and General Product Posting Groups |
|
PMFINIDX |
|
GP posting account; maps
to General, Vendor, and General Product Posting Groups |
|
PMFRTIDX |
|
GP posting account; maps
to General, Vendor, and General Product Posting Groups |
|
PMMSCHIX |
|
GP posting account; maps
to General, Vendor, and General Product Posting Groups |
|
PMPRCHIX |
|
GP posting account; maps
to General, Vendor, and General Product Posting Groups |
|
PMRTNGIX |
|
GP posting account; maps
to General, Vendor, and General Product Posting Groups |
|
PMTAXIDX |
|
GP posting account; maps
to General, Vendor, and General Product Posting Groups |
|
PMTDSCIX |
|
GP posting account; maps
to General, Vendor, and General Product Posting Groups |
|
PMWRTIDX |
|
GP posting account; maps
to General, Vendor, and General Product Posting Groups |
|
Post_Results_To |
|
GP Multicurrency |
|
PPSTAXRT |
|
|
|
PRSPAYEE |
|
|
|
PTCSHACF |
|
|
|
PURPVIDX |
|
GP posting account; maps
to General, Vendor, and General Product Posting Groups |
|
RATETPID |
|
GP Multicurrency |
|
Revalue_Vendor |
|
GP Multicurrency |
|
RTOBUTKN |
|
|
|
SBPPSDED |
|
|
|
TaxFileNumMode |
|
|
|
TaxInvRecvd |
|
|
|
TAXSCHID |
|
BC taxes map to Tax
Areas (table 318, page 464) and Jurisdictions (table 320, page 466) |
|
TEN99BOXNUMBER |
|
|
|
TRDDISCT |
|
BC Vendor Invoice
Discounts (table 24, page 28) |
|
USERDEF1 |
|
BC does not have
user-defined fields on the vendor |
|
USERDEF2 |
|
BC does not have
user-defined fields on the vendor |
|
USERLANG |
|
|
|
VADCD1099 |
|
GP vendor 1099 Address
Code |
|
VADCDPAD |
|
Purchase From vendor
address code; maps to BC Order Address (table 224, page 368) |
|
VADCDSFR |
|
Ship From vendor address
code; maps to BC Order Address (table 224, page 368) |
|
VADCDTRO |
|
1099 vendor address
code; does not map to separate BC address |
|
VADDCDPR |
|
Primary vendor address
code; difference in functionality |
|
VENDDBA |
|
Optionally map to Name2
in BC |
|
VNDCLSID |
|
BC Vendor Template is closest concept to GP Classes. Also consider Vendor
Posting Groups in BC for default GL accounts |
|
VNDCNTCT |
|
BC uses Contact Cards on
vendors (table 5050, page 5050) |
|
WithholdingEntityType |
|
|
|
WithholdingFormType |
|
|
|
WithholdingType |
|
|
|
Workflow_Approval_Status |
|
BC has its own workflow |
|
Workflow_Priority |
|
BC has its own workflow |
|
Workflow_Status |
|
BC has its own workflow |
|
WRITEOFF |
|
BC uses Payment
Tolerances, set at the module, not the vendor |
|
XPDTOBLG |
|
|
This table shows the Business Central vendor 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 23 |
|
GP to BC VENDOR Field
Mapping Notes |
|
Field |
|
**UN-Mapped Fields |
|
Allow Multiple Posting
Groups |
|
GL Posting Configuration |
|
Amt. Rcd.
Not Invoiced |
|
BC auto-summary field |
|
Amt. Rcd.
Not Invoiced ($) |
|
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 |
|
Vendor-specific calendar |
|
Block Payment Tolerance |
|
BC vendor config option |
|
Budgeted Amount |
|
|
|
Buy-from No. Of Archived
Doc. |
|
BC auto-summary field |
|
Cash Flow Payment Terms
Code |
|
BC Cash Flow Forecasting
module config |
|
Check Date Format |
|
BC format option |
|
Check Date Separator |
|
BC format option |
|
Comment |
|
Text field |
|
Company Size Code |
|
BC vendor payment
reporting |
|
Contact |
|
BC uses Contact Cards on
vendors (table 5050, page 5050) |
|
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 |
|
Creditor No. |
|
External vendor number
or reference |
|
CURP No. |
|
BC Electronic Document
config (European) |
|
Currency Id |
|
System-generated |
|
Customergroup Code |
|
|
|
Debit Amount |
|
BC auto-summary field |
|
Debit Amount ($) |
|
BC auto-summary field |
|
Department Code |
|
BC Global dimension |
|
DIOT Type of Operation |
|
BC Foreign Tax config
for vendor |
|
Disable Search by Name |
|
|
|
Document Sending Profile |
|
BC vendor config option |
|
Email |
|
This resides on the
Internet Information window in GP (SY01200) |
|
E-Mail For IRS |
|
1099 vendor config
option |
|
EORI Number |
|
BC Foreign Tax config
for vendor |
|
Exclude from Payment
Practices |
|
BC vendor payment
reporting |
|
FATCA filing requirement |
|
BC Foreign Tax config
for vendor |
|
FATCA Requirement |
|
BC Foreign Tax config
for vendor |
|
Fin. Charge Memo Amounts
($) |
|
BC auto-summary field |
|
Fin. Charge Terms Code |
|
Not sure why BC has this
in the table? |
|
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 Disc. Code |
|
BC Vendor Discounts
config option |
|
IRS 1099 Code |
|
Does not map directly;
difference in classification of form and field |
|
IRS 1099 Form Box No. |
|
1099 vendor config
option |
|
IRS 1099 Form No. |
|
1099 vendor config
option |
|
IRS Reporting Period |
|
1099 vendor config
option |
|
Language Code |
|
Vendor-specific language
config option |
|
Last Date Modified |
|
System-generated |
|
Last Modified Date Time |
|
System-generated |
|
Lead Time Calculation |
|
|
|
Location Code |
|
Receipt
warehouse/location for the vendor |
|
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 Blanket Orders |
|
BC auto-summary field |
|
No. of Credit Memos |
|
BC auto-summary field |
|
No. of Incoming
Documents |
|
BC auto-summary field |
|
No. of Invoices |
|
BC auto-summary field |
|
No. of Order Addresses |
|
BC auto-summary field |
|
No. of Orders |
|
BC auto-summary field |
|
No. of Pstd. Cr. Memos |
|
BC auto-summary field |
|
No. of Pstd. Credit Memos |
|
BC auto-summary field |
|
No. of Pstd. Invoices |
|
BC auto-summary field |
|
No. of Pstd. Receipts |
|
BC auto-summary field |
|
No. of Pstd. Return S. |
|
BC auto-summary field |
|
No. of Pstd. Return Shipments |
|
BC auto-summary field |
|
No. of Quotes |
|
BC auto-summary field |
|
No. of Return Orders |
|
BC auto-summary field |
|
No. Series |
|
System-generated |
|
Other Amounts |
|
BC auto-summary field |
|
Other Amounts ($) |
|
BC auto-summary field |
|
Outstanding Invoices |
|
BC auto-summary field |
|
Outstanding Invoices ($) |
|
BC auto-summary field |
|
Outstanding Orders |
|
BC auto-summary field |
|
Outstanding Orders ($) |
|
BC auto-summary field |
|
Over-Receipt Code |
|
BC vendor config option |
|
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 |
|
Pay-to No. Of Archived Doc. |
|
BC auto-summary field |
|
Pay-to No. of Blanket
Orders |
|
BC auto-summary field |
|
Pay-to No. of Credit
Memos |
|
BC auto-summary field |
|
Pay-to No. of Invoices |
|
BC auto-summary field |
|
Pay-to No. of Orders |
|
BC auto-summary field |
|
Pay-to No. of Pstd. Invoices |
|
BC auto-summary field |
|
Pay-to No. of Pstd. Receipts |
|
BC auto-summary field |
|
Pay-to No. of Quotes |
|
BC auto-summary field |
|
Pay-to No. of Return
Orders |
|
BC auto-summary field |
|
Pmt. Disc. Tolerance ($) |
|
BC auto-summary field |
|
Pmt. Discounts ($) |
|
BC auto-summary field |
|
Pmt. Tolerance ($) |
|
BC auto-summary field |
|
Preferred Bank Account
Code |
|
Vendor-preferred bank
(not GP Checkbook ID) |
|
Prepayment % |
|
BC Vendor 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
vendors (table 5050, page 5050) |
|
Privacy Blocked |
|
BC feature limits access
to the Vendor |
|
Purchaser Code |
|
BC uses a shared
Salesperson/Purchaser card (table 13, page 5116) |
|
Purchases ($) |
|
BC auto-summary field |
|
Receive E-Document To |
|
Purchase Invoice,
Purchase Order |
|
Receiving 1099 E-Form
Consent |
|
1099 vendor config
option |
|
Refunds |
|
BC auto-summary field |
|
Refunds ($) |
|
BC auto-summary field |
|
Registration No. |
|
Tax registration |
|
Reminder Amounts |
|
BC auto-summary field |
|
Reminder Amounts ($) |
|
BC auto-summary field |
|
Responsibility Center |
|
BC labeling and grouping
option |
|
RFC No. |
|
BC Electronic Document
config (European) |
|
RowVersion |
|
System-generated |
|
Shipping Agent Code |
|
Shipping company for
vendor products |
|
State Inscription |
|
BC Electronic Document
config (European) |
|
Statistics Group |
|
|
|
System ID |
|
System-generated |
|
Tax Area Code |
|
BC Tax Config |
|
Tax Liable |
|
BC Tax Config |
|
Telex Answer Back |
|
BC Vendor banking config
option |
|
Telex No. |
|
BC Vendor banking config
option |
|
Territory Code |
|
BC picklist for
assigning to Contacts (table 286, page 429) |
|
Validate EU VAT Reg. No. |
|
System-generated |
|
VAT Bus. Posting Group |
|
GL Posting Configuration |
|
Vendor 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!