Hello all, im curious if there are any SQL experts in the group? we use ODBC connection for Excel and with the update from netsuite.com to netsuite2.com having some trouble with our queries. A different external team has been working on it without luck. looking to this group for assistance. we attempted to convert our fields to the new NS2 fields with each statement, but not receiving data in for pending sales or pending receipts in our spreadsheet columns. thanks in advance.

Are you relying on the Status field to get Pending Sales/Pending Receipt? Unfortunately that field has differing values. Instead of using "friendly" values like Pending Sales, it uses a single letter to represent them. Here's the query I used to get the "old" values.

select type,BUILTIN.DF(type),status,BUILTIN.DF(status), count(*)
from TRANSACTION
group by type,BUILTIN.DF(type),status,BUILTIN.DF(status)
order by type,BUILTIN.DF(type),status,BUILTIN.DF(status)