CHANGECOMPANY won't work?

PaLPiTaTioN

I'm currently developing a report with the following DataItem-structure:

Company (BDRF)
Intercompany Posting Setup (IPS)
    Company (BDRF2)

For each BDRF2, I need to execute the following code:

GlaRecGlb.CHANGECOMPANY(BDRF2.Naam);
GlaRecGlb.GET(IPS."R/C account");
GlaRecGlb.CALCFIELDS("Balance at Date");

These lines should make sure that for each combination of IPS and BDRF2, I can retrieve the value of "Balance at Date" in the G/L Account-table (GlaRecGlb). But somehow, I still see the values for the selected company in Navision, instead of the various values for all companies.

Does someone know what I should do to repair this? If you'd need more input information, just let me know.

i4tost

It is impossible to use calcfield function if you want to calculate data from another company. Use calcums instead of it. If need more info, inform us.

PaLPiTaTioN

Thank you. I also found out that in our company, the table G/L Account is shared, and G/L Entry is not. This means a changecompany on G/L Account would have no effect, so I'll to CALCSUMS on the G/L Entry.