I am struggling to create a search that returns Customer Deposits with a remaining amount > 0 Can't find a field to use in the filter. Any ideas?

have you tried doing this on saved search first?

Yeah

and the result is?

Nothing worked. Some fields called Amount Remaining and Applied To Link Amount, but they don't return any value.

I've seen this article.. maybe it can help https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_157141180023.html#Track-Customer-Deposit-Balances

Wow, I will sue Oracle.

Alright.. goodluck then 🙂

@Marwan Can you compare "Amount" and "Amount Paid"? I notice that for Customer Deposits which aren't fully applied, Amount Paid is less than Amount. You could also consider using the Status of the CD.

For some reason, I didn't think of the status. My bad.

I notice that for Customer Deposits which aren't fully applied, Amount Paid is less than Amount.

The amount paid is exactly what I wanted, but I couldn't retrieve it in the UserEvent script. It was being retrieved in my scheduled script, but not in the user event, not sure why. Solved it at the end with N/query, with another field.

That's odd - I would expect that if search doesn't get the value in beforeSubmit, query wouldn't either - that maybe all beforeSubmit scripts would need to finish executing before the field is available. Good ol' Netshoot... Glad you figured out a solution!