This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Is it possible to query Fixed Asset transactions through SuiteQL?

what I found is, I can query BG Summary Records and FAM Depreciation History and find related Journals. But will it give the whole list or is there a separate way?

I'm not familiar with FAM transactions but could you query transaction lines  and join on transaction and filter the transaction type to be FAM transacton record type as transaction.recordtype

FAM transactions are posted as Journal Entries, but it is not easy to build a logic (at least for me) to distinguish Journal based on different FAM Transactions

are the journal entries tagged to the asset? If they aren't a custom transaction then you can check the asset field is not null