Grid Item ID Assignment

When you use CSV Import for grid purchase order and sales order transactions, the grid item ID assignment for assembly and inventory matrix items depends on the following fields:

Item – This field is located in the CSV Import file.
Grid Item ID – This field is located in the CSV Import file.
Grid Template – This field is located in the CSV Import file.
Available In – This field is located on the Grid Matrix Template page.
Preferred Grid Template – This field is located on the Custom subtab of the item record.

The SuiteApp examines the row sequence of the Item field and its corresponding Grid Template in your CSV Import file.

The row sequence of the Item field determines if they are the same or different items. The row sequence of the Grid Template field determines if the items are grouped or ungrouped.

The value of the Grid Item ID in the item record also depends on the item’s current Preferred Grid Template setup. The grid template must include the order transaction in its Available In field.

To see how grid item ID gets assigned, you may refer to the following table of scenarios:

Scenarios	Grid Template Grouping	Grid Template Applicable? ⁽¹⁾	Sample Item and Grid Template Input in the CSV Import File	Grid Item ID Assignment in the Transaction Record
Three same items with the same template	Grouped	Y	Item A, Grid Template N Item A, Grid Template N Item A, Grid Template N	Grid Item ID 1 Grid Item ID 2 Grid Item ID 3
Three different items with different templates	Ungrouped	Y	Item A, Grid Template N Item B, Grid Template O Item C, Grid Template P	Grid Item ID 1 Grid Item ID 2 Grid Item ID 3
Three different items with the same template	Grouped	Y	Item A, Grid Template N Item B, Grid Template N Item C, Grid Template N	Grid Item ID 1 Grid Item ID 1 Grid Item ID 1
Three different items with different templates Two different items with the same template One different item with a different template in between	Ungrouped	Y	Item A, Grid Template N Item C, Grid Template O Item B, Grid Template N	Grid Item ID 1 Grid Item ID 2 Grid Item ID 3
Three different items with different templates Two different items with the same template One item with a different template	Grouped	Y	Item A, Grid Template N Item B, Grid Template N Item C, Grid Template O	Grid Item ID 1 Grid Item ID 1 Grid Item ID 2
Three different items with the same template Two same items with the same template One different item with the same template	Grouped	Y	Item A, Grid Template N Item A, Grid Template N Item B, Grid Template N	Grid Item ID 1 Grid Item ID 2 Grid Item ID 2
Three different items with different templates Two different items with the same template One different item with no grid template in between	Ungrouped	Y	Item A, Grid Template N Item B, No Grid Template Item C, Grid Template N	Grid Item ID 1 Nongrid ⁽²⁾ Grid Item ID 2
Three different items with different templates Two different items with the same template One item with a grid template that is not applicable to the transaction in between	Ungrouped	N	Item A, Grid Template N Item D, Grid Template is not applicable to the transaction Item C, Grid Template N	CSV Import failure. The system will display an error message in the CSV response.
(1) Grid Template Applicable determines if the Preferred Grid Template used includes the order transaction in the Available In field. (2) Nongrid refers to an item that does not display in grid format.

Scenarios

Grid Template Grouping

Grid Template Applicable? ⁽¹⁾

Sample Item and Grid Template Input in the CSV Import File

Grid Item ID Assignment in the Transaction Record

Three same items with the same template

Grouped

Item A, Grid Template N

Grid Item ID 1

Grid Item ID 2

Grid Item ID 3

Three different items with different templates

Ungrouped

Item A, Grid Template N

Item B, Grid Template O

Item C, Grid Template P

Grid Item ID 1

Grid Item ID 2

Grid Item ID 3

Three different items with the same template

Grouped

Item A, Grid Template N

Item B, Grid Template N

Item C, Grid Template N

Grid Item ID 1

Three different items with different templates

Two different items with the same template
One different item with a different template in between

Ungrouped

Item A, Grid Template N

Item C, Grid Template O

Item B, Grid Template N

Grid Item ID 1

Grid Item ID 2

Grid Item ID 3

Three different items with different templates

Two different items with the same template
One item with a different template

Grouped

Item A, Grid Template N

Item B, Grid Template N

Item C, Grid Template O

Grid Item ID 1

Grid Item ID 2

Three different items with the same template

Two same items with the same template
One different item with the same template

Grouped

Item A, Grid Template N

Item B, Grid Template N

Grid Item ID 1

Grid Item ID 2

Three different items with different templates

Two different items with the same template
One different item with no grid template in between

Ungrouped

Item A, Grid Template N

Item B, No Grid Template

Item C, Grid Template N

Grid Item ID 1

Nongrid ⁽²⁾

Grid Item ID 2

Three different items with different templates

Two different items with the same template
One item with a grid template that is not applicable to the transaction in between

Ungrouped

Item A, Grid Template N

Item D, Grid Template is not applicable to the transaction

Item C, Grid Template N

CSV Import failure. The system will display an error message in the CSV response.

(1) Grid Template Applicable determines if the Preferred Grid Template used includes the order transaction in the Available In field.

(2) Nongrid refers to an item that does not display in grid format.

Related Topics