AP integrity check does not zero out 1099 totals.

Problem:  If a vendor has a 1099 balance in either of the two open 1099 years but no actual 1099 activity for either of those two open 1099 years, the AP Integrity Check process to Rebuild 1099 History does not reset the vendor 1099 balance to zero.

Resolution:  Zero out the 1099 amounts with a SQL script ran against the SL application database.

Precaution: Confirm recent backups of your SL databases exist prior to running the SQL update statement. SL users should refrain from doing AP activity in SL while the update statement is ran so AP balances remain static until the update is complete. 
update ap_balances set
cybox00 = 0.00,
cybox01 = 0.00,
cybox02 = 0.00,
cybox03 = 0.00,
cybox04 = 0.00,
cybox05 = 0.00,
cybox06 = 0.00,
cybox07 = 0.00,
cybox08 = 0.00,
cybox09 = 0.00,
cybox10 = 0.00,
cybox11 = 0.00,
cybox12 = 0.00,
cybox13 = 0.00,
cybox14 = 0.00,
cybox15 = 0.00,
nybox00 = 0.00,
nybox01 = 0.00,
nybox02 = 0.00,
nybox03 = 0.00,
nybox04 = 0.00,
nybox05 = 0.00,
nybox06 = 0.00,
nybox07 = 0.00,
nybox08 = 0.00,
nybox09 = 0.00,
nybox10 = 0.00,
nybox11 = 0.00,
nybox12 = 0.00,
nybox13 = 0.00,
nybox14 = 0.00,
nybox15 = 0.00   
where vendid = 'xxxxxx'
--where xxxxxx represents the vendor ID that you wish to zero out the 1099 balances for