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
Question
How to get data from AP Bills Row lines
+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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.