Skip to Content
avatar image
Former Member

Difference between Grid and Matrix in UI

Hello,

I am newer to UI Development in SBO.

can someone explain the difference?

Is that documented? Where?

When is it necessary/better to use one or the other?

Thank you

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Aug 24, 2010 at 11:51 AM

    Hello

    matrix is the historical item of SAP B1. (you see in marketing documents where you enter positions). it is very good for data editing

    it can be

    - connected to any data sources (UDO, User Defined datasource, System related datasources, datatables) and for UDOs can be managed automatically the savings.

    - robust, can can be managed fully (validations, data editing etc).

    - column visiblity and edit purposes can be managed by Form Settings

    I use this 80%, especially when i has to save data into the database (UDO, UDT, UDF, ETC).

    Grid is a newer object in SAP B1, is it very good for visualization (you see in MRP Wizard, expand / Hide )

    - very fast, can be loaded from datatable

    - can be hierarchical (expanding / Groupping/ etc).

    I use this for reports, or just for presenting a result of a Query for Hierarchical purposes, not so comfortable for editing/ saving data

    each 2 objects is well documented in the SDK help, and you can find samples in the installed help application

    C:Program FilesSAPSAP Business One SDKSamplesCOM UIVB.NET06.MatrixAndDataSources

    C:Program FilesSAPSAP Business One SDKSamplesCOM UIVB.NET19.Grid

    regards

    János

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I could install B1DE 2.1 in Visual Studio 2010 after recompiling all source projects and seems ok.

      If I want to create a form with a matrix is it necessary to create a master data/master row or document / document row UDO with at least two table (father and child). Can you confirm this?

      Can't I create a matrix with Sap Business One UDO Form Generator with a single table?

      In the matrix generated with an UDO having 2 table, the functionality to add new lines / delete them is to develop by code ad hoc? Are the 2 buttons (add line, delete line) without functionality?

      Thank you

  • avatar image
    Former Member
    Aug 18, 2010 at 05:23 PM

    Hi,

    You may check this: what-is-main-differnce-between-matrix-and-grid-how

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded