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

Hi all, i am trying to see if the following is possible within SuiteAnalytics Workbook, or really anywhere else in NetSuite without customization:
```- Show all Open Sales Order Lines (Quantity Committed &gt; 0)
- Include information from the linked PO (Special Order or Drop Shipment) from the SO line item
- Include the Bins where each line item's SKU is currently available, and how many are currently on hand in said bin (using Advanced Bin Management)```
I have not been successful, though I've gotten close. I was thinking linked datasets / workbook pivot would be the way to go but that is not working for me. It seems like a reasonable/simple request so I'm curious as to whether I'm missing something or if it's legitimately too complex for native NetSuite to handle.

You know I think I was overthinking it - linked datasets did not work, but a single dataset joined to Inventory Balance table and then put into a pivot worked well enough