I’m trying to join an Invoice to the Sales Order t...
# suiteanalyticse
eblackey
10/29/2021, 4:02 PMI’m trying to join an Invoice to the Sales Order that it was created from using SuiteQL. I’m finding that the “sourcetransaction” field is not populated and I don’t see any other fields on the transaction table that joins these tables.
eblackey
10/29/2021, 4:03 PM Copy code
SELECT
inv.id,inv.sourcetransaction
from transaction inv
where rownum <= 100
and inv.sourcetransaction IS NOT NULLt
tdietrich
10/29/2021, 4:07 PM@eblackey This might help: https://timdietrich.me/blog/netsuite-suiteql-related-transactions/
🙌 1
e
eblackey
10/29/2021, 4:10 PMThank you! I guess the sourcetransaction column has been abandoned.
m
michoel
10/30/2021, 9:58 PMI think sourcetransaction is for revenue elements