I ask your help concerning the following:
On an invoice matrix I want to check all Itemgroup Codes of all items in the rows, if there are some rows' items with ItemGroupcode 101 and some others with anything else, then header field should be Y, otherwise N.
My main problem is: how do I put a matrix row data to a header data with checking all rows in the matrix?
A minor problem is that I can't get the formatted search to work on all rows when the formatted search is assigned to the user field in header.
If I put the formatted search to a row field then the row field is filled with the proper value, but the same query assigned to the user field in header works only on the first row.
What am I doing wrong?
Any suggestions are welcome.
I believe this is a shortcoming in SAP Business One. You cannot work with formatted searches in the way you are trying to. You cannot retrieve data from all rows and sum them (for example) into a header field. If you work with a matrix, the selected row will be used.
You can only accomplish what you want if the data is already stored in the database then you do a query where you extract the values directly from the database.
Hope it helps,