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 Ronald

You 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