My Stuff
Review our AI Community Guidelines before posting AI-generated or AI-assisted content. Verify accuracy and include the appropriate AI disclaimer.
Action Required: Review and submit pending reconciliation matches before the NetSuite upgrade to avoid rework. After 26.2, unsubmitted matches will be unmatched. For more details, see SuiteAnswers 1047397
Explore NetSuite Next with Free Training!
Build your skills with the LCS Explorer Pass.
Visit the NetSuite Next community page
to learn more, ask questions, and share your experience.
Build your skills with the LCS Explorer Pass.
Visit the NetSuite Next community page
to learn more, ask questions, and share your experience.
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!