Sage have issued a program fix to correct damage which appeared during some upgrades of Sage 100 Accounts Payable data. Users had reported that after an upgrade they would receive an error “The 1099 Electronic Consent Signed is required.” when making changes to an existing vendor. In some cases this would also prevent them from adding a new vendor.
The bug appeared to be related to a conversion issue which left a blank ElectronicConsentSigned1099$ field in the Sage 100 file – AP_Vendor.m4t.
Sage initially issued a Visual Integrator job which could be used to export out a list of impacted vendors and then import a fix (essentially flagging that ElectronicConsentSigned1099$ field as “N”. This worked, however, it required that the site own Visual Integrator and it took two steps. For large volumes of Accounts Payable data the process was time consuming.
Sage just issued a program fix CX_FIXAPVENDOR which can be run from inside Sage 100 and does not require the user to own Visual Integrator.
The utility works by populating 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 (sorry Premium users).
- Copy the program CX_FIXAPVENDOR to the folder ..\MAS90\SOA folder on Server
- In Sage 100, Click File, Run and enter SYZCON
- Enter RUN “CX_FIXAPVENDOR at prompt
- Close SYZCON
- Repeat steps 2-4 for all other affected companies