Check Constraint Error When Trying to Move Approved Expenses to Vista
Resolve the check constraint error when moving approved expenses to Vista.
The following error indicates corruption with the 1099 status for one of the vendors in a batch:
The INSERT statement conflicted with the CHECK constraint
“CK_bAPHB_V1099YN.” The conflict occurred in database "Viewpoint", table
'dbo.bAPHB", column 'V1099YN'. Cannot insert the value NULL into column 'BatchSeq',
table 'Viewpoint.dbo.bAPLB'; column does not allow nulls. INSERT fails. The
statement has been terminated.
To resolve this error:
- In Vista, open the AP Vendors ( ).
- Select the Add'l Info tab.
- Confirm that the Subject to 1099 reporting checkbox is either checked or unchecked (should not have a black square).