Why am I getting an error "Malformed record (too many columns)" when trying to send a certificate request from Microsoft Dynamics GP?
Overview
You attempted to send a certificate request from GP and were not able to with the error:
Name: EntitySaveError
Summary: Error saving the CertificateRequestInitiate
Details: Request Skipped; Error: Malformed record (too many columns)
Environment
Dynamics GP
Avalara Certs
Resolution
- This indicates the customer number (Cust Ref ID) contains a comma
- Go to Avalara Certs to send this certificate request, it is not possible to send the request from GP due to the comma