When using SuiteQL - has anyone experienced a problem where the REST API does not return the correct # of rows from the API? For instance - with

TransactionAccountingLine

I can do a

SELECT COUNT(*) FROM TransactionAccountingLine where transaction = X

Which returns say, 32 - but when I actually run

SELECT * FROM TransactionAccountingLine where transaction = X

I get fewer than 32 rows. This is not for all transactions - and its pretty random when it happens.

Perhaps I’m missing something - but what edge case are you talking about?

the documentation goes over how count(*) behaves differently from normal selects

Yes - but they’re missing rows regardless. I don’t think it’s an edge case with

COUNT

as the missing rows exist in Netsuite - I just can’t access them.

as in you added up accounting impacts and they dont match the lines from your query?

Yes.

cant really tell more without seeing the data

That’s what I thought as well - but the weirdest thing is that it’s not the same transactions each time - so I don’t think it’s a permissions issue. I can tell they exist.