Skip to main content
Solved

How to join the Approvals (EP503010) form and the Bills and Adjustments (AP301000)


Forum|alt.badge.img

Hello!

Documents need to be approved is updated in the dashboard and inquiry for the dashboard is taken from the Approvals form. We want to show the project ID of the document to the dashboard but unfortunately Project ID is not in the Approvals form. Hence we create another inquiry joining Approvals form and the document but it seems not accurate. 

Is there any possibility to join the Approvals (EP503010) form and the Bills and Adjustments (AP301000), if so please assist me. 

Regards 

Amanda 

Best answer by vkumar

Hi @apallawala21 

Here are the details you are looking for :

AP Bill details will be in APInvoice table and Approval details sit in EPApproval table

The link between these two table are :

APInvoice.NoteID

EPApproval.RefNoteID

 

Hope this helps,

Regards,

View original
Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img+11
  • Acumatica Support Team
  • 785 replies
  • Answer
  • June 17, 2022

Hi @apallawala21 

Here are the details you are looking for :

AP Bill details will be in APInvoice table and Approval details sit in EPApproval table

The link between these two table are :

APInvoice.NoteID

EPApproval.RefNoteID

 

Hope this helps,

Regards,


  • Freshman I
  • 3 replies
  • October 21, 2024

Hello,  I have a GI that links the apinvoice table to the approval table using apinvoice.noteid = epapproval.refnoteid, however, the only docs that are included in the GI are the invoices that have been approved/rejected, but if the invoice is not approved, the “approver” field remains blank.  any suggestions?  thanks! 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings