Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
SQL to pull in Revenue Committing Transaction:Internal ID
We are using ODBC Connector from NetSuite to Access database and creating a Revenue Waterfall report. We need to SQL to link the Sales Order Revenue Commitment and the Invoice. We can find the field in the UI>Transaction search, Type = Sales Order> Field - Revenue Committing Transaction: Internal ID but cannot find the field in the Schema. Basically, I’m looking for the SQL statement that says this “invoice” transaction is linked to this revenue commitment line(s). In the UI>Transaction Search, Type = Sales Order> Field - Revenue Committing Transaction: Internal ID