Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

FoxPro 7 report to print new 2021 1099 NEC form

Status
Not open for further replies.

zemelya1992

Programmer
Oct 19, 2021
1
US
So, the report that we use has all 3 blocks to print on the new 1099 NEC form but the last block is off vertically. Cannot move detail section down any more, prints last block on the new page. Any solution from anyone?
 
Zemelya,

I have a solution you may not want to hear.

I've had the same problem with other 1099 forms. My (brute force) solution was to draw the form exactly as the original. creating a new report. Once done, it's simple to make the changes each year which are necessary at least for the 1099-B.

Simply stated, as you may already know, the data to fill the form is used to create the "electronic" file to submit to IRS. The forms can be printed to a pdf in case the client needs the paper forms.

Steve

 
Another option is to draw the text onto a bitmap, and then draw the bitmap on the pre-printed form.

You can align things on the bitmap differently than you can with the VFP engine, and you can handle more complex scenarios. It will slow down printing somewhat, but it is a solution.

You'll create a canvas, paint it white, draw in the various fonts over the top of it at the various portions, save it to disk with a known filename specified by your report, and repeat this for each user. You can also use the frx / lbx and make a copy of it altering the filename to reflect pre-processed ones.

--
Rick C. Hodgin
 
Hi Rick,

I think the solution (yours or mine) might depend on how many forms need to be processed and printed. I process thousands of forms (mainly 1099-B's) from data provided by the clients.

On another project with more intricate forms, I sometimes create the forms on a report using a jpg. I then place the data fields in the appropriate places on the form. However I found too often the data position is slightly off in the output, requiring an adjustment.

So if practical, I draw the form itself so I know exactly WHERE the data will end up. Also, in that case, it is much easier to make changes to the form if necessary.

I'm not saying my way is the right (or only) way. I would need to know more about Z's requirement.

Steve

p.s. I happen to know the 1099-NEC is a fairly simple form. It's an abbreviation of the older 1099-MISC. It's short and takes about a third of a page.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top