When we print the 1099 Form from our E10.1.600 database it is not lining up with the pre-printed Government 1099-MISC Form. I only seem to have a Standard US 2014-SSRS and a Standard US 2015-SSRS Report Style available. I’m assuming I need a Standard US 2018-SSRS Report Style to match up with the Government form we are using? If so, how can I get a copy of this Report\Report Style and load it into our database? I’m assuming we need to contact Epicor but just wanted to better understand what we are missing so I know what to request.
I’ve tried printing with various Printer Settings and Options selected but the information just does not line up in the boxes.
Thank you for any help anyone can provide,
-Heather
Hello,
I wanted to update this post with some instructions on how to modify the 1099 Form in Epicor for use in any environment whether you use Fox It Reader or Adobe Reader or any Printer Driver.
Epicor tried to supply another modified .rdl file to us (so you might want to try their’s first?) but I had some troubles getting it to work in our database. So I just went ahead and modified the .rdl that we already had.
Here are some instructions for modifying the 1099 Form in Epicor to match up with the Government pre-printed 1099-MISC form:
I’m still new to SSRS and Report Builder but this is what worked for us.
I hope this helps someone out there!
Thanks,
-Heather
BTW, sorry for the CustomReports \ _CustomReports path, it’s something quirky and a little confusing that I setup when I was first learning SSRS and haven’t had time nor reason to change…yet.
Ah, pity I didn’t see your OP, I just did this last week. Its not too bad - just involves printing and uploading your report a bunch of times till its lined up just right.
Nice write up. To reduce the number of iterations of bumping the text boxes around, select all of them and turn their boarders on. Then you know exactly how much each needs to move after the first print. Also take advantge of the Alignment tools when editing the RDL
So we are having an issue with the 1099NEC printing. The first record prints perfect, however the 2nd form adjusts by almost a 1/4 inch. If we try to adjust the print area it then moves the print on the first doc. Every field should be printing 5 1/2" from document to document, but it appears to be printing at 5 1/4 at the next change in recordt. This is ridiculous…how can you get this form to print the next record at 5 1/2" and not 5 1/4? The docs are expensive and I don’t purchase in excess so that I can fight this program every year. Any suggestions
These things are always such a pain every year. Thankfully, management wanted me to keep working on other tasks so they bought some other software for like $100 to do the 1099 printing this year.
For 2020 1099Misc for contractors need to be on a 1099NEC form and the boxes have changed on where you report their income, from 7 to 1, so we had to revamp the form and even the slightest adjustment sends the second form on the page out of wack. If you measure the repeat should be printing every 5 1/2 ", but when I measure from form to form each print area is set at 5 1/4, so no matter what I do it’s going to print the 2nd record on the page out of the print area
@Khelm911 I found while modifying my report that it worked best the delete any empty table rows and have one row containing all the fields and have that row height set to 3.6667 in. Also check your printer to make sure it is printing to Actual Size, not FIT.
I believe that you can order the forms from Epicor and that for any changes in the form, Epicor should have updated RDDs and/or RDLs to match the changes on the form. I think this is provided because you/we pay for the USA country specific functionality.
The only thing that will impact this is whether you are on a supported version/release of Epicor.
Full disclosure- I have never ordered these forms from Epicor and always bought my own from a different vendor which meant I had to adjust Epicor’s RDL a bit like most people on this post.
