Premahari
17th April 2018, 07:29
Hi Iam trying to add business partner type which is taken from table tccom110 in business partner overview session. I added the business partner type in form editor(tccom110.cbtp). But it's showing Blank. How to show the type of business partner.

JaapJD
17th April 2018, 10:04
Create a session extension. Add a table selection for tccom110, select field cbtp and code the where-clause: tccom110.ofbp = tccom100.bpid. Note that this only will work if all your business partners have the sold-to role, otherwise the business partner overview will not show the business partners without sold-to role. If not all business partners have the sold-to role, create instead of the table selection a calculated field of type 'nested select' and code

select tccom110.cbtp from tccom110 where tccom110.ofbp = tccom100.bpid

See the Extensions Development Guide for more information.

There is no need to copy the session to your own VRC and to change the form definition. The field will be automatically added to the overview. With form personalization you can put the field in the desired location.

Premahari
18th April 2018, 07:05
I don understand where to write that code. That is standard session where I'm adding tccom110.cbtp in form editor to see the type of business partner in overview session(tccom4500m000). Its showing field with BP Type But no values it was blank. I gave the reference field in form editor for that field as tccom100.bpid,tccom110.ofbp. I think it has multiple reference.

giggty
18th April 2018, 15:20
Premahari, create an extension for business partner overview session in ttext1500m000 (if you have not created any extensions so far, you should initialize it in ttext0200m000 first) and do what JaapJD said. Refer to Infor LN Extensions Development Guide if you are not familiar with Application Extensibility.