Can develop report including two company?

Business Central/NAV Developers Forum
1

Dear Everybody

I’m sorry, my english is not very good.

Have a way that ? Can develop report including two company in NAV 2013 ? Currently in NAV Database i have supply company and a distribution company. I want to receive statistical quantity and sales volume over the same reporting.

Looking forward to the help from everyone.

Thanks so much.

2

-hi

You can do if you have data that is shared along all companies, or you’d have to do it outside of NAV ,like Reporting Services / SQL .

g.

3

Thanks faludigabor for reply.

4

If both the company are in the same database your requirement can be fulfilled with CHANGECOMPANY function on record variables to retrieve data from a different company.

5

Thanks Daniele Rebussi

You can give a code that illustration? Thank so much

6

This compare accounts between two companies (assuming of course you have the same P&L):

GLAccount.SETAUTOCALCFIELDS(Balance);

IF GLAccount.FINDSET THEN

REPEAT

GLAccount2.CHANGECOMPANY(Company2);

GLAccount2.GET(GLAccount.“No.”);

GLAccount2.CALCFIELDS(Balance);

UNTIL GLAccount.NEXT = 0;

7

Thanks Daniele Rebussi very much.