Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Federal Filing Status ...
Microsoft Dynamics GP (Archived)

Federal Filing Status issue on Employee Tax Maintenance.

(0) ShareShare
ReportReport
Posted on by Hetal Kapadia 575

We are currently on GP10 at the moment and we noticed a weird issue with Federal Filing Status for employees. When we pull up the filing status on Cards -> Payroll -> Tax -> Employee Tax Maintenance, it shows the status as 'Exempt'. However, when we pull the same TM on Smart List -> Payroll -> Employees -> Exempt Federal Taxes, that employee does not show up. when we pull up this specific employee based on employee id, it shows the Federal Filing Status as 'Single'. 

We did not have a clue why there was a mismatch, so we though of changing the filing status in employee file back and forth to see if that fixes it. This is when we noticed that the Federal Filing Status dropdown has a weird value. Along with Married, Single, and Exempt it had an option that said 'Message #11754 missing'. I have a feeling that we might have had 4 options for filing status before and one of them has gone missing.

We never had this issue before but just noticed it when we had difficulties pulling federal filing status data on smartlist. Has anyone encountered this issue before? Any help on getting this issue fixed will be much appreciated.

Thank you!

Hetal Kapadia

*This post is locked for comments

  • Suggested answer
    Mikki Milligan Profile Picture
    Mikki Milligan 80 on at
    Re: Federal Filing Status issue on Employee Tax Maintenance.

    We installed the tax update (TX.CAB) and most recent GP service pack (MicrosoftDynamicsGP-KB2769061-v10-ENU.exe) in our test environment and it resolved the smartlist issue that was reporting the wrong filing status.

    You will need to update GP10 with the latest service pack to fix the issue.

  • Hetal Kapadia Profile Picture
    Hetal Kapadia 575 on at
    Re: Federal Filing Status issue on Employee Tax Maintenance.

    This happened to be an issue for us when we had performed tax updates earlier this year. We dealt with it without resolution until we upgraded to GP2010 few months back.

    I am amazed to see how many queries on this community forum goes unanswered while i believe microsoft should have someone monitoring these forums to provide support on these issues.

    Anyway, to sum it up, this stayed an issue with us on GP10 since beginning of this year until we upgraded to GP2010. Wish i could help with this issue.

  • Jane Maritz Profile Picture
    Jane Maritz 70 on at
    Re: Federal Filing Status issue on Employee Tax Maintenance.

    Bumping again:  Has this issue ever been addressed?  We are running into the same problem with our SmartList report:  It shows Exempt employees as having a status of Single, and Single employees as having a Nonresident Alien status.  Status shows correctly on employee record, but not on SmartList.

  • Hetal Kapadia Profile Picture
    Hetal Kapadia 575 on at
    Re: Federal Filing Status issue on Employee Tax Maintenance.

    I apologize for not being descriptive. I was just bumping this post to the top of the list as it was dug in deep a while ago. I was just making this post being noticed by others so that if someone has any thoughts they would share with us and help us both out with this problem.

    Sorry and Thanks!

  • Mikki Milligan Profile Picture
    Mikki Milligan 80 on at
    Re: Federal Filing Status issue on Employee Tax Maintenance.

    Hetal Kapadia,

    Thank you for your response. However, Bump... does not give me enough information as to how to fix the smartlist report that incorrectly displays the wrong federal tax status of an employee.

    Could you please be more specific?

  • Hetal Kapadia Profile Picture
    Hetal Kapadia 575 on at
    Re: Federal Filing Status issue on Employee Tax Maintenance.

    Bump...

  • Mikki Milligan Profile Picture
    Mikki Milligan 80 on at
    Re: Federal Filing Status issue on Employee Tax Maintenance.

    I found these values in the message table in Dynamics:

    MSGNUM SQL_MSG

    6209 Exempt                                                                                                                                                                                                                                                        

    7460 Married                                                                                                                                                                                                                                                        

    7461 Single                                                                                                                                                                                                                                                        

    11754  

    Nonresident Alien                                                                                                                                                                                                            However, even with the values in the message table the smartlist incorrectly displays the federal tax status of employees.

    Mikki                                  

  • Hetal Kapadia Profile Picture
    Hetal Kapadia 575 on at
    Re: Federal Filing Status issue on Employee Tax Maintenance.

    On an additional note, i do see Message #11754 as 'Nonresident Alien' in DYNAMICS..MESSAGES table but for some reason it does not link up to company databases and that value shows up as 'Message #11754 missing'. If i can find a way to display the actual value instead of this missing message, it will be all good for us. Hopefully someone can help out.

    Thanks!

  • Mikki Milligan Profile Picture
    Mikki Milligan 80 on at
    Re: Federal Filing Status issue on Employee Tax Maintenance.

    I am having the same issue since the GP tax update. When adding the federal filing column to the smartlist Employee report, it reports incorrectly. For example, what should be "Single" reads "Non-Alien", what should read "Non-Alien" shows the employees first name, "Married" is the only one that displays correctly. I have checked the tables and views they are reporting correctly.

    Does anyone know how to resequence the filing status? When I resequenced the order of the deductions by going to Card>>Payroll>>Deduction Sequence it fixed a printing payroll issue that happened after the upgrade as well. In this instance, an employee did not have enough PLT time to cover his deductions and the payroll check did not print. By organizing the deductions by the most important it fixed the issue.

  • Hetal Kapadia Profile Picture
    Hetal Kapadia 575 on at
    Re: Federal Filing Status issue on Employee Tax Maintenance.

    Thank you for your response Mindy. We did perform year end tax update and there was one more update during the 3rd week of January that we performed. We did not face any errors or problems with that update so i am not sure what could have caused that value to disappear from the list.

    If i can get assistance to add that option back in that would be helpful.

    Thanks!

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans