Error modifying 1099 box code on invoice - apvn1099io_delete: Execute delete_apvn1099...

Description of Issue

Error modifying 1099 box code on invoice - apvn1099io_delete: Execute delete_apvn1099 28: [Microsoft][SQL Server Native Client 11.0][SQL Server]The DELETE statement conflicted with the REFERENCE constraint "FK_apd9_ap99_id". The conflict occurred in database "mu8714", table "dbo.apvndetl", column 'apd9_ap99_id'. -691 [ISAM -547]

Context

Munis

Modify Invoices

Cause

0.00 1099 records exist for vendor in Vendor 1099 Detail program

Resolution

Financials>Accounts Payable>Vendor Processing>AP 1099 Functions>Vendor 1099 Detail

  1. Click Search
  2. Enter Vendor Number
  3. Click Accept
  4. Locate any 0.00 records and delete
Additional Information