Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
How to pull the Shipping Address using ODBC?
Hi. I am using SuiteQL ODBC to show transaction details through the transaction, transactionLine, and entity tables from NetSuite2.
FROM transaction A
INNER JOIN transactionLine B ON B.transaction = A.ID
LEFT OUTER JOIN item C ON B.item = C.id
LEFT OUTER JOIN entity D ON B.entity = D.id
I am able to get all my transaction details I need (customer, parent, item, etc.), but I cannot find what table to join to that does not produce null results for address, city, state, & zip. I accomplished this from NetSuite1 through the transaction_address table, but I am hitting nothing but walls with NetSuite2. Is anyone able to help?