This article explains what you can and cannot do with NetSuite matrix items in ExtendInsights for Data Management, including how to reference matrix items on transactions.
Limitations when working with matrix items
Certain matrix functions are specific to the NetSuite UI and are not exposed through the NetSuite SOAP Web Services APIs used by ExtendInsights. As a result:
Creating matrix items is not supported
Matrix item creation is a NetSuite UI workflow and cannot be performed through ExtendInsights.
Editing matrix “matrix-level” attributes is not supported
Updates to matrix dimension fields such as Color, Size, or other matrix option structures are not feasible via ExtendInsights.
Our product is evolving fast, so be sure to check back.
What is supported
1) Updating existing matrix child items
You can update matrix items the same way you update standard inventory or non-inventory items as long as the records already exist.
Recommended approach:
Create or load an Item template (Inventory Item or Non-Inventory Item).
Retrieve the matrix child items using one of the following:
Data Filter
Saved Search
Reload/Refresh records
Update supported standard/custom fields.
Upload the changes back to NetSuite.
Notes:
This applies to standard fields and custom fields on the child item record.
The update behaves like an item record update (not a matrix definition update).
2) Using matrix items on transactions
When adding a matrix item to a transaction, you must use the child item, not the parent.
Example:
If you sell a specific variation, such as a blue sweatshirt, select the child item (for example,
Sweatshirt - Blue) on the transaction line.
Need help?
Use the in-app chat