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!
NetSuite Admin Tip | Joining Employees and Vendors in Purchase Order Using SuiteQL
When working with SuiteQL to analyze Purchase Orders, you may want to include additional information about related Entities (e.g., Vendors) and Employees (e.g., Sales Reps). However, not all Purchase Orders are associated with an Employee, so it's important to structure your joins correctly.
This guide demonstrates how to build a SuiteQL query that pulls Purchase Orders along with:
- The Entity (Vendor) information — always required.
- The Employee information — if available.
INNER JOIN vs LEFT OUTER JOIN:
- INNER JOIN (Entity): Ensures that only transactions with a valid associated entity are returned. This is appropriate for the Entity join, as all
Richard James Uri - SuiteCloud | WMS Tech | SuiteCommerce Advanced
----
- New to NetSuite
- Explore the NSC Webinars Category
- Join our poll and share your ideas! We want to know what you think. Don't forget to comment and make your voice heard!
- Expand your NetSuite knowledge by joining this month's Ask A Guru Live about Basic Accounting. RSVP on this event now!