GP to BC Compare: Vendor 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 VENDOR BANKING 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 banking records between Dynamics GP and Business Central.

Business Central

 

Dynamics GP

 

The Dynamics Mindset

Table 288

 

Table SY06000

 

GP to BC VENDOR EFT Field Mapping Notes

Field

Field Length

 

Field

Field Length

 

**Filtered and Mapped Fields

Code

Code 20

 

ADRSCODE

15

 

 

Vendor No.

Code 20

 

VENDORID

15

 

 

Name

Text 100

 

BANKNAME

30

 

 

Bank Account No.

Text 30

 

EFTBankAcct

35

 

BC is 5 char less than GP

Bank Branch No.

Text 20

 

EFTBankBranch

15

 

 

Bank Code

Code 3

 

EFTBankCode

15

 

BC is 12 char less than GP

IBAN

Code 50

 

IntlBankAcctNum

35

 

 

SWIFT Code

Code 20

 

SWIFTADDR

11

 

 

Country/Region Code

Code 10

 

CustVendCountryCode

3

 

 

Address

Text 100

 

ADDRESS1

60

 

 

Address 2

Text 50

 

ADDRESS2

60

 

BC is 10 char less than GP

Transit No.

Text 20

 

EFTTransitRoutingNo

11

 

 

Currency Code

Code 10

 

CURNCYID

15

 

Do not assign currency in BC unless not functional

 

This table shows the Dynamics GP vendor banking 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 SY06000

 

GP to BC VENDOR EFT Field Mapping Notes

Field

 

**UN-Mapped Fields

ADDRESS3

 

 

ADDRESS4

 

 

BankInfo7

 

 

BNKCTRCD

 

 

BSROLLNO

 

 

CBANKCD

 

 

CUSTNMBR

 

GP table also used for customers

CustomerVendor_ID

 

 

DeliveryCountryCode

 

 

DEX_ROW_ID

 

System-generated

EFTAccountType

 

 

EFTBankBranchCode

 

 

EFTBankCheckDigit

 

 

EFTBankType

 

 

EFTPrenoteDate

 

 

EFTTerminationDate

 

 

EFTTransferMethod

 

 

EFTUseMasterID

 

 

FRGNBANK

 

 

GIROPostType

 

 

INACTIVE

 

 

RegCode1

 

 

RegCode2

 

 

SERIES

 

 

 

This table shows the Business Central vendor banking 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 288

GP to BC VENDOR EFT Field Mapping Notes

Field

**UN-Mapped Fields

Bank Clearing Code

 

Bank Clearing Standard

 

City

 

Contact

 

Created At

System-generated

Created By

System-generated

Email

 

Fax No.

 

Home Page

 

Language Code

 

Modified At

System-generated

Modified By

System-generated

Name 2

 

Phone No.

 

RowVersion

System-generated

State

 

System ID

System-generated

Telex Answer Back

 

Telex No.

 

Use for Electronic Payments

 

ZIP Code

BC has optional Post Code (table 225, page 367)

 

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!