0

API:

https://tstdrv243232323232.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql?limit=1000

query:

SELECT * 
FROM Transaction 
INNER JOIN TransactionAccountingLine 
  ON ( TransactionAccountingLine.Transaction = Transaction.ID ) 
INNER JOIN Account 
  ON ( Account.ID = TransactionAccountingLine.Account ) 
where Account.accttype IN('AcctPay') 
  AND BUILTIN.DF( Transaction.Entity ) IS NOT NULL 
  AND (Transaction.DueDate<='12/29/2021') 
  AND ( Transaction.Posting = 'T' ) 
  AND ( Transaction.Voided = 'F' ) 
  AND (( TransactionAccountingLine.AmountUnpaid <> 0 ) 
    OR ( TransactionAccountingLine.PaymentAmountUnused <> 0 )) 
ORDER BY Transaction.TranDate ASC

Related screenshot

2ps
  • 15,099
  • 2
  • 27
  • 47
GSV
  • 1
  • 2
  • Most likely something in your WHERE is filtering those lines out of the result. Try removing one condition at a time and re-run the query to check. My guess would be AcctType for the currency revaluation lines is not AccPay and you need to add another value to the IN(). Keep checking to see which condition(s) is/are the issue. – Brian Dec 30 '21 at 16:14
  • I agree with @brian, but I think the culprit could be the `TransactionAccountingLine.AmountUnpaid` and `TransactionAccountingLine.PaymentAmountUnused`, since I don't believe these fields exist on a Currency Revaluation Transaction. – Pierre Plourde Jan 05 '22 at 14:52
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. – Community Jan 12 '22 at 06:44

0 Answers0