Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Upgrading tables for EFT for Payables Management and EFT for Receivables Management between versions of Microsoft Dynamics GP

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

View products that this article applies to.

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.

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

Keywords: kbmbspartner, kbexpertiseinter, kbhowto, kbinfo, kbmbsmigrate, kbexpertisebeginner, kb

↑ Back to the top

Article Info
Article ID : 944889
Revision : 1
Created on : 3/3/2017
Published on : 7/5/2013
Exists online : False
Views : 227