By using this website, you agree to our Terms of Use (click here)
We are trying to create a Generic Inquiry that lists the approver for the PO. The Approver looks like it is in DAC EPApproval, but when I look there, I can't find any way to link it to the POOrder. My best guess is there is another "table" that is in between the two and links them together or maybe it is linking GUID columns. Whatever it is doing, I can't find it. Does anyone have experience with this kind of linking or have any suggestions on where to look?
Hey DWS253,
Try POOrder.NoteID = EPApproval.RefNoteID.
I would be concerned though about doing this join because Acumatica is setup to allow multiple approvers and, if that ever happens, you're going to duplicate your data.
Online Members
