U.S. Tax Reporter Year End 2020

[graziela]

Hello community,

This blog is not updated anymore, instead the blog for 2021 was created:
U.S. Tax Reporter Year End 2021 | SAP Blogs


This is our U.S. Tax Reporter Year End 2020 blog. If you have questions about 2020 Year-End reporting, you can post it here. This blog will be updated with tips, best practices and, SAP Notes related to this subject.

To be able to access the Year-end 2020 in the Globalization finder page you need to be logged on (similar to SAP Service Marketplace) because it is a gated area and would need authorization.

To review the planned Legal changes for US, start the Announcement of Legal Change application. You can find detailed information about the Announcement of legal changes on this blog.

SAP Notes

Tax reporter notes

2956914 - W-2 / 1099-R Forms, Envelopes and PR Approval letter for year 2020
2954621 - U.S. Tax Reporter Year End 2020 Announcement
2955032 - Year End 2020 Phase I for U.S. Tax Reporter
2975038 - Year End 2020 Phase II for U.S. Tax Reporter
2994384 - (Prerequisite objects for SAP Note 2975038)
3001227 - Year End 2020 Phase III for U.S. Tax Reporter
3006708 - (Prerequisite objects for SAP Note 3001227)
3009810 - TR: Year End 2020 additional U.S. Tax Reporter changes.
3012513 - TR: Cleveland OH requires State Employer Account Number in RS record location 248
3010979 - TR: 1099-R Employee Form being generated for Distribution Codes with zero amounts
3012492 - TR: EFW2 file format changes for the Commonwealth of VA for Tax Year 2020
3017122 - TR: Idaho W-2 electronic file rejected by Tax Authority due to incorrect Date formatting in Record RS


General notes

2922369 - IMG: Runtime Error for 3PR Cluster Views V_T51RK_1 and V_T51RX
2990487 - BEN: Limits for retirement, savings plans and Health FSA contribution in tax year 2021
2991544 - RPCPRRU0: Exempt wage types incorrectly configured in TAXT group
3000740 - GARN: IRS Publication 1494 for tax year 2021

Taxes
3008339 - TAX: Community Safety Payroll Taxes for Eugene
3013127 - BSI: Enablement of Tax Type 106 for Concurrent Employment


Important:

If you had upgrade the system to SAPK-60886INSAPHRCUS you need to run report RPUPAV00 as explained in SAP note note which is included in this Support Package:
2923573 - FLSA: Extension of Infotypes 0015 and 0267 to Support Overtime Premium Over Bonuses

This is just for release 608, because infotypes 0015 and 0267 were extended and now have two additional fields so that you can inform the period of reference of the bonus payments. Due this you should run the report.


The ASUG HCM US Webcast 2020 Slide Deck has been attached to SAP Note 2954621 - U.S. Tax Reporter Year End 2020 Announcement. In case you are an ASUG member, you can view the webcast recording via video on-demand.

Kind regards,
Graziela

[graziela]

Hi Deborah,

As per your description this 1099 is from FI and not Tax Reporter.

I found the FI-AP-AP-Q1 note:
732265 DMEE: Creation of XML files, some errors in the DMEE

But I cannot help too much, as this is not my area.

Kind regards,
Graziela

[former_member712493]

Thank you Graziela.  We will watch for it.

 

Regards,

Monica

[former_member724794]

Moses,

We too are facing same issue generating 1099 NEC file from RFIDYYWT. The program ends up with error ‘Format tree does not exist for tree type WTRE’.

We have implemented following notes, yet the error occurs.

2987409 – US Legal Change 2020 -1099 NEC Form

2919655 – US IRS New Withholding Tax Form 1099-NEC and Legal changes 2020.

3008444 – US 2020 Legal Change – 1099 File Changes

 Let me know if you can find a fix, meanwhile we have raised an OSS with SAP.

Regards,

Rishikesh Nalapur

[Debbie_Moses]

rnalapur  - we raised an incident with SAP also. I will let you know what we get back from them. Please let me know if you hear something.

[former_member723377]

Hi All ,

Once you implement SAP notes for 1099 , PDF forms will be generated successfully , but when you will try to upload file in IRS portal for e-filing 1099 NEC - you may get the error:

" 1 is the sequence number of your record that is not in ascending numerical sequence. This is the first record where we detected an error in the sequence. The sequence number is located in position 500-507 of each record. Please review your entire file for this error. Refer to the publication 1220 or contact your software company or service provider for further information."

Solution : Filter value for NEC DMEE tree needs to be added in BADI implementation "DMEE_US_WTRE_01", I hope SAP will release this SAP notes soon for US customers .

