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!
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
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
SuiteQL: customer payment query
Hello everyone,
I'm struggling to find a query that returns the information I need.
I'm looking for a query that retrieves all payments from a specific customer where the unapplied amount is greater than 0.
I found the query below but the response is "Invalid search query. Detailed unprocessed description follows. Search error occurred: Field 'unapplied' for record 'transaction' was not found.\n."
SELECT
cp.id AS PaymentID,
cp.trandate AS PaymentDate,
cp.total AS TotalAmount
FROM
transaction cp
WHERE
cp.type = 'CustPymt'
AND cp.voided = 'F'
AND cp.entity = {CustomerID}
AND cp.unappliedamount > 0
ORDER BY
cp.createddate DESC
Does anyone know how I can get the information about the unapplied amount?
0