1099 Amount recording.. 1099 type / box

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (1)

Answers (0)

Suggested answer

Nicole Hellerud 1,712 on at

Like (0)

Report
RE: 1099 Amount recording.. 1099 type / box

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

2019 form: Box 7 was used for Non-Employee Compensation (this box has been moved to box 1 on the new 1099 NEC form)

(+) Microsoft Dynamics GP Year-End Update 2020: Payables Management form changes including the NEW 1099-NEC!! - Microsoft Dynamics GP Community

I look forward to your feedback when available.
Nicole Fiskum
Support Engineer
Microsoft Dynamics