Trying to build a GI to show AP Bills approved by a specific employee (or any employee really), and can’t find a way to join APInvoice with EPApproval or EPOwned or any other DAC that can have approval data (approvedByID). Any ideas how to solve this riddle?
Answer
Approved AP Bills
+6Best answer by Yuri Karpenko
Thank you
I figured that actually joining APInvoice and EPApproval on NoteID = RefNoteID works too.
Thanks for your comment though!
+8- Use APRegister DAC for the AP document
- Use EPApproval DAC for Approval Data
- Use Left Join on relation and APRegister.NoteID = EPApproval.RefNoteID
SAM KABIRI | L2 Support Engineer | hkabiri@acumatica.com | www.acumatica.com
+6Thank you
I figured that actually joining APInvoice and EPApproval on NoteID = RefNoteID works too.
Thanks for your comment though!
Yuri Karpenko | DM me if you need help building e-Commerce for your business or connecting it to Acumatica ERP
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.