We have an application outside of Acumatica that has a page that accepts an order number in the URL. I want to create an Acumatica report that has a row for each filtered order and a column with a clickable link that will open this external dashboard in a new window, passing the order number in the URL.
I've gotten as far as creating a column in the Results Grid with a formula:
=Concat( 'DASHBOARD_URL', [SOOrder.OrderNbr])
How could I make this field into a clickable link? Or is there a better approach to this?
As of 2023R2, you still can't put an external link in a generic inquiry. You can have navigation to pretty much any other screen in Acumatica, but there is no way to get a link to work.
Even formatting the text to display the link isn't a valid workaround as they replace the right click context menu that might be able to open the link.
The only solution is to use a report. Even then I'm not sure if it would work for a non-Acumatica link as the way I was able to get it to work is using the "NavigateUrl" property on the report - which appends the main Acumatica URL and formats as a link. Again, not sure if you could get it to work with a link to another site.