Open Forum

Expand all | Collapse all

#Payroll posting accounts

  • 1.  #Payroll posting accounts

    Posted 23 days ago
    ​We have added to new pay codes.  We have over 50 departments so I need to add a new payroll posting account for each department combination.  Is there any way to do a table import from excel rather than add them one at a time manually?  I am fairly comfortable with SQL if anyone has a script.

    We have created a couple of new payroll codes.  Because we have over 50 departments, this will require mapping about 100 lines of payroll posting accounts.  I don't think there is any way to import from an excel file, am I wrong?  I am fairly comfortable with SQL is anyone has a script.

    Lisa Saumure
    Bermuda Press (Holdings) Limited

  • 2.  RE: #Payroll posting accounts

    Posted 21 days ago
    Hi @Lisa Saumure

    If you get a chance talk to Heartland Business Systems, they have a Payroll Posting Accounts product that is phenomenal for handling this type of situation.​

    Get in touch with @Carol Kossoris or @Al Schuette.

    I've seen their product in action and it could help you out a lot.



  • 3.  RE: #Payroll posting accounts

    Posted 17 days ago
      |   view attached
    @Lisa Saumure:

    I was so excited to hear about the new payroll posting accounts edits/additions feature with GP2016R2 until I found out you have to export all of your payroll posting accounts to Excel, make changes/additions, then import all of them back into GP. We have over 25,000 payroll posting accounts, which takes well over an hour to download. So, I am still adding them manually because ​the export also slows down GP functionality.

    I have attached the feature information that I downloaded from MS. I hope you are able to use it. 8-)


    Joni Finnell
    GP Projects/Troubleshooter
    Consumer Support Services, Inc.
    Newark OH


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