Skip to Content

System Form Manipulation

May 24, 2017 at 11:58 AM


avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Danilo Kasparian May 26, 2017 at 03:03 PM


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.

10 |10000 characters needed characters left characters exceeded