RE: SuiteQL – Query Credit Memos

Hi All,

I’m new to using SuiteQL and am trying to query open credit memos. I’ve followed some other resources which say I should be able to query with something like this:

SELECT
Transaction.ID AS TransactionID,
Transaction.TransactionNumber,
Transaction.TranID,
Transaction.Type,
Transaction.TranDisplayName,
Transaction.TranDate,
Transaction.CreatedDate,
Transaction.DueDate,
Transaction.DaysOpen,
Transaction.ForeignTotal,
Transaction.ForeignAmountUnpaid,
Transaction.PaymentHold,
BUILTIN.DF( Transaction.CreatedBy ) AS CreatedBy,
BUILTIN.DF( Transaction.Status ) AS Status,
BUILTIN.DF( Transaction.BillingStatus ) AS BillingStatus,
BUILTIN.DF( Transaction.Terms ) AS Terms,
Transaction.Memo,
Transaction.ApprovalStatus,
Vendor.ID AS VendorID,
Vendor.AltName AS VendorName,
FROM
Transaction
INNER JOIN Entity AS Vendor ON
( Vendor.ID = Transaction.Entity )
LEFT OUTER JOIN EntityAddress AS VendorAddress ON
( VendorAddress.nkey = Transaction.BillingAddress )
WHERE
( Transaction.Type IN ( ‘VendBill’, ‘VendCred’ ) )
AND ( Transaction.Void = ‘F’ )
AND ( Vendor.AltName = ‘VendorName’)
AND ( Transaction.ForeignAmountUnpaid <> 0 )
( Transaction.ID = 212765032001)

 

However, when I do I don’t see any VendCred records even if I strip it down and just have a where clause on the vendor. Any tips on where I’m going wrong?

Thanks

corycalavan Rookie Asked on February 6, 2024 in SuiteAnalytics.
Add Comment
4 Answers

Hi,

Do you get anything if you just run it with “( Transaction.Type IN ( ‘VendBill’, ‘VendCred’ ) )” in the WHERE clause?

Thanks,

Chris

Intermediate Answered on February 8, 2024.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.