User_BATEI

No, we are getting help from someone who knows the netsuite backend tables and can create the SQL for this. thanks.

in How to identify Fixed Asset related Additions, Disposals, Transfers, Adjustments from backend tables Comment by User_BATEI Feb 1, 2024 7:08PM

We are enlisting a consultant to craft the proper SQL query for this

in How to identify Fixed Asset related Additions, Disposals, Transfers, Adjustments from backend tables Comment by User_BATEI Feb 1, 2024 3:38PM

We are using NetSuite.com

in How to identify Fixed Asset related Additions, Disposals, Transfers, Adjustments from backend tables Comment by User_BATEI Jan 18, 2024 10:09PM

NetSuite.com

in How to identify Fixed Asset related Additions, Disposals, Transfers, Adjustments from backend tables Comment by User_BATEI Jan 18, 2024 10:08PM

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…

in How to identify Fixed Asset related Additions, Disposals, Transfers, Adjustments from backend tables Comment by User_BATEI Jan 11, 2024 2:36PM

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!

in SuiteAnalytics Connect: How to Identify Accounts Payable on Open Invoices? Comment by User_BATEI Mar 30, 2023 2:34PM

User_BATEI Green Ribbon

Comments