What is the difference between Grid and Matrix in SAP B1?

Question

When should I use a Matrix and when should I use a Grid?

Answer 1

In short: Grid is faster in certain situations, but matrix is more versatile (at least in Sbo version 2007 and before). Chech out the Sap SDN forums on https://www.sdn.sap.com/, they are big source of information.

Answer 2

Hi, when you want to work with UDOs, use matrix, otherwise use grid.

Some differences.

Matrix

• to load the data you need Dbdatasource
• effective for Udo's
• Filled automatically by SAP b1 when your navigate

Grid

• you can load the data using a SQL Query.
• Has Problems with columns of type double (you must use a workaround for this)
• you cannot modify udo data (just for viewing) - can't link to UDO
• you can create levels of visualitation (extend/collapse rows)
• grid is much faster with linking large ammount of data

Bye.