on 06-02-2015 8:55 PM
Dear friends,
Please can someone help me with the logic or similar codes on how to implement the matrix used to display the G/L accounts in the Item Group.
Item Groups is found under Administration/Setup/Stock Management.
I want to know how they implemented the accounts section that they are displayed that way. It appears that the fields are columns in table OITB and they are showing as rows.
I want to implement a similar scenario in a project.
Please I will be waiting for your immediate answer. Thanks.
The screen shot is attached.
Hi All,
Please someone should help me with this issue.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Olumide,
I was finally able to work a bit on your question and the result is here:
http://scn.sap.com/community/business-one-sdk/blog/2015/06/11/matrix-revisited
Regards,
Eric
Hi Eric,
Thanks for your reply.
I have implemented it. See the version I have. But it still does not look as expected:
I used the formats you asked me to use. What I still don't have here is that the matrix's height does not extend further that this even when I increased the height. I want to hide the scroll bars
Also I want to be able to display header title for the yes/no column just as the first image i attached at the beginning looks like.
Is this also possible?
Thanks for your help so far.
Regards
Hi Olumide,
You have not made the first column as invisible, which will remove the vertical scroll bar.
The horizontal one is due to the fact that you have more than one record to display.
First image, like I wrote in my second answer, is of Layout = 0 with titles filled Inside the first column and not numbers like in the list of items in any of the documents.
Regards,
Eric
Hi Eric,
Now I have done that.
The horizontal scroll bar is blocking the edit area of the last information. I need to remove it. I cannot even use the combo box to pick information in there.
Let me insert the sample guide again. I seriously want it to look like this below:
Again, I want to display account determination in my second tab in my 1st image like this one above.
I want to be able to use choosefromlist and linkbutton in there, and show the description of the account picked. This is the reason I want my columns to display the header caption/title as above.
See that this image does not display horizontal scroll bar. What did they do?
Thanks. Hope to hear from you. Regards
Hi Olumide,
This specific setup of a matrix is used in several places (addresses and contacts pour BP, and so on).
It is "easy" to implement: matrix.Layout = mlt_Vertical;
Regards,
Eric
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Eric,
Thanks for your quick answer.
Could you please check the image i attached again?
There you will find out that it has both rows and columns with caption, and a cell to insert values.
I have just implemented your answer, the column does not have caption.
I also want the row that is displayed vertically to be unenabled i.e look like a label, and the columns same. I also want it to allow me to insert the respective values.
Hope you can help with this also?
Regards
Let me show you what I have. My screen shot is attached
See the matrix under the highlighted tab. I have made the matrix vertical which is ok for me. I want to achieve these additional values:
1. I want it to display header with title e.g "Yes/No"
2. I only want 1 column to display. I dont need the other columns on the right.
3. I want the width to be smaller and tight as it is with the previous screen shot I added at first.
Thanks
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.