Solved

Hyperlink navigates to wrong screen

wfilipiak67
Rank
Userlevel 5
Badge +2

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!

icon

Best answer by DavidEichner 16 January 2023, 23:02

View original

13 replies

DavidEichner
Rank
Userlevel 7
Badge +10

https://salesdemo.kensium.com/Acu2022R2/(W(32))/Main?CompanyID=Company&ScreenId=PO301000&OrderType=RO&OrderNbr=PO001824

Above 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

David Eichner, CPA - If I helped you, please *Like* my post/reply. If I provided an answer to your question, please mark it as *Best Answer*.
wfilipiak67
Rank
Userlevel 5
Badge +2

@DavidEichner , My url looks similar to yours. I am having the issue with passing the Type & the Order number to build the url for the field.

DavidEichner
Rank
Userlevel 7
Badge +10

When you hover over the field, does the URL look like mine?  

David Eichner, CPA - If I helped you, please *Like* my post/reply. If I provided an answer to your question, please mark it as *Best Answer*.
DavidEichner
Rank
Userlevel 7
Badge +10

Does your URL show the values for the Type and OrderNbr?  &OrderType=RO&OrderNbr=PO001824

David Eichner, CPA - If I helped you, please *Like* my post/reply. If I provided an answer to your question, please mark it as *Best Answer*.
wfilipiak67
Rank
Userlevel 5
Badge +2

@DavidEichner , What I ended up doing is this. I set the Navigation method to Client. 
& 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.

 

DavidEichner
Rank
Userlevel 7
Badge +10

I 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

 

 

David Eichner, CPA - If I helped you, please *Like* my post/reply. If I provided an answer to your question, please mark it as *Best Answer*.
wfilipiak67
Rank
Userlevel 5
Badge +2

@DavidEichner , What do you have for the NavigateParams? 
 

DavidEichner
Rank
Userlevel 7
Badge +10

Nothing.  I thought I needed them but it turned out I didn’t.

David Eichner, CPA - If I helped you, please *Like* my post/reply. If I provided an answer to your question, please mark it as *Best Answer*.
wfilipiak67
Rank
Userlevel 5
Badge +2

@DavidEichner, Well I tried what you suggested & It not working for me. The screen that gets opened is the Bills & Adjustments.
This is what I have setup for APInvoice to APTran
 


 

DavidEichner
Rank
Userlevel 7
Badge +10

@wfilipiak67  Yeah, I thought I didn't need the navigate parameters and removed them...and now it is doing the same thing as yours.  Weird.  I added them back and it is still opening the Bills & Adjustments screen now.  I will play around with it a little more and see if I can get it back to opening the PO screen.

David Eichner, CPA - If I helped you, please *Like* my post/reply. If I provided an answer to your question, please mark it as *Best Answer*.
wfilipiak67
Rank
Userlevel 5
Badge +2

@DavidEichner , Thanks. This is/was slowly driving me crazy. 

Thank you for your efforts on this.

Bill

DavidEichner
Rank
Userlevel 7
Badge +10

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.

 

 

David Eichner, CPA - If I helped you, please *Like* my post/reply. If I provided an answer to your question, please mark it as *Best Answer*.
wfilipiak67
Rank
Userlevel 5
Badge +2

@DavidEichner , Thank you for this solution. It is working for me & the client. 
 

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved