Retrieving Data from Navision

tfranzen
tfranzen Member Posts: 25
Hi!

I have the challenge to retrieve data from about 30 different companies (one NAV-Database) and to validate data into NAV at runtime. The external application knows which company to use but I have no idea how to tell NAV to change into the appropiate company when validating the data. Has anyone a good idea?

Thomas

Comments

  • JoeK
    JoeK Member Posts: 53
    Hi,

    which application should validate the data, NAV or the external?
    If its Navision just use the changecompany method...

    Greetings
  • nunomaia
    nunomaia Member Posts: 1,153
    What method are you using?


    Changecompany it is tricky because validate trigger happens in current company.
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • ta5
    ta5 Member Posts: 1,164
    Changecompany is not a good idea if the validate code uses other tables they happen in the unchanged company (as nunomaia said).
    Depending on what you want achieve you could write the data into import tables in every company. Changecompany works fine here. After importing you can use another process (ExpandIT LaunchUtility for example) to start the posting or whatever in each respective company.

    Hope this helps

    Thomas