Hello,
Edit and update: It looks like the cutoff date is somewhere in March 24/25, 2023, which is when the 2023.1 release of Netsuite came out. Is that possibly related?
I am facing a strange issue querying Transaction Accounting Lines through both the SuiteQL suitelet and through the JDBC driver. I am using the latest JDBC driver (8.10.170).
When I query
select count(*) from transactionaccountingline where lastmodifieddate > to_date('2023-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
To get the count of all transaction accounting lines since 2023-01-01, I get about 228K results.
When I query
select count(*) from transactionaccountingline where lastmodifieddate <= to_date('2023-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
To get a count of all transaction accounting lines before or on that date, I get 0 results.
However, when I query
select count(*) from transactionaccountingline
To get all results, I get about 690K results, many more than I got in the first query.
It appears that I have about 400k records which I cannot access by querying in SuiteQL or via JDBC. I used the count(*) function as an example here, but this behavior also happens when I try to select records or individual fields. I can see that the total number of records is higher, but for some reason I cannot select any before 2023.