Hey All. I'm trying to select purchase orders that are associated with an item. I can see the PO's on the "related records" tab when i view the item. I have tried finding it view the "NextTransactionLineLink" table (via Tim's blog), but it doesn't show up there either . Any hidden tables or tricks available to get at that "related records" list?

Why don't you just start at transaction table and join to the item record off the transactionLines??

That's a possibility that i could try. I'm basically trying to create a query for my users that all they need to do is input the item name and display all quantity fields (avail, committed, .. ) at each warehouse location, then tie that to any purchase orders that have not been received. Also joining in container information that are on custom records.

•

transactionline

+

transaction

will give you data for your open POs •

inventorybalance

should give you what you need for inventory balances •

custom-container-record-id

for whatever you need regarding that custom record Join with your item id, whether as one query, or pulling separate queries and filtering in script