KB - The ADP import process in Payroll Connect and the specific fields that are required for Microsoft Dynamics GP

Payroll Connect is installed in the Microsoft Dynamics GP installation process. Payroll Connect does not require a separate installation process. You must enter Payroll Connect registration keys. Additionally, you must click to select the Payroll Connect check box in the Registration window.

Before you use the Import From ADP window, work with your ADP representative to complete the following tasks:

• Obtain the correct file structure for the import file.
• In the ADP product, set up the same account framework as in Microsoft Dynamics GP.
• The format used in the ADP tool must contain 10 fields. Even though all 10 fields are not used by GP, they must still exist.
• The file should be comma delimited and have a .gli suffix or .csv suffix.
• Each field should have quotes around it. Open the file with Notepad to confirm.
• Each field should not be mapped wider than the maximum width allowed for each field in GP. See the Maximum Widths defined for each field at the end of the article below. (Note that the Description field in field 7 is shorter than the allowable length defined in Microsoft Dynamics GP.)
• All ten fields must exist in the file. The fields not used by GP can be blank or have a fixed value, but must still exist in the file.
• In the GL Batch Entry window, the 'number of Journal Entries' displayed for the ADP batch will actually display the 'number of lines' from the ADP file, so this can be misleading. However, if you drill into the transaction detail, it is comprised of only one journal entry and does post correctly as one journal entry. Since this is only a display issue and does post correctly, this issue will not be changed at this time. However, if you wish to correct it, you can click on Tools under Microsoft Dynamics GP, point to Utilities, point to Financial, click on Reconcile, select Batches and click Reconcile. This reconcile process will update the Number of Journal Entries in this batch to be correct. The user can add this to their documentation or part of their processes after they bring in an ADP file. This has been written up as a product suggestion, so please vote on this request using the link below if you would like to see this as a future enhancement:
  
  https://connect.microsoft.com/dynamicssuggestions/feedback/details/915984/gp-the-number-of-journal-entries-is-incorrect-on-a-file-imported-in-using-adp-payroll-connect

The following table describes the 10 fields needed in the ADP Payroll Connect import file: 

The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.


Here is a more detailed description of how to map each field listed above in the ADP tool:

Field 1 - Client Code - Map to Fixed value or leave blank.  Max width: 5. 
Field 2 - GL account - Map to GL account. Do not use dashes, spaces or commas. Can set to width of your GL account. Max width: 24.
Field 3 - Journal Source Code - Map to fixed value of 'GJ'. Max width: 2.
Field 4 - Date - Map to Issue date. Can use MMDDY or MMDDYYYY. GP does not use this date. Max width: 5.
Field 5 - Amount - Map to Amount. Do not use dollar signs or commas. Set to 2 decimals. Max width: 13.
Field 6 - Ref 1 - Map to fixed value of blank. No filler. Max width: 6.
Field 7 - Description - Map to Description. Max width: 20. This field does not truncate, so cannot be greater than 20. 
Field 8 - Ref 2 - Map to fixed value of blank. No filler. Max width: 6.
Field 9 - Ref 3 - Map to fixed value of blank. No filler. Max width: 6.
Field 10 - Record Code - Map to fixed value of '02'. Max width: 2.


When you open the ADP file in Notepad, all 10 fields must exist and it should look similar to this example:
---------------------------------------------------------------------------------
"","0000001028","GJ","07051","45102.10","","DESCRIPTION","","","02"
"","0000001028","GJ","07051","-2696.34","","DESCRIPTION","","","02"
"","0000001028","GJ","07051","-630.59","","DESCRIPTION","","","02"
---------------------------------------------------------------------------------


TROUBLESHOOTING:
Specific lines in the ADP file will be skipped if the Description in field 7 is longer than 20 characters. Even though this field allows 30 characters in Microsoft Dynamics GP, it cannot be longer than 20 characters in the file being imported as specified in the field widths above. 

The below error can happen for various reasons, but one reason is that the date format in your import file is not MMDDY or MMDDYYYY format.  Make sure leading zeroes are not missing from the MM or DD. 

"The selected import file is not a valid ADP export file."