Alternatively , you can create your custom BADI implementation for " DMEE_BADI_01 " and the below filter values which is DMEE files for 1099 :

IDWTFILE_US_1099

IDWTFILE_US_1099G

IDWTFILE_US_1099INT

IDWTFILE_US_1099NEC

and also copy and paste the code from BADI implementation - DMEE_US_WTRE_01 method - MODIFY_OUTPUT_FILE in the custom implementation.

Hope this will help .

Thanks & Regards

Jamal Noorani

[former_member723377]

Hi All ,

IRS has separated 1099 NEC (Non-Employee Compensation) FORM and 1099 MISC (Miscellaneous).

In SAP notes - 2919655 you can get the details to implement 1099 changes for 2020.

This will be useful if you are trying to implement newly delivered 1099 changes for 2020 PDF-FORMS and wondering when SAP is going to deliver the "IDWTCERT_US_1099NEC1" .

If we use "IDWTCERT_US_1099NEC" - we will be able to print two vendors in a single page, which business team will not like to do.

SAP has delivered recently these forms but they have no plan to deliver "IDWTCERT_US_1099NEC1" as per SAP notes (FAQ - 1099)- 2973935 :

Q9. Does SAP have any plan to release Form IDWTCERT_US_1099NEC1?

A9. No, SAP does not have any plan to release Form IDWTCERT_US_1099NEC1.

When I was going through SAP notes on marketplace, I was looking for PDF-FORM "IDWTCERT_US_1099NEC1" as Business Team used to print two copies in a single page. Then I decided to develop "IDWTCERT_US_1099NEC1" with reference to "IDWTCERT_US_1099MISC1" which was delivered by SAP, I did minor enhancement in the PDF-FORM

"IDWTCERT_US_1099NEC".

I am attaching the FORM "IDWTCERT_US_1099NEC1" for your reference with a hope that it might be helpful to someone or SAP can use it and release it for all US customers.

I have two options once I completed the development "IDWTCERT_US_1099NEC1":

1. Overwrite the PDF FORM - "IDWTCERT_US_1099NEC" with "IDWTCERT_US_1099NEC1" :

and it will work perfectly fine - assuming all the configuration is maintained for the NEW PROCESS TYPE - "US_1099NEC" - US - 1099 NEC Reporting" (You can refer to SAP notes 2919655 for configurations steps).

OR

2. Define a new process type as "US_1099NEC1" and complete the configuration. However, we need to do one additional steps - we have to create custom implementation for BADI - "IDWTREP_ADOBEPRINT" - you can refer to implementation created "IMPUS_IDWTREP_ADOBE" and add the filer value as "IDWTCERT_US_1099NEC1" form name . We may have to create few methods while implementing BADI - you can refer again to "IMPUS_IDWTREP_ADOBE" and copy paste code from the implemented BADI.

Note: When creating a new PDF FORM "you are uploading the XML - Please save under package "ID-FI-WT".

Hope this will help. All the best !!!

Thanks & Regards

Jamal A Noorani

[former_member723377]

Hi All ,

You can also refer to SAP notes – 2873935 for FAQs on USA IRS TAX legal changes 1099 2020 , this is very useful as well .

Thanks & Regards

Jamal Noorani

[former_member723377]

Hi All ,

I have already developed 1099 NEC1 2020  ,You can download the “IDWTCERT_US_1099NEC1” ( 2 Copies per page for NEC 1099 2020 ) from the below link from google drive :

https://drive.google.com/file/d/1wqD635lzaz8fBc7N1430eiDNPvOkKmy0/view?usp=sharing

Request your development team to upload in SAP as PDF form – “IDWTCERT_US_1099NEC” so that you don’t need to do custom BADI implementation for IDWTREP_ADOBEPRINT.

I hope SAP will release this for all US customers soon as a new notes .

Thanks & Regards

Jamal Noorani

[yaseen]

I was able to fix the 'Format tree does not exist for tree type WTRE' error by entering the DME file fields in the 'Define Output Groups' for 'US_1099NEC'

Select 'Download file to Frontend' under DME file

In the format tree field add -  'IDWTFILE_US_1099NEC' . These two were not mentioned in the manual steps of the OSS note.

[former_member724794]

Yes we too were able to fix the issue by maintaining the missing DMEE entry. Not sure, why SAP didn’t capture this part in post manual steps of note 3008444. Thanks for the update. 

Regards,

Rishikesh Nalapur

[former_member723377]

Hi Yaseen ,

SAP has suggested to add BADI filter value as per Notes 3008444 updated last week .

