Setting Up Grid Templates
You can set up a grid matrix or grid item template for assembly and inventory items. Use grid matrix templates for matrix items, or grid item templates for either matrix and nonmatrix items.
Read the following topics for more information about each of these templates:
Guidelines for Setting Up Grid Templates
Note the following guidelines when setting up grid templates:
-
Grid Order Management can optimally handle up to 1000 matrix templates and 1000 item templates. In NetSuite OneWorld accounts where items can be shared by multiple subsidiaries, you can set up a maximum of 1000 grid templates for better performance of the grids.
-
Grid templates can support a maximum of 200 values as grid attributes. To determine if a grid template exceeds the maximum number set for grid attributes, multiply all values specified for each grid attribute. You cannot create grid templates for parent items with more than 200 grid attributes.
For example, a parent matrix item that has 195 subitems contains the following attributes:
-
26 colors
-
3 sizes
-
3 fabrics
In this example, a total of 234 attributes can be derived from multiplying all values specified for each grid attribute. The total exceeds the maximum number of grid attributes for a matrix template. Therefore, you cannot create a grid matrix template for this parent matrix item. The system displays an error message when the matrix template you want to create exceeds the maximum number set for grid attributes.
-
-
Only matrix items with two or more attribute sets are supported. You can edit an item record to add more attributes to a parent matrix item. For more information, see Editing Matrix Items.
When you add or remove an attribute of a matrix item, you must also refresh the grid matrix template associated to the item record. To get the updated matrix items for the grid matrix template, go to Lists > Grid Order Entry > Grid Templates. Click Edit beside the template. Click Get Item, then click Save.
-
You can only create grid matrix templates for parent matrix items that contain child matrix items.
-
You cannot create new grid matrix and grid item templates using CSV Import and SOAP web services.
-
For consistency, avoid changing the names of used grid templates. Template names shown in associated transactions are not updated automatically when the template names are changed. However, if you change a template name, it is shown in new grid line items that you add to associated transactions. This behavior results in transactions where line items use the same template but display either the previous or updated name. Names that are shown in line items are also used for printouts generated through standard grid order printing only.
For limitations of Grid Order Management in general, see Limitations of Grid Order Management.