Good Afternoon Sage Guru's!
To make a long story short...I have a connection to Sage from MS PowerBI currently and my dashboard is simply a table that is simply being refreshed and updloaded to my dashboard so that I can search on PO, Vendor, or item Description. I am also showing PO Date, line item number, units, price(line item) and extended amount along with AcctID; all being sorted by POID. I would also like to have the 'sName' field from the 'tproject' table, however, I can't figure out the relationship back to the PO (tpurordr) table. When I initially brought in the 'tproject' table it wanted to make an automatic relationship to the 'tpurordr' table via 'lid', which obviously isn't correct.
I know I probably haven't provided some key piece of information that someone will need but thought I would start with the above.
Any guidance would be greatly appreciated!