Do not forget to update it in SAP otherwise once you upload the file on IRS portal for e-filing you will get error .

Thanks & Regards

Jamal Noorani

[yaseen]

Thanks Jamal. We will look at the BADI filter values.

[Randall_A]

Hello graziela.dondoni,

Some of our tax reporter number ranges are getting close to the max value, and the number length cannot be extended any further. An example would be our Control number for simulation runs. Is it okay to restart from the beginning of the range? What is the best approach?

 

Thanks.

Randall

 

[ChandraV]

randall.allred can you check this section in your tax reporter configuration? - SPRO> Payroll US> Tax Reporter > Additional settings for Tax Reporter.  This configuration segment has few optimization options for number range issues; please check if you are utilizing these. The Configuration nodes in this section has more details about this optimization.

Thanks

Chandra

[former_member300128]

Good morning,

we ran Tax Reporter yesterday morning, the Feature UTRES is set to 1 day, we do not see the W-2 online in Accessport nor IT3228.  do you have any suggestions?

[LarrySuttles]

Sandra,

Have you set the generation date? The 1 day in feature UTRES starts from the date entered.

Larry

Edited - Actually I'm not sure if my above comment is true or not. Feature documentation says nothing about the "Filing date" in PU19 having to be filled in.

[former_member300128]

Thank you Larry,

It was the user, they executed tax reporter in the online vs background, asked the area to rerun with overwrite mode in the background, it processed successfully.

Thank you!

[graziela]

Hello community,

Note has been released:
3017122 - TR: Idaho W-2 electronic file rejected by Tax Authority due to incorrect Date formatting in Record RS

Kind regards,
Graziela

[Randall_A]

Thanks Chandra. We are using those options for the control number range. Our issue is with simulation control number range and log number ranges are getting close to limit. The number length is already at the max per domain. Is the best option to restart the number range? I have not found any documentation on SAP to address these scenarios.

[former_member85620]

Hello everyone,

 

Does anyone have W2 reporting for Massachusetts? We now have to upload because we have more than 50 employees and we are having issues with the length not being 512. The form looks fine in configuration but when we download the MMREF-1 form out of PU19 it has all records on one line (RS, RW etc.). I am hoping that there is something I can do in sm34 to fix this. We get this message when we try to upload to tax authority:

"All records must be 512 in length. This record must be corrected before it can be further validated."

Regards,

Lena

[CarlosAccorsi]

Hello Lena,

Some forms require the carriage return to be customized.

This way, could you please update the form as per instructions of the following SAP Note?
133613 - Formatting temse files for download

This should solve the issue you are facing.

Best Regards,
Carlos

[former_member85620]

Hello Carlos, thank you I will give these steps a try. Hope it works!

 

Regards,

Lena

[juli_thompson]

We recently received the W-2 dataset format specs for the CCA (Central Collection Agency) for Ohio.  This file spec is much more detailed than I’ve seen previously and there are several decisions that are required to determine the correct codes to send for several fields.

One example is if the taxing municipality is found in Appendix B positions 7-9 are reported as this…but if the municipality is not found in that appendix then do this.  Actually there are 3 options as you steps through the logic which complicates the correct value.  I didn’t see a delivered file from SAP (ex. HR_F_MMREF_1_OHR) to use for CCA (OH).

Has anyone worked on a file format like this for Tax Reporter?  Is there a document that I can review which would explain how to setup a file that requires several decisions vs. static data?

thanks,

Juli 

[dduron]

Hello everyone,

Does anyone know where to find IRS form 1098 Mortgage Interest Statement in the configuration or if standard program available for generating the form?  My colleague on the Finance side is looking for the statement in the Finance Module but was told it comes delivered in the Payroll Module.  I checked the forms available  in Tax Reporter configuration but could not find. The forms there begin with 1099.

Any insight would be appreciated.

Thanks,

Debbie

 

[Katt]

Our company is missing the state and local summary page (PU19) for the state of NH. How would we go about getting this setup for NH? Is this something that requires configuration or is this something that SAP maintains?

Thanks,

Katherine

[manmoha886]

Hi Jamal,

Thanks for the detailed approach, my client does not have Adobe licenses, can we use the above notes to activate and generate smart forms without adobe license.

 

Thanks&Regards,

Mohan.

 

 

[ChandraV]

1098 would be an Industry specific student lifecycle management solution, not included as part of the generic PU19 tax reporter.  Please check this SAP help page relating to this topic.

Thanks

Chandra

[Katt]

