web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / ADP Upload Integration...
Finance | Project Operations, Human Resources, ...
Suggested Answer

ADP Upload Integration - additional fields (GP 2018)

(1) ShareShare
ReportReport
Posted on by clloyd27 5

Hello, 

I'm wondering if there's an option to either:

add a field to an ADP CSV file to display in a Smartlist

OR

map/choose the correct Smartlist column to display the field I'd like displayed.

Below is a snippet of the CSV upload I am testing. I would like the Smartlist extract to display either column A (AZP) or column F

pastedimage1677858937909v2.png

These are the columns in the Smartlist associated with the upload:

A:  ?

B: Account Number

C: Journal

D: Trx Date

E: Amount

F: ?

G: Distribution Reference

Below are all of my options in the Smartlist columns. I've exhausted each one, and none display column A or column F from my upload. How can I achieve this? Any help is greatly appreciated! I'm using GP 2018. 

pastedimage1677859473279v3.png

pastedimage1677859495327v4.png

pastedimage1677859507799v5.png

pastedimage1677859523549v6.png

pastedimage1677859539470v7.png

pastedimage1677859556427v8.png

pastedimage1677859570452v9.png

pastedimage1677859588578v10.png

pastedimage1677859603675v11.png

pastedimage1677859617929v12.png

pastedimage1677859631755v13.png

pastedimage1677859643465v14.png

pastedimage1677859655554v15.png

pastedimage1677859672145v16.png

pastedimage1677859686233v17.png

pastedimage1677859701313v18.png

pastedimage1677859726082v19.png

pastedimage1677859739256v20.png

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 11,397 on at

    hi

    To add a field from an ADP CSV file to display in a SmartList, you would need to make sure that the field is mapped to a corresponding field in Dynamics GP. Here are the steps to do this:

    Go to Microsoft Dynamics GP > Tools > Setup > System > ADP Import.

    Select the Import File Mapping button.

    Select the CSV file you want to map, and select the Edit button.

    You will see a list of fields from the CSV file. Select the field you want to map, and then select the corresponding Dynamics GP field from the drop-down list.

    Save the mapping and import the file into Dynamics GP.

    Go to SmartList and select the SmartList you want to add the field to.

    Select the Columns button and select Add.

    Select the field you mapped from the drop-down list.

    Save the SmartList and run it to display the new field.

    If you are unable to map the desired field to a corresponding Dynamics GP field, you can create a SQL view that joins the ADP table and the GP table to include the desired field. Once you have created the SQL view, you can add it as a table to the SmartList and select the desired field to display.

    DAniele

  • Lisa at AonC.com Profile Picture
    Lisa at AonC.com 919 Super User 2025 Season 2 on at

    DAnny3211 - My understanding is the ADP import is a hard-coded import.  I do not see the window you reference in GP 18.5.  Our clients primarily use TitaniumGP or Integration Manager for custom imports.

    clloyd27 - Here is the import information from Help:

    When you use Payroll Connect with General Ledger, you must use a comma-delimited ASCII text file in comma-separated values (CSV) format, as follows:

    Column

    Maximum size

    Client Code

    5

    General Ledger Account Number

    24

    Journal Source Code

    2

    Date (format is MMDDYYYY)

    8

    Amount (Negative numbers (credit amounts) are preceded by a ‘-’. Contains an explicit decimal point.)

    13

    Reference number 1

    6

    Description

    20

    Reference number 2

    6

    Reference number 3

    6

    Record Code

    2

    The following is a sample ADP file showing the correct format:

    "QC911","208015","PR","04302007","33222.11","","GROSS","","","02"
"QC911","208003","PR","04302007","-2696.34","","ER SOCIAL SECURITY","","","02"
"QC911","208004","PR","04302007","-630.59","","ER MEDICARE","","","02"
"QC911","208005","PR","04302007","-2696.34","","EE SOCIAL SECURITY","","","02"
"QC911","208006","PR","04302007","-630.59","","EE MEDICARE","","","02"
"QC911","208010","PR","04302007","-29051.95","","NET PAY","","","02"
"QC911","208011","PR","04302007","-8590.10","","EE FEDERAL TAX","","","02"
"QC911","208012","PR","04302007","-348.07","","FUTA TAX","","","02"
"QC911","208013","PR","04302007","-59.63","","EE SUI TAX","","","02"
"QC911","208106","PR","04302007","-398.49","","MEALS","","","02"
"QC911","","PR","04302007","1612.60","","","","","02"
"QC911","ABCDEFGHIJKL","PR","04302007","-999999999.99","","TEST LINE","","","02"

    Once the batch is imported and you select the imported Journal Entry in General Ledger Transaction Entry, the source document and reference depend on how you imported the transactions. If you create a batch for the import, the source document will be GJ and the reference will be Payroll Connect. If you add the ADP transactions to an existing batch, the source document will be whatever was originally assigned to the batch. In either case, the currency ID will be the functional currency from the Multicurrency Setup window.

    Account, debit, and credit fields are imported. If the number of characters in the imported data is greater than the General Ledger field allows, the information will be truncated. For example, if your General Ledger account numbers have 15 digits, and ADP account numbers have 24 digits, the additional numbers from the ADP file are truncated as shown in the following table.

    General Ledger account number

    Value

    ADP

    “255354249990001249786758”

    General Ledger

    “255354249990001”

    The debit and credit decimal settings will be set by the currency ID. If the ADP file contains more decimal places than the currency ID, the amounts will be rounded.

    The distribution reference will be the description from the ADP file.

  • clloyd27 Profile Picture
    clloyd27 5 on at

    Hi - I do not have the ADP Import option - is there an alternative?

    Go to Microsoft Dynamics GP > Tools > Setup > System > ADP Import.

  • clloyd27 Profile Picture
    clloyd27 5 on at

    Hi - I do not have the ADP Import option - is there an alternative?

    Microsoft Dynamics GP > Tools > Setup > System > ADP Import.

  • clloyd27 Profile Picture
    clloyd27 5 on at

    This does not answer my question. I'm aware of the upload process and its formatting, I'm asking if there is a way to add a field for the upload and display in a Smartlist.

  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 919 Super User 2025 Season 2 on at

    I tried to answer the question about ADP with the information from Help regarding the required format.  My understanding is the answer is NO you cannot add a field to the pre-defined format.  (I don't think we have any of our GP clients - including those with ADP - using this pre-defined tool because they either don't have their GL mappings in ADP or are using a more flexible import tool.  My personal preference is Copy/Paste from TitaniumGP.com.)

    You can definitely add related columns to SmartList (either through the standard SmartLists or a custom SmartList Designer object, depending on what you are trying to add).

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 660 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 549 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 307 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans