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

Did they change `inventoryitemlocations`? I use to be able to query the table for assembly quantity on hands. Post 2026.1 upgrade it now returns a null (for my item)

Looks like I can pull the information from `AggregateItemLocation`. Would that be a better table to use? I need OH, Committed, and Available by location.

AggregateItemLocation is correct table for all of these quantities

They seemed to have made some overall changes to ODBC that I can't find were announced anywhere.

I also notice changings in billing and shipping addresses.