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
Hi
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,
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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.