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!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
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?