Skip to Content

System Form Manipulation

Hi All,

I am new to SAP Business One.

I created a new Folder in System Form(Item Master) Under That I created a Matrix.(with the help of System Form Manipulation in SDK Samples)

My Issue is I need to Store the Matrix data Based on the Item Code .also I need to Display the Matrix Data Based on the Item Code Selected(while Find or Update).I don't know how to handle data load as well as System Add and Update Button.(For that Matrix I bind DB Data Source UDo as Document Rows).

Please Help me.

Thanks in Advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 26, 2017 at 03:03 PM

    Hi,

    I can`t provide you your full solution as this is not the goal of the forum. I can give you some steps of what you have to do and you can explore by yourself and ask specific questions here or even find already answered questions.

    For the event you should use Form_Data_Load beforeAction = false

    To show your matrix and save the possible changes you have plenty of options to use. I wouldn`t use UDO bind because it is a standard form which is already binded to an object and you will not really get the advantages of using UDO as the automatically form manipulation functions. So here two options

    - Using a matrix: You create a datatable run a query and bind to your Matrix to show your data, the user do whatever you need in this matrix and in order to save you FlushToDatasource the matrix, read the datatable and save your records using DI (You can find more for UDO looking for GeneralServices) or UserTable if it is not UDO.

    - Using a grid: Basically is the same idea, but instead of matrix you will use a grid, it depends of what you need to do.

    From my understanding I would use matrix in this case.

    Add comment
    10|10000 characters needed characters exceeded