When entering a credit note against a Creditor have you ever come across the situation where the credit will not save, and you instead get a ‘String or binary data would be truncated’ message on the screen?
Sometimes Creditor Invoice numbers are very long, and when creating a credit note the system will add a ‘CR’ to the beginning of the original invoice number on the credit note. Sometimes, this pushes the number of characters for the invoice number over the system’s limit of 20.
This can be easily remedied!
Once you have tried to save and got the pop up:
Click ‘OK’ and go back into the credit note. Within the ‘Invoice no’ textbox and remove the last two characters:
Then finish processing the credit note as per normal procedure and it will save successfully.