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 / 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

I have the same question (0)
  • Mindy S Profile Picture
    Mindy S 40 on at

    The fourth option is "Nonresident Alien".  Maybe you are missing one of the payroll updates?

  • Hetal Kapadia Profile Picture
    Hetal Kapadia 575 on at

    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!

  • Mikki Milligan Profile Picture
    Mikki Milligan 80 on at

    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

    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

    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

    Bump...

  • Mikki Milligan Profile Picture
    Mikki Milligan 80 on at

    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

    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!

  • Jane Maritz Profile Picture
    Jane Maritz 70 on at

    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

    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.

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 > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans