Hello Loyal subject of baan kingdoms,


i have a question regarding the LN Customer Defined Field,

we tried to use the CDF to fulfill the cust requirement, and we managed to create one field in tisfc001.

but....i can't seem to write the script to display the field, i already write some easy sql script, but the session returned message that it can't find the field.

do you guys/girls know where LN put the field?

Thanks,

Roy

Not played with CDF for the moment, but below some remarks form Infor regarding CDFs.

Customer Defined Fields

Customer Defined Fields (CDF) allow customers to add application fields to the ERP LN applications. It is a matter of configuring additional fields and not doing any application development. This means that no business logic is changed, and no development license is needed to add customer definable fields to the ERPLN Application.

The following restrictions have been defined:

- Tools tables (package tt and tl) can not contain CDFs.
- WebTop conditional formatting is not supported for CDFs.
- Easy SQL is not supported for CDFs.
- EDI is not supported for CDFs.

Except for reporting through the Reporting Studio and the Reporting
Viewer, reporting is not supported for CDFs.

External integrations, such as Infor Integration, EDI, Exchange, Office
integration, and SOA-based integration, do not support CDFs.

CDFs are not supported in program scripts.


Regards,
Juergen

Hello Juergen,


i see, do you know how to display it in the report viewer?


actually the field is available in the database, but i think it's strange for LN to not able to display it.

Roy

Hello Roy,

the new ERP LN report viewer only works with Webtop. Worktop users cannot use report viewer enabled reports.

Please refer to the latest Infor Developers Guide (U8883F - Infor ERP LN Development Tools 8.5) and Infor Webtop 8.5 - Installation and Configuration Guide (U8715 - Infor Webtop 8.5 for ERP LN) for a more and detailed information.

BTW: Also the CDFs are visible in Webtop.

Regards,
Juergen

Hi Elrodyn,

To print a cdf is not a problem, just write a query on the table with the cdf, and fill a var with the cdf and put the var on the layout.
select tisf001.* from tisfc001 where ....
selectdo
var = tisfc001.cdf_...
endselect

it's not possible to put the field directly on a layout.

Regards, Mario