Can anyone help me with the merchandise hierarchy of the items? We have merchandise hierarchy enabled but I can't seem to access it in suiteql. The query "SELECT * from merchandisehierarchyversion" returns an error "Invalid search query. Detailed unprocessed description follows. Search error occurred: Record 'merchandisehierarchyversion' was not found." Do I need to enable any permissions?

@Imad I don't see this as a selectable table in the tables section of the Records catalog even though I can navigate to this table in the catalog via the item table. This might mean that the table isn't available to select from via SuiteQL. I've run into the same issue with Sales Territory. You can submit a ticket to support and either have them file an enhancement or add your name to one if it's pending.

Do you think this would be able via rest api @Clay Roper?

I don't use Web Services, so I'm not sure about that. I'm also not familiar with Merchandise Hierarchy in general, but you should at least be able to query details related to merchandise hierarchy versions that are linked to items via the hierarchyversions field and its related join. See the records catalog page for details (scroll down to see hierarchyVersions)

Do you mean this @Clay Roper? "SELECT * from hierarchyVersions join item on item.id = hierarchyVersions.item" This throws an error Invalid search type: hierarchyVersions."

This is what the records catalog shows as the join for that field. I can't help any further since I don't have this feature enabled.

Thanks, this works