While reviewing our 2020 W2's, we found out that box 18 is doubled for a teammate where employee lives in one PA local and works in other PA local where as taxes withheld for both locals, /701 is same for both locals. SAP adds /701 of both locals and duplicate box 18. These cases should have /701 not duplicated.

We have an employee  who lives in PBM9 and works in PB7P.

When we run US W2 for this employee, we could see her box 18 is doubled with /701 wages of both locals.

PBM9 YTD for /701 is 74,891.61

PB7P YTD for /701 is 74,891.61

Total of both 149,783.22 (box 18)

This is incorrect as BOX 18 in this case should report only one /701 which is 74,891.61

Anyone encounters the same?

Thanks,

Katherine

[graziela]

Hi Katherine,

I took over your case and I´m checking this.

Kind regards,
Graziela

[graziela]

Hi Katherine,

I believe my colleague has already worked on the case you open, correct?

Thank you,
Graziela

[Katt]

Yes we are working on this currently.

Thanks!

[jahnavi_kavuru]

Hello Graziela,

Has the note to update 941 form for 2021 been released? I could not find it. Should this be enquired at some other place? If this is not the right place, could you please point me to it?

 

Thanks,

Jahnavi

[graziela]

Hello jahnavi.kavuru,

This is not released yet. You can follow up in the announcement of legal changes. As per the information that I have Developer will post the changes there, the note number and the planned release date.

P.S.: this is not posted yet, but you can keep an eye on it.

To review the planned Legal changes for US, start the Announcement of Legal Change application. You can find detailed information about the Announcement of legal changes on this blog.

Kind regards,
Graziela

[greg_zifchock]

Graziela,

In BSI TUB 46 introduced a new Tax for Ohio - Tax Type 107 - ER MUTUALIZED ACCOUNT TAX

Do we know when SAP is going to release a Note on configuring this tax? This is retroactive back to 1/1/2021.

 

Thanks,

Greg

[former_member265305]

Hello Greg,

We are working on the new Wage Types. The SAP Note should follow soon.

Thanks for the patience and best regards,
Marcelo

[graziela]

Hello Greg,

SAP note 3033836 - BSI: Tax Type 107 - Employer Mutualized Account Tax has been released.

Kind regards,
Graziela

[Katt]

I am being informed that on the W2, box 16 for NJ state wages should not exclude cafeteria plan benefits. I am working to confirm this is correct. If so, this is a change that would be made by SAP or is this configuration?

Thanks,

Katherine

[ChandraV]

That will be a config, katherine.james . Adjust the tax model for NJ state so that taxes come out correctly for the employees on their paycheck and will eventually correct the box 16.

Thanks

Chandra

[Katt]

Chandra,

Thank you for the information.

[kimg_sage]

Hi Graziela,

 

We applied note 3036495 - TR: Form 941 (FED) update for Q1/2021 in our sandbox.  When we test our 941, it has a revision date of July 2021 and the IRS website is March 2021.  Any suggestions?

 

Thanks and Kind Regards,

Kim

[graziela]

Hi Kim,

Did you upload the new form delivered in note 3036496 in SFP transaction?
The manual steps.

I´m my internal this is correct.

Kind regards,
Graziela

[kimg_sage]

Hi Graziela,

Hopefully you meant note 3036495.  And yes, the manual steps were performed.  The tables were all double checked and HR_F_941_21 is in V_51T5_B.

Kind Regards,

Kim

[graziela]

Hi Kim,

Yes, this was a typo.

But the form in SFP transaction?


Could you check if it is active?

Kind regards,
Graziela

[kimg_sage]

Hi Graziela,

Yes, the form is active.

Kim

Activated Form

[kimg_sage]

Hi Graziela,

We found an issue in how the note was applied.  After making the correction, it is now printing the correct revision date.  Thank you for your time and assistance.

Kind regards,

Kim

[graziela]

Hi Kim,

Thanks for the update.

Regards,
Graziela

[juli_thompson]

Will the 2021 Year End blog be setup in the next several weeks?  Also how do we find out the link to access the site?

I am watching for the SAP Note level required for Year end.

[graziela]

Hi Juli,

The Year End blog is already in draft.
Once developers release the announcement note I will post here the blog with all the details.

Kind regards,
Graziela

[Katt]

We recently started filing in Florida and looking to see if anyone successfully uses the FL SUI magnetic media file. If so, which file do you use? We have less than 20,000 so not required to use the XML file. Anyone have success using the MMREF file?

Thanks,

Katherine

[graziela]

Hello Juli,

The blog was just posted.
U.S. Tax Reporter Year End 2021 | SAP Blogs

There will be some updates in the next days.

Kind regards,
Graziela