Need help to find Payment GroupID

ERP 10
,
1

Hello,

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:

image
image1656×256 18.8 KB

Can anyone help ?

thanks

Pierre

2

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

3

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

Pierre