RC2020
(Miguel Lopez)
1
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.
Miguel
tsmith
(Tyler Smith)
2
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