Is there any special function in Baan to do so ? I have a query that updates the field : cisli240.corn. I would need to pass that value in my select statement so it points out the proper financial company any suggestion? I need to get value of finance company before I pass my select statement below.


select cisli240.*
from cisli240 for update
where cisli240.slso = {:l.orno} and
cisli240._compnr = 620 | {:cisli240.sfcp}
selectdo
if not isspace(l.corn) then
cisli240.corn = l.corn
endif
if not isspace(l.refa) then
cisli240.refa = l.refa
endif
if not isspace(l.refb) then
cisli240.refb = l.refb
endif
db.update(tcisli240,db.retry)
commit.transaction()
endselect

Hi,

You can use tables tcmcs065 and tcemm124 to know the finance company of your current company.

Just check those table and build a function/dll. It's a simple logic you can build on your own.

Or use this DLL:-

tcemm.dll1002.get.finan.comp.of.entity(
domain tcncmp i.logistic.comp,
domain tcemm.enty i.entity.type,
domain tcemm.enio i.entity,
ref domain tcncmp o.financial.comp)

Thanks bhushanchanda. I will try your suggestions.