mnmhema
4th March 2013, 10:42
Turnover data based on years are found under the session tfacp2521s000. I tried to find the corresponding table field data using Edit View form command. It is given as total.tovr
I can see that this is a variable and gives some summarized filed value. I cannot locate the field.
Please help me where I can find the field ( under which table).

jclju1
4th March 2013, 12:34
Open session and drag "?" on this filed.

EdHubbard
4th March 2013, 13:25
We are on the MCR extension so it doesn't work too well for us, but I see fields in tccom010 for turnover. tccom010.tovr#1 to 15

Hope that helps

Ed

BaanInOhio
4th March 2013, 19:00
Probably tccom123, Invoice-from Business Partner Balances. Stored by BP, company, and department with amounts starting with the current year.

mnmhema
5th March 2013, 12:12
The table tccom123 has Invoice Balance and Order Balance.
It doesn't have Turnover of Last years details.

benito
5th March 2013, 13:42
the variable could be a calculated field, so it might not have direct relationship to any field.

BaanInOhio
5th March 2013, 15:49
What version of Baan / LN?

If Baan5 or LN, the fields in tccom123 are 'tovr', 'tovr_1',' tovr_2', 'tovr_3' and 'tovr_4'. The "tfacpdll0051.turnover.for.supplier" function that is called to fill the fields in tfacp2521s000 (found by printing objects by program script) use these fields.