I’m nearing the end of my Config creation, I’ve added pics of how my info is showing in the config currently.
What I want to do is make everything in red “bold” and 2 Font sizes bigger.
How do I accomplish this?
What I want to do is make everything in red “bold” and 2 Font sizes bigger.
How do I accomplish this?
You may get some ideas watching this:
Do you need it to be stored that way? Or just appear on the configurator window?
As things stand, what you see in the Config window, is being pushed back into the quote, and it also appears on the P/Os too. I want it to show in bold all of the time.
That’s asking a lot. Will this be saved to a UD field? or need to display in a native field?
If just want it in the configurator, you could build it in HTML, save as a file on the server, then have a Browser Control point to that file.
The following code is an example:
string text;
text = "<!DOCTYPE html><html><head><title>Page Title</title>";
text = text + "<style>p {font-family: mono; font-size: 20px;}</style>";
text = text + "</head><body>";
text = text + "<p>";
text = text +"<b>Install the following: </b>";
text = text + "DCP U7 Sepc .... " + "<br>";
text = text + "<br>";
text = text +"<b>Options: </b>";
string OptionsText = Inputs.txtOptions.Value;
text = text + OptionsText + "<br>";
text = text + "</p>";
text = text + "</body></html>";
System.IO.File.WriteAllText(@"\\usdcaaps00371\EpicorData\HTML_page2.html", text);
Inputs.brwsSummary.Value = @"\\usdcaaps00371\EpicorData\HTML_page2.html";
I put that in the OnChange event of the Options textbox. after tabbing out of that control, it builds the HTML and writes it to the file. Then the last line points the Browser control to that file.
Not sure about showing HTML formatted text in a native control on a regular forms (Order Entry, PO, etc…), but you could save the HTML used to generate the display on the configurator, to a UD field, and then set the Report to display HTML.
It might not be super obvious, but the HTML formatted comment above, renders in the SSRS output:
Now you wouldn’t want to store that in the native field. But rather in a UD field. And the UD field is what the SSRS report would use
At my previous gig, I created a templated RTF string and pulled the data into in and then the user pressed a button, it put the filled in script on the clipboard and they’d paste it into Word. The product was a big ticket item so the quote was delivered on nice heavy paper, formatted more professionally than SSRS.
The next goal, which was about 50% done, was a OfficeJS addon (we were on O365) that would pull the values from the configuration (REST+BAQ) and put them into the Word document template for that product group - like a mail merger. In 10.2.500, you could get the values in a BAQ but that happened after I left.
I have all of the info stored in UD tables as is. My pricing, op Instructions, and timing, is NOT pulling!
What do you mean? The value from the UD table doesn’t show on the report, on the form, or elsewhere?
It’s not showing on the form. Right now, my solution is to add the “Sales Price” to the end of the descriptions.
Are you trying to embed the HTML into the value stored in the UD table?
Maybe the form’s control doesn’t like that embedded HTML. In my test (shown in post #6 above) the built-in control (bound to OrderHed.CommentText ??) does show the HTML.
I added the pricing to the description, but I’m still not getting even the “rolled up” price!
My IT guy beleives that my pricing shouldn’t be coming from the UD table, it should be pulling from the parts themselves. Is this true?
Just to make sure I follow you …
- You have a configurator that builds a description (which you want to include bold text in), and includes a calculated price.
- This description is shown in the configurator during configuration.
- This description is stored in a UD table. Is it an actual UD table like
UD01(UD01.Character01), or an extension to an existing table likeOrderDtl(i.e.OrderDtl.MyDesc_c)? - This description is displayed in a custom control on Forms (quote Entry, Order Entry, etc…)
- This description is to print on reports like Quote and OrderAck
That correct?
You got it!
We discovered this morning that the “Phantoms” are not pulling as assemblies. Once I checked “pull as assembly” the cost camme over to the worksheet as expected. But my consultant expressly forebade me from checking “pull as assembly” when I was creating the phantoms. So who’s right here?