Need help to find Payment GroupID


I have been asked to update a dashboard showing invoices details, by adding the Payment GroupID. I found the table CheckHed where I can see the Payment GroupID and check num etc. But I do not know how to reference it with the APInvHed info (PONum, Invoice GroupID )

So I must be missing a relationship somewhere … I need to assing the Payment Group ID to my APInvHed record in my BAQ.

The payment tracker shows the Group:

Can anyone help ?



Groups are mainly used for grouping transactions before posting, after that the group is deleted.

APInvHed - Invoice Header
CheckHed - Payment Header
APTran - Payment Transaction Detail

You can join them using APTran.InvoiceNum and APTran.CheckNum

Thanks Jonathan, exactly what I was looking for ! Did the job!