Hi, We added the PO number field to the AP Aging report ( AP631000)
Now the client would like have that field as a hyperlink to the PO entry. screen ( po301000)
The PO number is being pulled form APTran & is working great.
I tried to duplicate the hyperlink on the Reference Number but I am having no luck.
I get the PO Number to show as a hyperlink but when clicked the Bills & Adjustment screen opens with te AP Reference number.
on the PO field, Properties, the NavigateMethod is Server
I added NavigateParams of OrderType→ [APTran,POOrderType], OrderNbr ->[APTran.PONbr]
and the NavigateURL as https://company.acumatica.com/Main?CompanyID=company&ScreenId=PO301000&OrderType=OrderType&OrderNbr=RefNbr
For the URL, I’ve tried it in ‘ and with a $ before the OrderType & Order Nbr.
Any help would be appreciated.
Thanks!
Hyperlink navigates to wrong screen
+3Best answer by DavidEichner
I figured out how to get it to open the PO screen. Even though we were telling it to open the PO301000 screen, it apparently looks at the value from APTran and decides that we need to open the AP301000 screen instead. You can add a join to the POOrder table and then use the OrderNbr field from that POOrder table (both for the value and also for the NavigateUrl).
In my testing, some of the purchase orders work with the URL link and others do not. Still trying to figure out what is different.
+13Above is the format of what the NavigateURL should look like (with your site instance instead of mine) when you click on the field. Can you send me what URL pops up in the browser when you click on the field in the report?
Best,
David Eichner, CPA
Kensium
+3+13When you hover over the field, does the URL look like mine?
+13Does your URL show the values for the Type and OrderNbr? &OrderType=RO&OrderNbr=PO001824
+3
& the URL to
='https://company.acumatica.com/Main?CompanyID=Company+Live&ScreenId=PO301000&OrderType='+[APTran.POOrderType]+'&OrderNbr='+[APTran.PONbr]
This then opened the the PO in the same tab as the report.
I don’t see how to pass the NavigateParams to the URL.
or how to have clicked URL open in a a new tab.
+13I had to add the APTran table with a join to the AP Invoice. I then changed the NavigateMethod to Server and populated the NavigateUrl as shown below. This worked for me in the demo dataset.
Best,
David Eichner, CPA
Sr Solutions Architect
Kensium
+13Nothing. I thought I needed them but it turned out I didn’t.
+3
This is what I have setup for APInvoice to APTran
+13+3
Thank you for your efforts on this.
Bill
+13I figured out how to get it to open the PO screen. Even though we were telling it to open the PO301000 screen, it apparently looks at the value from APTran and decides that we need to open the AP301000 screen instead. You can add a join to the POOrder table and then use the OrderNbr field from that POOrder table (both for the value and also for the NavigateUrl).
In my testing, some of the purchase orders work with the URL link and others do not. Still trying to figure out what is different.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.