SAP B1 - Query Generator - Unable to pull through golden arrow on query

[former_member1165600]

Hi,

Please see query below, simplified for purpose of question:

When you go into the GL breakdown there is a Golden Arrow that is used to drill into the transaction.

When I pull through this field into the query generator the golden arrow is no longer available.

Could you tell me how to pull this through?

Thanks

[Former Member]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with: https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html

Questions on how to draw responses from members? Check out this discussion on how to improve questions. https://groups.community.sap.com/t5/welcome-corner-discussions/advice-from-sap-champions-questions-a...

[LoHa]

Hi Mark,

for the Account it works for me.

You could try to force the arrows by using FOR BROWSE

regards Lothar

SELECT TOP 10 T0.[BaseRef], T0.[Account] FROM JDT1 T0 WHERE T0.[Account] = '169020'
FOR BROWSE

[former_member1165600]

Hi Lothar,

Thanks for your answer, it was the Origin (BaseRef) that I needed the drill down for.

It is available in the GL entry table and I am pulling through that same field in this report but the arrow doesn't appear with it.

Thanks

Mark