Changing Closed Invoice 1099 Data

[Former Member]

We are putting out our 1099 reports, but our system was never set up with 1099 vendors, so we have hundreds of invoices that need changed. How can I retroactively change them so they come up correctly in reports?

If B1 can't do it, what tables are affected when an invoice is added with 1099 data? Can I just do a batch SQL update on all invoices to specific vendors to the correct 1099 forms and boxes?

[Former Member]

This is closed, but I never got any feedback. It seemed to work, but I don't know for sure.

[Former Member]

So I just ran the following query on our database for all our 1099 contractors. Everything seems to be pulling up fine on the 1099 reports. Am I missing something major that will throw off my numbers?

UPDATE OPCH

SET Form1099 = '1',

Box1099 = '07'

WHERE CardCode = 'V00124'

UPDATE ORPC

SET Form1099 = '1',

Box1099 = '07'

WHERE CardCode = 'V00124'

UPDATE OCRD

SET FormCode = '1',

Box1099 = '07'

WHERE CardCode = 'V00124'

Also, do credit memos affect the 1099 report at all? What if we entered the original AP invoice incorrectly and canceled it out with a credit memo (that may or may not have been linked to the original invoice)?

[Former Member]

Anyone have experience with this?