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

This is what I see in my Records Catalog.. Why would these fields be unavailable?  I need to access the Locations table from the Transaction Lines table….

Do you have Advanced Item Location Configuration enabled?

The only ones marked unavailable in my records catalog are the few associated with features we don't have enabled. Is anything available in your table?

It is enabled. I wonder if another feature supersedes that when it comes to table structure. I have the fields available when I join through Serial/Lot Numbers &gt; Locations but that doesn’t seem to pull data since I’m looking at items that aren’t serialized

<@U0262UG4YMC> Do you get any insight into what's required when you hover over the :no_entry_sign:  symbol in the _Available_ column?

<@U0262UG4YMC> That's `aggregateItemLocation` - what do you see under `inventoryItemLocations` from the Item record?

<@U0262UG4YMC> looking over your screenshots again, I see that where the environment I work in has `inventoryItemLocations` as the Locations join from the Item record, yours has `aggregateItemLocation` which is likely due to different features being activated. If you review your original screenshot again, you'll see that the unavailable fields you posted are under `inventoryItemLocations` and there's another `quantityAvailable` under `aggregateItemLocation` as shown below.

Thanks Clay, I’ll take a look in a minute..  These table changes based on enablements are both interesting and frustrating!