Select Grid Businesspartner - Contact persons.
Ronald van Amelsvoort
Hey,I would want to do the following:
For a contact person for a business parter i want to create a letter with coresuite. When I select the BP. and print te letter, i want to use a select grid, for choosing the right contact person. fot the i have made a query wich is th folowing:
SELECT T0.[CardCode], T0.[CardName], T1.[Name] FROM OCRD T0 INNER JOIN OCPR T1 ON T0.CardCode = T1.CardCode WHERE T0.[CardCode] =[%CardCode]
The select grid is presented with the contact person(s) form the selected business partner.
How can I transfer the selected contact person(s) the letter? At this momen I only get the standard contact person.
Hope that someone can help me.
Philipp Knecht
Hi RonaldYou did the first 50%.
Now you need to make a Query like:
[quote] SELECT T0.*,T1.* FROM OCLG T0 INNER JOIN OCRD T1 ON T0.CardCode = T1.CardCode WHERE T0.ClgCode = [%ClgCode]
Of course the ClgCode should be in a column of the SelectGrid.
Then you should have inserted the formtype of your selectgrid into the SWA_LD_FormTypes Table
Then you can add a Parameter with the Key ClgCode to the SWA_LD_Params Table. ItemId is the ColumnName and MatrixId is the Matrix ID which is always "grdSelect" in case od selectgrids.
Then you can press the Button *ParamFormtype" in the Paramsform and select the formtype of the selectgrid.
Then you can make a new Layoutdefinition with the designformtype of the selectgrid and the saved query.
In the parameters - tab you then can press "Get from Datasource" .
hth
0
Please sign in to leave a comment.
Comments
0 comments