This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hello.
I am trying to perform a query to get `Customer Payments` data. Any clue of where I can find it?? I checked Transactions and not succesfull...

<@U02JF1ZJ2GJ> You can find them in the Transaction table, with "CustPymt" as the type. For example, `SELECT TOP 10 * FROM Transaction WHERE Type = 'CustPymt'`

super thanks <@U856E2SEA>, I just had to enable the transaction permission in the role :slightly_smiling_face:

Any clue on where to find Credit Memos payment data? CC <@U856E2SEA> :pray:tia

<@U02JF1ZJ2GJ> Those are also in the Transaction table. Their type is: CustCred