This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hello There, how can i connect ACCOUNTS table into CUSTOMERS table using sql?

Looks like you can link the account table to the customer table by using customer.accountnumber = account.id

There are a few account fields on the customer table, so it depends which one you want

I need this for the Journal transaction i need to get the NAME &amp; ACCOUNT

Both of those will be tagged on the transactionlines table for that transaction id - what have you tried so far?

Thank you SAM but i already use that table *TRASACTION_LINES* account yes can get in *TRASACTION_LINES* but customer name cannot so i need to use *ENTITY* table for that or *CUSTOMERS* table but one thing my concern how can i connect this table into *TRASACTION_LINES ?*