Solved

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

  • 17 June 2022
  • 1 reply
  • 18 views

Userlevel 1

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 

icon

Best answer by vkumar 17 June 2022, 13:15

View original

1 reply

Userlevel 7
Badge +8

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,

Reply


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 — 2022  Acumatica, Inc. All rights reserved