Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Using SuiteQL, I wish to get the source Estimate transaction that created the Sales Order.
Within NetSuite's reporting features I can get the source transaction of a Sales Order using 'createdfrom'. I need to know the Estimate transaction related to the Sales Order from with SQL. transaction.sourcetransaction is always null.
The report I'm trying to create is to show the detail of an estimate that has been converted into a Sales Order. this solution will eventually end up in a script, thus I'm avoiding the report writer.
Thank you in advance for any assistance that can be provided.
Tagged:
0