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

I'm working on migrating an ODBC query to the SuiteQL, i'm trying to find this table in odbc `transaction_inventory_numbers` but I'm not able to find a replacement for it in SuiteQL.  I'm trying to grab ItemFullfillments/ItemReceipts assigned Inventory Numbers for those transactions. Anyone find that table, been trying different permutations and no joy so far.

Well of course once I ask the question i figure it out&gt;
`inventoryassignment` is the table you want