Filter on Company

DrZoidberg

Hi,

I'm sure this is a pretty simple question.

I need to filter the Job list form by a new field ("Use for Cross Charging") that has been added to the Company table to enable Cross Charging across all companies.

Is this possible? We have a Company Code field on the Job table.

I'm pretty new to this side of Navision.

Thanks J.

neilgf

Hello! I am not sure what you are trying to achieve. You can only view the job table data when logged into each company business. So what is the purpose of the field? Are you trying to identify which company a job in company A should be charged to?

geordie

It's not clear to me too, but seems you have just to add this code in OnOpenForm trigger:

CompanyInfo.GET;
FILTERGROUP(10);  //Doesn't allow users to remove filter
SETRANGE("Use for Cross Charging",CompanyInfo."Use for Cross Charging");
FILTERGROUP(0);