Need Help In Company Filterring!!

Becka

hi all

So.. I have a problem.. The situation is: I have an SQL database workin' with NAV, with different companies in it. So, i need to filter the database, with the different company names, and calculate balance for each company... So, i need a help.. How to make this from C/AL??


Thanks to all

Konrad

Check help for CHANGECOMPANY.

Waldo

Indeed, you can do this with CHANGECOMPANY, but also by creating a view in SQL Server and creating a linked table in NAV... .

Becka

okay.. i'll make an example: so.. I'm workin' in Cronus company database, and i want to calculate a balance in "Other company", from Cronus company database.. what i gotta do for that???

Waldo

Something like:

recCustomer.CHANGECOMPANY('Other Company');
recCustomer.GET('Your Customer No.');
recCustomer.CALCFIELDS("Balance");
MESSAGE('Here is your balance: %1', recCustomer.Balance);

didn't test this though

Try to read the help of CHANGECOMPANY.

Becka

But is that the way i need?? Can i calculate by this way the balance of Cronus Company, from "myCompany" that i'm workin' in.

Waldo

It is one way to do it.
Just try it out

DenSter

Becka wrote:

But is that the way i need?? Can i calculate by this way the balance of Cronus Company, from "myCompany" that i'm workin' in.

Yes you can calculate it like that. Why don't you give it a try and see if that is what you want?

Becka

And can you tell me 'bout other ways? how to solve this problem...

Waldo

As I said, creating views in SQL Server, and link them with tables in NAV. But this solution slightly more difficult to post ... and I only recommend it when it's absolutely necessary ... .

Becka

okay.. i'll try this one.. thanks

DenSter

Make sure you have a second client session into the other company to check the values of your data.