Hi everyone- does anyone have any experience with pulling ALL transactions that affect the general ledger through suiteQL? I am trying to figure out permissioning right now, and would love to chat to anyone who has worked on anything similar 🙂

You'll be wanting to look at TransactionAccountingLine - When i had problems seeing transaction/transactionline etc before, it was the Transaction Detail->View and Find Transaction->View permissions that needed adding

There are a few queries here that might help: https://timdietrich.me/blog/netsuite-suiteql-general-ledger-impact-by-transaction-type/ The first query in that post will give you a list of the transaction types that are posting to the GL. With that, you can assign the detailed permissions that you'll need. This might help as well: https://timdietrich.me/blog/netsuite-suiteql-transaction-table/

This is amazing! Thank you 🙂