Skip to main content
Solved

Approved AP Bills

  • June 24, 2022
  • 2 replies
  • 237 views
Yuri Karpenko
Captain II
Forum|alt.badge.img+7

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?

Best answer by Yuri Karpenko

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

2 replies

hkabiri
Acumatica Moderator
Forum|alt.badge.img+8
  • hkabiri
  • Acumatica Support Team
  • June 27, 2022

@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
    Captain II
    Forum|alt.badge.img+7
    • Yuri Karpenko
    • Author
    • Captain II
    • Answer
    • June 27, 2022

    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
      Terms & ConditionsAccessibility statement
      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