Hi all,
I am looking to create a report where I want to see all lines related to each bill.
Such as if a bill has 5 line rows, I want this data so is there a way to get this?
Thank you
Amar
Solved
How to get data from AP Bills Row lines
Best answer by lauraj46
Hi
You can join APRegister with APTran on APTran.RefNbr=APRegister.RefNbr and APTran.TranType=APRegister.DocType to get the line details.
FYI, if you have permission, a useful technique is the shortcut Ctrl+Alt+Click to "Inspect Element" on a screen control to find the Data Access Class. From there you can also click the DAC hyperlink to open the DAC Schema Browser which provides details about the DAC fields and relations to other DACs.
Hope this helps!
Laura
+8Hi
You can join APRegister with APTran on APTran.RefNbr=APRegister.RefNbr and APTran.TranType=APRegister.DocType to get the line details.
FYI, if you have permission, a useful technique is the shortcut Ctrl+Alt+Click to "Inspect Element" on a screen control to find the Data Access Class. From there you can also click the DAC hyperlink to open the DAC Schema Browser which provides details about the DAC fields and relations to other DACs.
Hope this helps!
Laura
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.