Edit

Upgrading tables for EFT for Payables Management and EFT for Receivables Management between versions of Microsoft Dynamics GP

  • Article

This article provides a solution to an issue where the table structure for Electronic Funds Transfer (EFT) for Payables Management and EFT for Receivables Management was redesigned.

Applies to:   Microsoft Dynamics GP 2013
Original KB number:   944889

Symptoms

The table structure for Electronic Funds Transfer (EFT) for Payables Management and EFT for Receivables Management was redesigned between Microsoft Dynamics GP 9.0 and Microsoft Dynamics GP 10.0. This article describes the table mapping changes between these versions.

Cause

In Microsoft Dynamics GP 10.0, the EFT for Payables Management program code was merged with the Microsoft Dynamics GP core dictionary. Because of it, the EFT tables for Payables Management were restructured. Some EFT tables for Receivables Management were merged with the Microsoft Dynamics GP core dictionary. However, the processing is still done in the EFT for Receivables Management dictionary in Microsoft Dynamics GP 10.0 but was moved to the GP core dictionary in Microsoft Dynamics GP 2010.

Resolution

The following tables list the EFT for Payables Management table mapping and the EFT for Receivables Management table mapping.

Financials

Dictionary Table name Table in Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions - Great Plains 8.0 Database Conversion information for Microsoft Dynamics GP 10.0, GP 2010, and GP 2013
Core cmCheckbookEFT ME27605, ME147204, and ME147215 Company CM00101
Core cmEFTOptionalHeader ME147204 Company CM00102
Core cmTransactionEFTBatch ME234603 Company CM20203
Core cmEFTLog ME234604 Company CM90001
Core AddressEFT ME27606 and ME147214 Company SY06000
Core VAT Country Code MSTR ME27622 Company VAT10001

EFT for Payables Management

Dictionary Table name Table in Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions - Great Plains 8.0 Database Conversion information for Microsoft Dynamics GP 10.0, GP 2010, and GP 2013
Core ME_Direct_Deposit_SETP ME27605 Company CM00101
Core ME_Direct_Deposit_MSTR ME27606 Company SY06000
Core ME_EFT_Countries ME27622 System VAT10001
Core ME_EFT_Log_DTL ME234602 Company Updated PM Elec flag in PM20000 and in PM30200
Core ME_EFT_Log_HDR ME234603 Company CM20203
Core ME_EFT_Log_Sent ME234604 Company CM90001

EFT for Receivables Management

Dictionary Table name Table in Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions - Great Plains 8.0 Database Conversion information for Microsoft Dynamics GP 10.0, GP 2010, and GP 2013
Core ME_EFT_SETP ME147204 Company CM00101 and CM00102
Core ME_RM_EFT_MSTR ME147214 Company SY06000
Core ME_RM_EFT_SETP ME147215 Company CM00101
Core ME_EFT_Countries ME27622 System VAT10001

Note

The table mapping only displays EFT tables that were converted between versions. Any additional EFT tables for Microsoft Dynamics GP 9.0 and earlier versions that are not listed in these table mapping were not converted.