Sage 100

MAS 90 4.40.7 - AP_Vendor1099Payments file has an ""N"" in field 3 FormType1099 and file definition only lists M, I & D as valid types. All Vendors appear to be Individual in the Vendor record and the default form type is shown as Miscellaneous. In DFDM, people with an N have an amount but of course, it does not show on any of the 1099 history screens. Does anyone know where the N comes from?

N""one (NONE)

Thanks Beth. The additional Tab for the vendors that have the N show Vendor Type = Individual, Default Form = Miscellaneous, have a SS# and show default box 7 just like the other vendors that have an M in the file. A check of the Vendor file in DFDM shows VendorType$ = I and Form1099$ = M for these vendors. I know the Vendor Type can be N which just turns off the 1099 function. The Vendors with the N show amounts. What is it that triggers an N in the Default Form (form type) field?

Wonder if they used to be turned on and now are off?

None of the 1099 Vendors have None in the Vendor Type. I tried going from Form type Miscellaneous to Form type Dividend, Save, back to Misc & Save with no change, still got the N. Also tried changing Vendor type to None, Save, and back to Miscellaneous and save with no change. Still have N in the AP_Vendor1099Payments file. Weird.

Isn't that file updated when invoices with a 1099 status are paid? Have you tried processing a payment for an invoice with an 'active' 1099 status (assuming the vendor is set to something other than None and the invoice is subject to 1099)? Are you saying it doesn't show in the 1099 detail?

Think I have it figured out. Beth is right but I couldn't see it. Yes, the file is only updated when an invoice is paid and (I thought) only if the invoice has the 1099 Payment Form and Box fields filled in. I was wrong. It appears the N is a valid field in the 1099 payments file but is not documented. If you pay an invoice on a 1099 vendor but the Form and Box fields had been left empty, a record is still created in the Vendor 1099 payments file with N in field three. I did not know that and am wondering what I missed. It does make it easy to give a customer a list of non-1099 payments in case they don't think the total is right. This all started when a created an Export for a customer which is moving to another software product. Got a feeling they will be changing a bunch of N's to M's. They have about 100 companies. At this point, I won't fix the import to ignore N records until they tell me they are sure all N records are right.