Has anyone observed queries to return a different ...
# suiteql
a
Has anyone observed queries to return a different number of records based on which fields are `SELECT`ed? I am seeing multiple fiscal year
AccountingPeriods
concurrently, but if I do
SELECT *
(instead of a subset) half of them are filtered out. Wondering if this isn't an active bug on NetSuite's end
s
Add the fields one at a time, and see how the counts change with each field. It might be a permissions issue.