My Stuff
Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.
Intelligent Payment Automation version 1.0.3 is now available in the SuiteApp Marketplace. The SuiteApp, powered by BILL, lets you automate payments, manage vendor details, and bank account information within NetSuite. Learn more
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!