How to create company specific and all company reports

guganvarman_21
guganvarman_21 Member Posts: 16
in NAV Tips & Tricks
Hi

I have to create a report for sales.I have 10 companies in single database.So now i need to create a sales report that includes all the companies data. In case if i need to see the report for single company alone then i should have an option to select the respective company.
By default i need it to get report for all companies.

Thanks
Gugan

Answers

  • SanderDk
    SanderDk Member Posts: 507
    Hi Gugan,
    What i do is create the first dataitem of a report with Company.
    Foreach for the dataitem I use ex CUSTOMER.CHANGECOMPANY(Company.name)
    For help, do not use PM, use forum instead, perhaps other people have the same question, or better answers.
  • guganvarman_21
    guganvarman_21 Member Posts: 16
    Sure SanderDk
    But the thing is Company information table has only that respective companies information.When i select different company and open that company's info table it has only that respective company details.How can i link all the company within one companies database.
  • AK
    AK Member Posts: 226
    It's not the "Company Information" table but the "Company" table, as SanderDk wrote.
  • SanderDk
    SanderDk Member Posts: 507
    @AK is correct :smile:
    It is table 2000000006 - Company
    For help, do not use PM, use forum instead, perhaps other people have the same question, or better answers.

Categories