Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Payroll Posting Accoun...
Finance | Project Operations, Human Resources, ...
Unanswered

Payroll Posting Account Setup Problem

(0) ShareShare
ReportReport
Posted on by klm2 5

I am having a problem with the payroll posting account setup.   When I choose the option for the Employer Tax expense, I do not get any options for the type lookup.   I get the Department and Position lookup's but not the Expense Type lookup.   It shows 2 rows, for the FICA matching taxes but I can't enter any other options for those taxes.   I need to setup the expense account for each position as a different account but if I try to even type in the tax type (exactly the same as it is on the top two rows), I get an error message that it is invalid.   I also can not type in FUTA or SUTA without getting an error message.   

This only happens in one of the 2 companies that we have.  The other company gives me a lookup list of Tax Expense Types.   That leads me to believe that the problem is in the data for that company, not the software itself.

I have tried to run the check links for all Payroll, Company, and System files but that did not work.   I tried to run the FUTA and SUTA reports to see if that would cause them to show up in a lookup list.   None of these items have fixed the problem.

Does anyone have any suggestions?   

My next thought would be to copy the payroll account setup files from the company that is working and then I will have to delete all of the accounts and resetup the accounts for the new company (that is not working).

I would appreciate any ideas!

Karen Musick

Categories:
Microsoft Dynamics GP
  • klm2 Profile Picture
    klm2 5 on at
    RE: Payroll Posting Account Setup Problem

    Yes, the message above worked for me.   See the message from Brandon.

  • smith68574 Profile Picture
    smith68574 20 on at
    RE: Payroll Posting Account Setup Problem

    did you manage to solve your problem because I have the same problem

    www.emorypatientportal.net/

  • klm2 Profile Picture
    klm2 5 on at
    RE: Payroll Posting Account Setup Problem

    Thank you Brandon, that worked!   We are fixed and progressing forward!  

    Thanks so much for this information!

  • Hokuminaria Profile Picture
    Hokuminaria 2,950 on at
    RE: Payroll Posting Account Setup Problem

    Hey klm2,

    This is an odd one. There is no actual window that you can set these up. These come with the install.

    What I would start with is comparing the bad company and good companies UPR40501 table. I believe this is where those are coming from. My guess is this table will be empty for the bad company.

    If this table is empty, you can try to insert these. The insert statements below are provided to you AS-IS so be sure you test this and have restorable backups as this is not supported.

    insert into UPR40501
    VALUES (0,'FIC/ME','FICA/Medicare Tax Expense')

    insert into UPR40501
    VALUES (0,'FIC/SE','FICA/Soc. Sec. Tax Expense')

    insert into UPR40501
    VALUES (0,'FUTA' ,'FUTA Tax Expense')

    insert into UPR40501
    VALUES (0,'SUTA' ,'SUTA Tax Expense')

    insert into UPR40501
    VALUES (1,'EFIC/M ','Employer FICA/Medicare Tax')

    insert into UPR40501
    VALUES (1,'EFIC/S','Employer FICA/Soc. Sec. Tax')

    insert into UPR40501
    VALUES (1,'FED' ,'Federal Tax Withholding')

    insert into UPR40501
    VALUES (1,'FICA/M','FICA/Medicare Tax Withholding')

    insert into UPR40501
    VALUES (1,'FICA/S ','FICA/Soc. Sec. Tax Withholding ')

    Once the insert statements have been run, see if you can now see the codes in the Payroll Posting Account window. If you still cannot see them, I would recommend a support case as there is no way to create the missing records in the front end and will take more troubleshooting to get these back.

    I hope this helps!

    Thank you!

    Brandon | Microsoft Support Engineer

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans