Open Forum

Expand all | Collapse all

#Import payroll hours to GP from CSV file using Smart Connect

  • 1.  #Import payroll hours to GP from CSV file using Smart Connect

    Posted 9 days ago
    We have started using a time and attendance system to gather employee hours.  The system produces a report showing the employee hours for a pay period.  Is it possible to create a map in Smart Connect to import the hours into GP payroll?  The file contains the employee ID, number of hours for the pay period and the paycode (which matches the GP paycode).

    ------------------------------
    Lisa Saumure
    Bermuda Press (Holdings) Limited
    Hamilton
    ------------------------------


  • 2.  RE: #Import payroll hours to GP from CSV file using Smart Connect

    TOP CONTRIBUTOR
    Posted 9 days ago
    @Lisa Saumure


    It is definitely possible

    ------------------------------
    Jo deRuiter, MCP, DCP
    "That GP Red Head"
    AISLING DYNAMICS CONSULTING, LLC
    WEBSITE: https://aislingdynamics.com/
    BLOG: https://community.dynamics.com/gp/b/gplife
    770-906-4504 (Cell)

    ------------------------------



  • 3.  RE: #Import payroll hours to GP from CSV file using Smart Connect

    GOLD CONTRIBUTOR
    Posted 8 days ago
    You can easily create a smartconnect integration by posting to the transaction work table.  Here is link to what the econnect (and Smartconnect) can import into.

    https://www.eonesolutions.com/tech-tuesday-what-data-can-smartconnect-integrate-in-dynamics-gp/

    You may also use something easier.  That is, using the import from ADP menu item found under Administration - routines - Import from ADP.  It is just a text file import using a CSV file.  Below are the instructions from GP help on what you need along with a sample csv file.

    Payroll Connect overview
    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.

    ------------------------------
    Michael Taranto, CPA
    President
    ERP Consulting, LLC
    pataskala OH
    740-951-0220 mtaranto@erpconsultingLLC.com
    erpconsultingllc.com
    ------------------------------



  • 4.  RE: #Import payroll hours to GP from CSV file using Smart Connect

    Posted 8 days ago
    Thanks for that info.  The data is not coming from ADP.  We actually do our payroll in GP.  We are simply wanting to import the number of hours to pay into GP from a CSV file generated from the time keeping system.

    ------------------------------
    Lisa Saumure
    Bermuda Press (Holdings) Limited
    Hamilton
    ------------------------------



  • 5.  RE: #Import payroll hours to GP from CSV file using Smart Connect

    GOLD CONTRIBUTOR
    Posted 8 days ago

    Its just an import tool for csv files.  Not think about the name of it.  I use it with paychex, Paylocity and other timeclock softwares.

     






  • 6.  RE: #Import payroll hours to GP from CSV file using Smart Connect

    SILVER CONTRIBUTOR
    Posted 7 days ago
    ​​you would need to map to these two econnect nodes in SmartConnect. I've done it many times.
    Payroll Nodes

    ------------------------------
    Donny Kensmoe
    Senior Consultant
    Wipfli
    Green Bay WI
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role