By using this website, you agree to our Terms of Use (click 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.