Hello,
In order to dipslay both English and Chinese to customers on invoice, we put English and Chinese characters together on Item Description field like below:
Beef 牛肉
However, the space between them is not good enough for us to trim Chinese (Some customer does not read Chinese, it is not necessary). So we want to put “//” between “beef ”and “牛肉”.
If there a quicker way to find out all item already with Chinese characters in Description?
Best answer by ray20
To someone who also interested in this topic, I did NOT find a way to do it in Acumatica. But I found out a way to do it quickly in Excel.
You just export the item list into a Excel. Comparing the Len() and LenB() of description field.
The false result just shows the string has Chinese characters in it.
The reason behind this is English Character and Chinese Character are different length.
To someone who also interested in this topic, I did NOT find a way to do it in Acumatica. But I found out a way to do it quickly in Excel.
You just export the item list into a Excel. Comparing the Len() and LenB() of description field.
The false result just shows the string has Chinese characters in it.
The reason behind this is English Character and Chinese Character are different length.
Thank you for sharing your solution with the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
