AR Item with a single quote within the string.

Hi All,

Today I have come accross a very interesting issue and would like to share to all and need some help to understand it properly.

In AR, the item id is a character field and it allows the user to enter the item id as something including a single quote like say Item id= 'Bank's Fee'. In this kind of scenario, we are getting an error with the transfer worksheet ARUPDATE process with the error message like 'sql doesn't properly'. Interestingly,  It did allow the user to post the item as the open item in the PS_ITEM table but not allowing to close it by the transfer worksheet.