Topics > DataPlus Microsoft Accounting Integration > DataPlus 4.0, 3.0 Microsoft Dynamics GP > FAQ ID # 47

FAQ ID # 47
Last Update : 2013/08/21
Print this FAQ

Question / Issue
DataPlus 4.0, 3.0 MDGP Push Configuration

Answer / Solution
PROGRAM: DataPlus for Microsoft Dynamics GP - Contact Push Configuration
DataPlus Push Configuration
Contact ID Configuration

    SQL dpTABLE: [mdgp].[mdgpConfig]
  1. Setting = eConnect Field
  2. Value = ACT! Field
  3. Value also defines field configuration for creating format
Setting Value Comment
ACTCUSTNMBRFIELD Customer Number Max 15 Characters
ACTCUSTOMERGPIDFIELD eCustomerID Max 15 Characters
ACTEMPLNMBRFIELD Employee Number Max 15 Characters
ACTEMPLOYEEGPIDFIELD eEmployeeID Max 15 Characters
ACTVENDNMBRFIELD Vendor Number Max 15 Characters
ACTVENDORGPIDFIELD eVendorID Max 15 Characters
CUSTIDFIELDREQ CUSTNAME Do not edit
CUSTIDFORMAT dp{CUSTNAME,10} Max 15 Characters
EMPLOYIDFIELDREQ FRSTNAME,LASTNAME  
EMPLOYIDFORMAT dp{LASTNAME,6}{FRSTNAME,5} Max 15 Characters
VENDORIDFIELDREQ VENDNAME  
VENDORIDFORMAT dp{VENDNAME,10} Max 15 Characters

  Note: Max Characters + leading numbers
    When the Contact ID is created, there cannot be duplicates. So in the push, extended numbers are added to the suffix of the field.
Contact ID Configuration Formating

    SQL dpTABLE: [mdgp].[mdgpConfig]
  1. Edit value fields
Setting Value Characters Extended Number
CUSTIDFORMAT dp{CUSTNAME,10} dp(2 char) + CUSTNAME(10 CHAR) = 10 5 (e.g.: 00105)
EMPLOYIDFORMAT dp{LASTNAME,6}{FRSTNAME,5} dp(2 char) + LASTNAME(6 char) + FRSTNAME(5 char) = 13 2 (e.g.: 12)
VENDORIDFORMAT dp{VENDNAME,10} dp(2 char) + VENDNAME(10 CHAR) = 10 5 (e.g.: 00032)

  Note: It is very important NOT to use all 15 characters in the field.
    There has to be a minimum of 2 leading characters available for extended numbers to prevent duplication.
Contact Mapping

    SQL dpTABLE: [mdgp].[mdgpMapping]
  1. Edit mdgpm_ActField fields
  2. Edit mdgpm_Text

Note: We don't recommend modifying these fields.
mdgpm_id mdgpm_Entity mdgpm_ActField mdgpm_eConnectParam mdgpm_Text mdgpm_Order mdgpm_ReadOnly
1 Vendor Company VENDNAME Vendor Name 100 1
2 Vendor Contact VNDCNTCT Contact 101 1
3 Vendor Address 1 ADDRESS1 Address 1 200 1
4 Vendor Address 2 ADDRESS2 Address 2 201 1
5 Vendor City CITY City 203 1
6 Vendor State STATE State 204 1
7 Vendor Zip Code ZIPCODE Zip Code 205 1
8 Vendor Country COUNTRY Country 206 1
9 Customer Company CUSTNAME Customer Name 100 1
10 Customer Contact CNTCPRSN Contact 101 1
11 Customer Address 1 ADDRESS1 Address 1 200 1
12 Customer Address 2 ADDRESS2 Address 2 201 1
13 Customer City CITY City 203 1
14 Customer State STATE State 204 1
15 Customer Zip Code ZIPCODE Zip Code 205 1
16 Customer Country COUNTRY Country 206 1
17 Employee Address 1 ADDRESS1 Address 1 200 1
18 Employee Address 2 ADDRESS2 Address 2 201 1
19 Employee City CITY City 203 1
20 Employee State STATE State 204 1
21 Employee Zip Code ZIPCODE Zip Code 205 1
22 Employee Country COUNTRY Country 206 1
23 Employee Phone,Extension PHONE1 Phone 245 1
24 Employee Middle Name MIDLNAME Middle Name 101 1
25 Employee Alternate Phone PHONE2 Phone 2 246 1
26 Employee Department DEPRTMNT Department 121 1
27 Employee Title JOBTITLE Job Title 122 0
28 Employee Gender GENDER Gender 123 0
29 Vendor Vendor Account ACNMVNDR Vendor Account 102 1
30 Vendor Shipping Method SHIPMTHD Shipping Method 255 0
31 Vendor Phone,Extension PHNUMBR1 Phone 1 245 1
32 Vendor Alternate Phone PHNUMBR2 Phone 2 246 1
33 Vendor Fax Phone FAXNUMBR Fax 248 1
34 Customer Phone,Extension PHNUMBR1 Phone 1 245 1
35 Customer Alternate Phone PHNUMBR2 Phone 2 246 1
36 Customer Fax Phone FAX Fax 248 1
37 Customer Corporate Customer Number PARENTID Parent Customer ID 110 0
38 Employee Last Name LASTNAME Last Name 102 1
39 Employee First Name FRSTNAME First Name 100 1
40 Customer Address 3 ADDRESS3 Address 3 202 1
41 Employee Address 3 ADDRESS3 Address 3 202 1
42 Employee Emp Social Security Number SOCSCNUM SSN 250 0
43 Vendor Address 3 ADDRESS3 Address 3 202 1
45 Customer Phone 3 Phone PHNUMBR3 Phone 3 247 1
48 Vendor Phone 3 Phone PHNUMBR3 Phone 3 247 1

Related FAQs
DataPlus 4.0, 3.0 MDGP Push
DataPlus 4.0, 3.0 MDGP Push Debug

Direct Link to This FAQ
http://kb.hogandata.com/?f=47

Back to Top