Skip to content
logo Knowledgebase

Error: "The 1099 Electronic Consent Signed is required." when making changes to an existing vendor and utility to Fix

Created on  | Last modified on 



Converted Vendor records have a blank ElectronicConsentSigned1099$ field in AP_Vendor.m4t


CAUTION: Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst.

Program fix was released on versions 2016.4 (, 2017.0 (5.40.0) and higher. Install the product update on version 2016 or upgrade to version 2017 or higher.

If that is not possible, use the following workarounds:

Possible Resolution 1:

  1. Go to Accounts Payable, Main, Vendor Maintenance, Additional tab
  2. Under 1099 Form section set Vendor Type to something other than none and check the Electronic Consent Signed check box
    • Note: This option is only available is 1099 Reporting is selected in AP Options
  3. Click Accept
  4. Reselect same Vendor record and set Vendor Type back to None and click Accept

Possible Resolution 2:

  1. Go to Library Master, Utilities, Data File Display and Maintenance
  2. At end of Filename field click folder to navigate to MAS_XXX\APXXX and open AP_Vendor.m4t
  3. Locate Vendor record and click Edit
  4. Select ElectronicConsentSigned1099$ field and change to N

Possible Resolution 3:

  1. If you own the Visual Integrator module, use the following steps to import the two Visual Integrator jobs (attached to this document as a single EXP file) to correct the data into your Sage 100 Installation:
    1. Open Visual Integrator, Main menu, Job Import
    2. Browse to the location where you have downloaded the attached Visual Integrator Jobs (in *.EXP format)
    3. Click Select All and click Accept
  2. Run the "AP Vendor X" export job to export all Vendors that have blank Electronic Consent Signed fields to a text file:
    1. Open Visual Integrator, Main menu, Export Job Maintenance
    2. Select the "AP Vendor X" Export Job
    3. Click Accept and run the Export Job
  3. Run the "AP Vendor Fix" import job to populate blank Electronic Consent Signed fields with a "N" for all vendors that have a blank for that field value. (Note: this import will also set FATCA field to default "N" value.)
    1. Open Visual Integrator, Main menu, Import Job Maintenance
    2. Select the "AP Vendor Fix" Import Job
    3. Click Accept and run the Import Job

Possible Resolution 4:

  • Run attached Utility to populate ElectronicConsentSigned1099$ field in AP_Vendor.M4t from Blank to N
  • Note: This Utility will only work for Sage 100 Standard and Sage 100 Advanced versions
    1. Copy the attached program CX_FIXAPVENDOR to the folder ..\MAS90\SOA folder on Server
    2. In Sage 100, Click File, Run and enter SYZCON
    3. Enter RUN “CX_FIXAPVENDOR at prompt
    4. Close SYZCON
    5. Repeat steps 2-4 for all other affected companies

Attachment: 305_20230425124403_ElectronicConsentVIFix.EXP
Attachment: 305_20230425124403_CX_FIXAPVENDOR

Defect ID