Hello all, im curious if there are any SQL experts...
# generala
Alex Geller
04/14/2025, 6:54 PMHello all, im curious if there are any SQL experts in the group? we use ODBC connection 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 help.
r
RJMNS
04/14/2025, 9:50 PMWhat are you looking for specifically? I made some pretty heavy use of the Records Catalog (Setup>Records Catalog.
r
Rachael
04/15/2025, 11:00 AMWhat's the concern?
a
Alex Geller
04/15/2025, 12:29 PMwe use ODBC to pull inventory flow data over to excel. our pending sales and pending receipts columns are not showing data after changing the SQL statements to use the NS2 fields.
r
Rachael
04/15/2025, 1:17 PMHow are they sourced using the NetSuite.com source?
Is this is a out of the box column or a calculation in your SQL?
a
Alex Geller
04/15/2025, 1:27 PMi belive its a calculation in my sql
Alex Geller
04/15/2025, 1:31 PMhere is an example of Open PO (pending receipts) and Pending Sales Order (pending sales). Old SQL and New SQL.
Alex Geller
04/15/2025, 1:32 PMid be happy to pay you for your time if you are experienced in this.