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!
Looking for amountunpaid field and SQL Help
thanks for the help with this:
https://community.oracle.com/netsuite/discussion/4473899/how-can-i-search-for-balance-due/p1?new=1
related:
V1: this returns 1 unique record with this added: and tal.transactionline = tl.id
--> but needed "amountunpaid" field is missing
{ "q": "SELECT * FROM transaction t LEFT JOIN transactionline tl ON t.id = tl.transaction LEFT JOIN transactionaccountingline tal ON t.id = tal.transaction LEFT JOIN account ac ON ac.id = tal.account where tl.custcol1 IS NOT NULL and t.posting = 'T' and tl.uniquekey = xxxxx and tal.transactionline = tl.id "
}
---
V2: this returns 2 records (dupe uniqueid unwanted) without this added: and tal.transactionline = tl.id
Tagged:
0