Sample Query to Execute in Reporting Tool:
select acct.type_name as Type, acct.name as Name, sum(post.amount) as Amount
from accounts acct inner join posting_account_activity post
on acct.account_id = post.account_id
where acct.is_balancesheet='T' and post.amount <> '0'
and post.accounting_period_id between 1 and 26
or post.accounting_period_id between 36 and 51
group by acct.is_leftside, acct.type_name, acct.name
order by acct.is_leftside desc
big help thanksReplyDelete
in netsuite2 datasourse is there a table similar to posting_account_activity post? where you can obtain all of that info?