Dynamics Community Forum Thread Details

1099 Amount recording.. 1099 type / box

Hi,

Trying to figure out what happen to 1099 data. We ran the 1099 and had missing data and trying to figure out what had happen. I have restore the database from last year trying to figure out if it was being recorded.

The Vendor (check in PM00200) was setup with 1099 Type = 4 and 1099 Box = 7. This was before the year end update

So I check the PM00204 table for the vendor and see there are entries for Vendor, 1099 type = 4, 1099 box = 7 and for 2020, period id 1-12, all TEN99AMT = 0.00

I checked the PM30300 table for vendor, I have Apply Amount with what we paid, but all the TEN99AMT are all 0.000. The DEFTEN99Type is 4; and DEFTEN99BOXNUMBER = 7 for those invoices.

Is something setup wrong or does 1099 type 4 / 1099 box 7 does not record 1099 amount. Only because I looked at all 4/7 in PM00204 and all 1099 amount are 0 for 2019-2021

Categories:

Microsoft Dynamics GP

Hi Michael-

Thank you for your post.

What version of Microsoft Dynamics GP are you using? What did you update from?

The following is a blurb we have on box 7 for 1099 NEC. Does this appear to be what you are seeing?
Box 7: Checkbox to record whether Payer made direct sales of 5,000 or more of consumer products to a buyer (recipient) for sale