CHANGECOMPANY won't work?

PaLPiTaTioN
PaLPiTaTioN Member Posts: 55
edited 2004-07-15 in Navision Attain
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.

Comments

  • i4tost
    i4tost Member Posts: 208
    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
    PaLPiTaTioN Member Posts: 55
    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.

Categories