Hello,
I’m working with NetSuite Analytics Warehouse (NSAW) to create reports and datasets. When I add the dataset for NetSuite - Sales Order, I can see folders such as Inventory Location, Inventory Reporting Location, and Inventory Number, which are critical for my reporting needs.
However, when I switch to the NetSuite - Item Fulfillment dataset, the folder or field for Inventory Number is not visible, even though I expected it to be present.
Questions:
- Is Inventory Number not included in the default Item Fulfillment dataset?
- If not, what is the best way to include or join the Inventory Number field with the Item Fulfillment dataset in NSAW?
- Could this issue be related to how data relationships or schemas are configured in NSAW or NetSuite?
I would appreciate any guidance on how to:
- Verify if the Inventory Number field is available in the backend NetSuite schema for Item Fulfillment.
- Extend the NSAW semantic model to include this field if it is missing by default.
- Confirm if this is expected behavior or a configuration issue.
Thank you in advance for your help!