Solved

Approved AP Bills

  • 24 June 2022
  • 2 replies
  • 104 views
Yuri Karpenko
Rank
Userlevel 7
Badge +6

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?

icon

Best answer by Yuri Karpenko 27 June 2022, 21:31

View original
Yuri Karpenko | DM me if you need help building e-Commerce for your business or connecting it to Acumatica ERP

2 replies

hkabiri
Rank
Userlevel 6
Badge +5

@Yuri Karpenko 

  1. Use APRegister DAC for the AP document
  2. Use EPApproval DAC for Approval Data
  3. Use Left Join on relation and APRegister.NoteID = EPApproval.RefNoteID
SAM KABIRI | L2 Support Engineer | hkabiri@acumatica.com | www.acumatica.com
Yuri Karpenko
Rank
Userlevel 7
Badge +6

Thank you @hkabiri 

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

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