Go Back > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor


Google search

How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 40

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 17th April 2018, 07:29
Premahari Premahari is offline
Join Date: Mar 2018
Posts: 63
Premahari is on a distinguished road
Baan: InforLN 10.5 - DB: SQL Server - OS: Windows
Adding Business partner type in Buisness partner detail session
Baan: ERP LN 6.1 FP11 (Infor ERP 10.5)
C/S: Both

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.
Reply With Quote
Old 17th April 2018, 10:04
JaapJD's Avatar
JaapJD JaapJD is offline
Join Date: Sep 2002
Location: Netherlands
Posts: 811
JaapJD will become famous soon enoughJaapJD will become famous soon enough
Baan: BaanIV, BaanERP, ERP LN 6.1 - DB: Oracle, SQL Server - OS: Unix, Windows
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.
Reply With Quote
Sponsored Links
Old 18th April 2018, 07:05
Premahari Premahari is offline
Join Date: Mar 2018
Posts: 63
Premahari is on a distinguished road
Baan: InforLN 10.5 - DB: SQL Server - OS: Windows
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.
Reply With Quote
Old 18th April 2018, 15:20
giggty's Avatar
giggty giggty is offline
Senior Member
Join Date: May 2017
Posts: 116
giggty is on a distinguished road
Baan: Infor ERP 10.6 - DB: MSSQL Server 2008 R2 - OS: Windows Server 2012
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.
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
About Business Partner alex_hu Finance, Invoicing and Integration 2 14th October 2005 09:01
Contact by Business partner mostrightfuture Tools Development 0 17th August 2004 11:45
One time business partner changing riazsayeed Distribution, Transportation & Warehousing 5 16th July 2004 16:45
session of BP attached to a role savitr Tools Development 2 10th May 2004 13:47
Payment of blocked supplier pmahto Finance, Invoicing and Integration 1 11th September 2003 21:36

All times are GMT +2. The time now is 16:03.

©2001-2018 - -