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

Applies to: Dynamics GP 2013Dynamics GP 2010

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 this, the EFT tables for Payables Management were completely restructured. Some EFT tables for Receivables Management were merged with the Microsoft Dynamics GP core dictionary. However, the processing is still performed 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

DictionaryTable nameTable in Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions - Great Plains 8.0DatabaseConversion information for Microsoft Dynamics GP 10.0, GP 2010 and GP 2013
CorecmCheckbookEFTME27605, ME147204, and ME147215CompanyCM00101
CorecmEFTOptionalHeaderME147204CompanyCM00102
CorecmTransactionEFTBatchME234603CompanyCM20203
CorecmEFTLogME234604CompanyCM90001
CoreAddressEFTME27606 and ME147214CompanySY06000
CoreVAT Country Code MSTRME27622CompanyVAT10001

EFT for Payables Management

DictionaryTable nameTable in Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions - Great Plains 8.0DatabaseConversion information for Microsoft Dynamics GP 10.0, GP 2010 and GP 2013
CoreME_Direct_Deposit_SETPME27605CompanyCM00101
CoreME_Direct_Deposit_MSTRME27606CompanySY06000
CoreME_EFT_CountriesME27622SystemVAT10001
CoreME_EFT_Log_DTLME234602CompanyUpdated PM Elec flag in PM20000 and in PM30200
CoreME_EFT_Log_HDRME234603CompanyCM20203
CoreME_EFT_Log_SentME234604CompanyCM90001

EFT for Receivables Management

DictionaryTable nameTable in Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions - Great Plains 8.0DatabaseConversion information for Microsoft Dynamics GP 10.0, GP 2010 and GP 2013
CoreME_EFT_SETPME147204CompanyCM00101 and CM00102
CoreME_RM_EFT_MSTRME147214CompanySY06000
CoreME_RM_EFT_SETPME147215CompanyCM00101
CoreME_EFT_CountriesME27622SystemVAT10001
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.