How to Display GL Associated to PO on Open Purchase Order Dashboard

Hello Everyone,

I have an Open Purchase Order Dashboard and purchasing was the associated GL that appears on the purchase order (TranGLC.GLAccount)

How do create the relationship so it will pull the information on the dashboard?

Thanks in Advance.


You will need to join PORel to TranGLC using the following fields:

  • TranGLC.RelatedToFile = ‘PORel’ (filter on TranGLC table)
  • TranGLC.Company = PORel.Company
  • TranGLC.Key1 = PORel.PONum
  • TranGLC.Key2 = PORel.POLine
  • TranGLC.Key3 = PORel.PORelNum

That worked.

Thank you.