I’ve imported HTML descriptions, but they are not displaying correctly in a report. They are displaying correctly on the stock items screen - just not the report where it is needed.
If I go to the stock items screen and make one small change, Acumatica will rewrite the HTML and it will then display correctly in a report.
Anybody have any ideas for updating these descriptions so that Acumatica will rewrite the description HTML. Should I put a ticket in for a SQL script? Will that resolve the issue?
Imported HTML
Imported Display
Report DisplayDisplay After adding a minor change to the description - Acumatica rebuilt the HTML
Best answer by BenjaminCrisman
@bwhite49 I reviewed importing into a different type of input but found that it is not possible to change the format via import scenario unfortunately.
I found some internal documentation which mentioned for importing into item descriptions it is best to leave as HTML to do the import and using anything else can results in errors which require direct SQL manipulation to undo.
Hi @bwhite49! Do you have the setting on the field displaying the HTML as ConvertHTMLtoText?
One major difference though is that this is just a conversion and will not work in some situations or with complex HTML. I’ve seen this come up before and if the setting can work for you then it’s great, but if not then I think it could be a good candidate for product enhancement if it’s possible in Report Designer
Thanks @BenjaminCrisman . Yes, this setting is on, but it’s not working for the imported HTML, but it is working for the HTML after Acumatica rewrites it after adding a space or adding some other small change in the text editor.
I’m hoping for a solution to mass “re-write” the HTML. There are about 1,800 items that need to have the HTML modified so that it displays correctly in the report.
@bwhite49 Apologies, I misread the initial cause and I thought you had lots of HTML markup in item description and were trying to display it in the report.
I see now that the description is what is incorrect, have you tried running an import scenario to update this? I can’t think of a time I’ve seen this before so I don’t have something on hand to draw off, but I think that would be the quickest way if possible
I’m not sure what that import scenario would look like. I created an import scenario to import the HTML, and that imported HTML is displaying correctly in the next editor (Breaks are in the right place, etc.)
It's just that report designer does not want to read it correctly.
I need a script that would go into the text editor, add a space or something to the existing description in the visual editor (not html), and have Acumatica regenerate the HTML.
I don’t think I can do that through an import scenario, correct?
@bwhite49 I reviewed importing into a different type of input but found that it is not possible to change the format via import scenario unfortunately.
I found some internal documentation which mentioned for importing into item descriptions it is best to leave as HTML to do the import and using anything else can results in errors which require direct SQL manipulation to undo.
I am having a different question, are you able to print HTML text on report but are you able to print it with Formatting, like Bold/Italic etc.?
I am not sure whether it is right thread or not but if you can answer, it will be really helpful.
Thanks in Advance.
No, the text to HTML converter just extracts the text. It ignores all the formatting unfortunately. Hopefully the web version of report designer (whenever that comes) will do a better job here.
