— The Forums are now read-only —
— All new activity now takes place here: —
For example the description tab on stock items or CRM opportunities allow you to format data but it stores the HTML formatting in the text making it unusable on a report or GI. Acuamatica dev says it is not possible. https://feedback.acumatica.com/ideas/ACU-I-920
There must be some way to get this data by creating a SQL query and then creating a DAC or whatever.
This is from Acumatica L2 support
I just found better workaround for you.
You can customizae the CROpportunity by adding the calculated field that works similar to CRCase.DescriptionAsPlainText which is defined as follow:
#region DescriptionAsPlainText
public abstract class descriptionAsPlainText : IBqlField { }
private string _plainText;
[PXString(IsUnicode = true)]
[PXUIField(Visible = false)]
[PXDependsOnFields(typeof(description))]
public virtual String DescriptionAsPlainText
{
get
{
return _plainText ?? (_plainText = PX.Data.Search.SearchService.Html2PlainText(this.Description));
}
}
#endregion
Cool! Thanks for sharing! I could see this technique being useful in a number of places.
FYI, I'm in JAMS M200 training this week. Finally found my way into the Manufacturing modules. It's been a fun couple of days. And John Pavain is in the class. So your name came up. It's such a small world.
By using this website, you agree to our Terms of Use (click here)
