Is there any way I can change the lookup at the Company ID login page.

(0) Share

Report

Posted on by scommar

205

Is there any way I can change the lookup at the Company ID login page.

The client has 100+ companies and is used to sorting by ID . Is there any PV I can change so it shows the ID first and then customer can then select the ID first.

Thanks

Sammy

*This post is locked for comments

All responses (3)

Answers (0)

Apps Mexico 1,090 on at

Like (0)

Report

RE: Is there any way I can change the lookup at the Company ID login page.

First you have to modify the store procedure 'company_active' that is on system database. And after that, you have to edit the PV, on a csv file and re-import it with the new changes.

The store procedure and te PV must to be equals.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Is there any way I can change the lookup at the Company ID login page.

There needs to be a SQL "instead of" trigger on tables for SELECT statements... LOL.

We have this same problem. 100+ companies. No filter on the logon screen. And we can't sort on CpnyID.
Adam Leonard 2,151 on at

Like (0)

Report

Re: Is there any way I can change the lookup at the Company ID login page.

Hi Sammy,

This list is populated on the SQL side and I don't think there is a PV list or anything typical taht can be updated.