My Stuff
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
Comments
-
No, we are getting help from someone who knows the netsuite backend tables and can create the SQL for this. thanks.
-
We are enlisting a consultant to craft the proper SQL query for this
-
We are using NetSuite.com
-
So, via the NetSuite backend tables we import into snowflake with FiveTran (Ex. Transactions and transaction_lines), we have built a balance sheet, and can therefore using Transactions and transaction_lines) tables, show a beginning and ending balance for any period, related to Fixed Asset specific accounts. What we need…
-
So sorry, We derive that column "is_accounts_payable" per the below sql code: lower(accounts.type_name) like 'accounts payable%' Per your response, it looks like we are both resolving the same way, but I like your code better. Thanks!