Can someone who has access to source code...suggest a solution to the foll problem i am facing,,,,,,

With regards to the session tfacp2523s000 ......the form 2 has a field tfcmg110.cheq ,i.e check number .


i would like to know how is this field being picked up from the table ...for each record ......

i.e the session is based on tfacp200 table.......but i am not able to know what relation is being used in the script to pick up the tfcmg110.cheq field.


Rgds
Rohan

What version are you running?

Baan IV c4 SP10 doesn't print tfcmg110.cheq it uses a variable field.

Logic looks somewhat the same.

Select tfcmg110 using index 3, selecting with tfacp200.year, tfacp200.btno, tfacp200.typa and tfacp200.doca. It also makes sure that the tfcmg110._compnr = tfgld112.cono.

New logic looks at the tfcmg113 table if it doesn't find a check number in tfcmg110. Select tfcmg113 based on tfcmg113.ttyp = tfacp200.typa and tfcmg113.docn = tfacp200.doca. Once again be sure the tfcmg113._compnr = tfgld112.cono.

Hope this helps
Debbie

hi debbie ,

just to elaborate on my reqs.

i am working on baan 4 sp9.....

i am actually working on a exchange scheme.....

here in i have to get the foll fields :

1. tfacp200.suno
2. tfacp200.isup
3. tfacp200.docd
4. tfacp200.dued
5. tfacp200.amnt
6. tfcmg110.cheq

each of the key for tfcmg110 has a bank field ....the problem is that the corresponding bank field in tfacp200 in my case doesnt have any field value ...so i cant use it in my condition in the exchange scheme to pick up the tfcmg110.cheq .

rgds
Rohan

Not sure what your question is?

The exchange scheme will have a script to do the select, just using the 4 key parts that you have.

ie

select tfcmg110.cheq
from tfcmg110
where tfcmg110._index3 = {:tfacp200.year, :tfacp200.btno,
:tfacp200.typa, :tfacp200.doca}


You can add an as set with 1 rows if needed.

Debbie

hi debbie,

the problem it seems , is that the keys u mentioned dont exist in my system........i.e Baan 4c sp9.

anyways thanks for ur help..

rgds
Rohan

anyone with baan 4c SP09 source code...pls help

There was code introduced with defect 70295 (solution 15490,
1998-08-20, spb40c4_5) and corrected with defect 85619 (solution
75569, 1999-06-18, spb40c4_5) on the second form, where your field is
read/determined based on tfgld112, tfcmg110 and if then still empty
via tfgmc113 (no longer via tfgmc103). Solution 114618 (in spb40c4_9) added the last changes....

Hope this helps.