SYMPTOMS :
“STRING OR BINARY DATA WOULD BE TRUNCATED”
CAUSE :
WHILE SAVING THE ENQUIRY OR MAKING ANY RECORDS IN SALES, SALES ORDER, PURCHASE, PURCHASE ORDER, PROFORMA YOU WILL UNABLE TO SAVE RECORD OR WHLE SAVING, UPDATING GETTING THIS ALERT
RESOLUTION :
IF YOU WERE GETTING THIS ALERT WHILE SAVING OR UPDATING THE RECORDS IN RESPECTVE MODULE FIRST CHECK WIHT THAT CONTACT IF SELECTED CONTACT IS HAVING ANY CHARACTER IN PHONE NUMBER FIELD OR MULTIPLE PHONE NUMBER IS ENTERED IN SINGLE PHONE NUMBER FIELD THEN YOU WILL GET THIS ERROR
TO AVOID THIS MAKE SURE NO CHARACTER OR ANY SPECIAL SYMBOLS ARE ADDED ON CONTACTS PHONE MUMBER FIELD OR ANY NUMBER IN NAME FIELD OF THAT CONTACT IF IT WAS THERE KINDLY REMOVE IT AND SAVE THE CONTACT AND THEN TRY TO SAVE OR UPDATE THE RECORDS
MAKE SURE WHILE SAVING THE CONTACT YOU ENTERED ONLY SINGLE CONTACT NUMBER IN PHONE NUMEBR FIELD AND DO NOT PUT ANY CHARACTER OR SPECIAL SYMBOLS IN THAT FIELD, IF YOU WANT TO ENTER MULTIPLE CONTACT NUMBER FOR THAT SINGLE CONTACT THEN USE SUB CONTACTS MODULE
NOTE :
After Removing The Special Symbol Or Character Field From Phone Number Field Or Numeric Values In Name Field First Update That Contact And Then Go To That Records Which You Are Trying To Save And Getting This Alert And Then Refresh The Page. After Refreshing The Page Try To Update or Save that Record.