Hello,

i need checkbox on sales order monitor session which shows production order is generated or not?how can this be done using extensibility?
sales order monitor session has tdsls413 as main table and production order is present tdsls402 table.i am on LN 10.5.

One way is to add CDF to tdsls413 table, but it would require implementing a thorough update logic for it (e. g. it has to be switched off when the respective order gets deleted or something like that). Another one which is more simple (and if you only need a tick on the form then it fits right in) would be to add a calculated field to the sales order monitor session and to write a simple select for populating its value.

Hello,

I am having production order as field.i am using simple expression i can show this value but i need checkbox,tick will indicate production order exists.
let say if sales order JAN00001/1/1 has one production order MO00001 then
it has to show tick and not the actual Production order no.


Thanks & Regards,
Rahul Ingale

You need to specify a tcyesno domain for your calculated field, then it should be displayed as tick on/off.

I tried but it shows yes and no value as drop-down and not checkbox.
I use nested selected expression type with domain tgyenox.

How so, calculated fields are readonly :confused: I have just tested it, works like it supposed to.

Can you show screenshots please?

I think KB 1987753 in InforXtreme can help you.

Hello,

Please find attachment.calculated fields are read only,i was meant it does not look like checkbox.

Actual logic for calculated field.

Check session ttgfd4520m000 whether tgyenox is to be displayed as checkbox. Alternative is to use tcyesno as giggty already mentioned

Domain values are 1 (yes) and 2 (no).

i tried using tcyesno,it is not displaying as checkbox.
it show listoutput field developer tools of IE also.
does it regarding any workbench,browser or java update missing?



<div class="ListOutputField" id="tdsls4510m100-68-grid-4-ext.mo.created-0-widget" style="width: 100%; height: 100%; line-height: 1.8em;"><label class="Label" id="tdsls4510m100-68-grid-4-ext.mo.created-0-widget-label">Yes</label></div>

Sorry, I was unable to reproduce your situation :(

If you remove all the properties of the field except the domain, will it make the difference?

Hello,

it is not working,it is not showing checkbox.
i had one doubt does configurable field can be seen when
running becs or webtop.in LNUI it shows all calculated field
on configurable tab,does some changes needed to shown in becs.

Hmm, I'm not sure calculated fields are supported elsewhere apart from LN UI.

It seems you are rather far behind with applying tools solutions. You need at least 10.5.1. Check whether you have 1864452 installed. After installation you need to generate and compile your extension (either by pressing that button in the Extension Modeler or making a change and save).
But your code needs some improvement as well. Checking on empty apdo is not very robust, using value 0 and 1 is not correct and you should not use the colons in a nested select query. I would code it like this:

select case count(*) when 0 then 2 else 1 end
from tdsls402
where tdsls402._index1 = {tdsls413.orno, tdsls413.pono, tdsls413.sqnb}
and tdsls402.apdo <> ""

Thanks Jaap and giggty for input.LN enviornment is on 10.5 with tiv 2100.