My Stuff
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.
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!