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 ?