Multi-plant user security

Yahoo Archive
1
Miguel,

I tried testing your BAQ phrase setup below but when I went to not allow
a plant in the user security setting, then that plant was also no longer
available in the Dashboard to view or select in the tracker. Seems like
your phrase builder still uses standard Epicor plant security access. I
am pulling in the Warehse.Plant, Warehse.WarehouseCode, and
Warehse.Description fields.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Miguel Santillan
Sent: Friday, January 04, 2013 4:30 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Multi-plant user security





Perhaps,

for each PartBin no-lock , each Part no-lock where (PartBin.Company =
Part.Company and PartBin.PartNum = Part.PartNum ) , each Warehse no-lock
where (PartBin.Company = Warehse.Company and PartBin.WarehouseCode =
Warehse.WarehouseCode ).

PartBin
Whse (Plant)
Part

Part Bin still gives you your Onhand...but I am not sure what fields you
are using in the PartWhse to display.

This is still a different BAQ though.

Miguel A. Santillan
Compass Components, Inc.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Chang, Chia
Sent: Friday, January 04, 2013 1:44 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Multi-plant user security

Without making any changes to the current BAQ and the Warehse table
link, is there any other way to allow standard Epicor security for plant
access to allow viewing multi-plant data in a dashboard but not give the
user access to other plant's menu items?

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Arul Shankar
Sent: Friday, January 04, 2013 3:33 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Multi-plant user security

Don't link the Warehse table. Once you link any table which has Plant
field in it then it will go through standard Epicor security for plant
access.

Regards,
Arul
________________________________
From: "Chang, Chia" cchang@... <mailto:cchang%40apog.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Saturday, 5 January 2013 8:21 AM
Subject: RE: [Vantage] Multi-plant user security

The BAQ has the Warehouse table linked to the PartBin table which is
then linked to the Part table. We want to be able to pull in data from
the Warehse.WarehouseCode and Warehse.Plant field.

________________________________

From: mailto:vantage%40yahoogroups.com
[mailto:mailto:vantage%40yahoogroups.com] On Behalf
Of Arul Shankar
Sent: Friday, January 04, 2013 2:54 PM
To: mailto:vantage%40yahoogroups.com
Subject: Re: [Vantage] Multi-plant user security

PartBin table which stores Qty on Hand bypasses plant security since it
doesn't store plant value. By using PartBin table, write a BAQ and
display the QOH from multi-plant. If you can identify the plant id from
warehouse code, then add that as a formula in the BAQ so that plant id
can be displayed.

Regards,
Arul

________________________________
From: "Chang, Chia" mailto:cchang%40apog.com >
To: mailto:vantage%40yahoogroups.com
Sent: Saturday, 5 January 2013 5:42 AM
Subject: RE: [Vantage] Multi-plant user security

The query is pulling in multiple warehouses that are in multiple plants.
There is not a current plant criteria that I can see that could be
affecting this. Are warehouses in different plants affected by user
security access too?

________________________________

From: mailto:vantage%40yahoogroups.com
[mailto:mailto:vantage%40yahoogroups.com] On Behalf
Of Miguel Santillan
Sent: Friday, January 04, 2013 10:28 AM
To: mailto:vantage%40yahoogroups.com
Subject: RE: [Vantage] Multi-plant user security

You can create the query so that it is not based on Cur-Plant.
Essentially don't make Cur-Plant a criteria.

The out of the box trackers for inventory are plant restricted.

So Yes.

Miguel A. Santillan
Compass Components, Inc.

From: mailto:vantage%40yahoogroups.com
[mailto:mailto:vantage%40yahoogroups.com ] On
Behalf Of Chang, Chia
Sent: Friday, January 04, 2013 7:21 AM
To: mailto:vantage%40yahoogroups.com
Subject: [Vantage] Multi-plant user security

Does anyone know if it is possible to allow a user access to view
multi-plant part on hand qty in a dashboard but not allow them access to
multi-plant menu items? If we allow the user access to multi-plant in
their user security settings, it also allows them to possibly make
transactions in another plant which we do not want. Is there a way to
allow a user multi-plant access in a dashboard but not multi-plant main
menu or is this a limitation with multi-plant user security access?

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
2
Has anyone had to blank out all the active user account passwords in Epicor? I know I can go into each user account, just thought there may be an easier way to do it.

The reason I'm doing this is we don't use single sign-on for our test environment. I've got an old backup I'm using for testing 701, at least 1 user password change prompt since this backup.

Jenn
3
I have not used the updateable BAQs (still on version 8.03.409C), but can you do one on the user file and check the clear password box for each?

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jennifer
Sent: Wednesday, January 02, 2013 12:43 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Mass Clear Passwords



Has anyone had to blank out all the active user account passwords in Epicor? I know I can go into each user account, just thought there may be an easier way to do it.

The reason I'm doing this is we don't use single sign-on for our test environment. I've got an old backup I'm using for testing 701, at least 1 user password change prompt since this backup.

Jenn



[Non-text portions of this message have been removed]
4
Thanks Karen - excellent answer! I keep forgetting about updateable BAQs, gotta stop going old school!
5
If you are on SQL, you can write a simple command to update all of the
fields to be empty.

Even in Progress you could do the same with a BPM and 4GL.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jennifer
Sent: Wednesday, January 02, 2013 1:43 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Mass Clear Passwords

Has anyone had to blank out all the active user account passwords in Epicor?
I know I can go into each user account, just thought there may be an easier
way to do it.

The reason I'm doing this is we don't use single sign-on for our test
environment. I've got an old backup I'm using for testing 701, at least 1
user password change prompt since this backup.

Jenn



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
6
Ned,
I am SQL, wasn't sure if it was just the one field or something else happened in the background (and if "" would suffice). I ended up calling up all users, flipping to the list tab and checking the "clear password" box there.
Jenn

--- In vantage@yahoogroups.com, Ned <TechnoBabbly@...> wrote:
>
> If you are on SQL, you can write a simple command to update all of the
> fields to be empty.
>
> Even in Progress you could do the same with a BPM and 4GL.
7
I have created an Updatable dashboard for users.
It allow me to "mass" update various settings on the users.
I built it mainly to import users, but doing what you are looking for could also be done.

If you are on Vantage, you could look at the list view for the users and if the the field is not shown, you could make it available.

Bruce


--- In vantage@yahoogroups.com, "Jennifer" <Jennifer.Lisser@...> wrote:
>
> Has anyone had to blank out all the active user account passwords in Epicor? I know I can go into each user account, just thought there may be an easier way to do it.
>
> The reason I'm doing this is we don't use single sign-on for our test environment. I've got an old backup I'm using for testing 701, at least 1 user password change prompt since this backup.
>
> Jenn
>
8
Just the one field and "" works just fine.

I don't generally recommend going back end to SQL for much of anything, but
this is one time when it's not that tough to get done, I do it all the time
for customers who send me their DB but forget to give me a username and
password or the password to their manager account so I can test.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
lisserjm
Sent: Wednesday, January 02, 2013 5:00 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Mass Clear Passwords

Ned,
I am SQL, wasn't sure if it was just the one field or something else
happened in the background (and if "" would suffice). I ended up calling up
all users, flipping to the list tab and checking the "clear password" box
there.
Jenn

--- In vantage@yahoogroups.com, Ned <TechnoBabbly@...> wrote:
>
> If you are on SQL, you can write a simple command to update all of the
> fields to be empty.
>
> Even in Progress you could do the same with a BPM and 4GL.




------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
9
Does anyone know if it is possible to allow a user access to view
multi-plant part on hand qty in a dashboard but not allow them access to
multi-plant menu items? If we allow the user access to multi-plant in
their user security settings, it also allows them to possibly make
transactions in another plant which we do not want. Is there a way to
allow a user multi-plant access in a dashboard but not multi-plant main
menu or is this a limitation with multi-plant user security access?





[Non-text portions of this message have been removed]
10
You can create the query so that it is not based on Cur-Plant. Essentially don't make Cur-Plant a criteria.

The out of the box trackers for inventory are plant restricted.

So Yes.

Miguel A. Santillan
Compass Components, Inc.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chang, Chia
Sent: Friday, January 04, 2013 7:21 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Multi-plant user security



Does anyone know if it is possible to allow a user access to view
multi-plant part on hand qty in a dashboard but not allow them access to
multi-plant menu items? If we allow the user access to multi-plant in
their user security settings, it also allows them to possibly make
transactions in another plant which we do not want. Is there a way to
allow a user multi-plant access in a dashboard but not multi-plant main
menu or is this a limitation with multi-plant user security access?

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
11
The query is pulling in multiple warehouses that are in multiple plants.
There is not a current plant criteria that I can see that could be
affecting this. Are warehouses in different plants affected by user
security access too?



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Miguel Santillan
Sent: Friday, January 04, 2013 10:28 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Multi-plant user security





You can create the query so that it is not based on Cur-Plant.
Essentially don't make Cur-Plant a criteria.

The out of the box trackers for inventory are plant restricted.

So Yes.

Miguel A. Santillan
Compass Components, Inc.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Chang, Chia
Sent: Friday, January 04, 2013 7:21 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Multi-plant user security

Does anyone know if it is possible to allow a user access to view
multi-plant part on hand qty in a dashboard but not allow them access to
multi-plant menu items? If we allow the user access to multi-plant in
their user security settings, it also allows them to possibly make
transactions in another plant which we do not want. Is there a way to
allow a user multi-plant access in a dashboard but not multi-plant main
menu or is this a limitation with multi-plant user security access?

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
12
PartBin table which stores Qty on Hand bypasses plant security since it doesn't store plant value. By using PartBin table, write a BAQ and display the QOH from multi-plant. If you can identify the plant id from warehouse code, then add that as a formula in the BAQ so that plant id can be displayed.
Â
Regards,
Arul


________________________________
From: "Chang, Chia" <cchang@...>
To: vantage@yahoogroups.com
Sent: Saturday, 5 January 2013 5:42 AM
Subject: RE: [Vantage] Multi-plant user security


Â

The query is pulling in multiple warehouses that are in multiple plants.
There is not a current plant criteria that I can see that could be
affecting this. Are warehouses in different plants affected by user
security access too?

________________________________

From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf
Of Miguel Santillan
Sent: Friday, January 04, 2013 10:28 AM
To: mailto:vantage%40yahoogroups.com
Subject: RE: [Vantage] Multi-plant user security

You can create the query so that it is not based on Cur-Plant.
Essentially don't make Cur-Plant a criteria.

The out of the box trackers for inventory are plant restricted.

So Yes.

Miguel A. Santillan
Compass Components, Inc.

From: mailto:vantage%40yahoogroups.com
[mailto:mailto:vantage%40yahoogroups.com ] On
Behalf Of Chang, Chia
Sent: Friday, January 04, 2013 7:21 AM
To: mailto:vantage%40yahoogroups.com
Subject: [Vantage] Multi-plant user security

Does anyone know if it is possible to allow a user access to view
multi-plant part on hand qty in a dashboard but not allow them access to
multi-plant menu items? If we allow the user access to multi-plant in
their user security settings, it also allows them to possibly make
transactions in another plant which we do not want. Is there a way to
allow a user multi-plant access in a dashboard but not multi-plant main
menu or is this a limitation with multi-plant user security access?

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]
13
The BAQ has the Warehouse table linked to the PartBin table which is
then linked to the Part table. We want to be able to pull in data from
the Warehse.WarehouseCode and Warehse.Plant field.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Arul Shankar
Sent: Friday, January 04, 2013 2:54 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Multi-plant user security





PartBin table which stores Qty on Hand bypasses plant security since it
doesn't store plant value. By using PartBin table, write a BAQ and
display the QOH from multi-plant. If you can identify the plant id from
warehouse code, then add that as a formula in the BAQ so that plant id
can be displayed.

Regards,
Arul


________________________________
From: "Chang, Chia" cchang@... <mailto:cchang%40apog.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Saturday, 5 January 2013 5:42 AM
Subject: RE: [Vantage] Multi-plant user security




The query is pulling in multiple warehouses that are in multiple plants.
There is not a current plant criteria that I can see that could be
affecting this. Are warehouses in different plants affected by user
security access too?

________________________________

From: mailto:vantage%40yahoogroups.com
[mailto:mailto:vantage%40yahoogroups.com] On Behalf
Of Miguel Santillan
Sent: Friday, January 04, 2013 10:28 AM
To: mailto:vantage%40yahoogroups.com
Subject: RE: [Vantage] Multi-plant user security

You can create the query so that it is not based on Cur-Plant.
Essentially don't make Cur-Plant a criteria.

The out of the box trackers for inventory are plant restricted.

So Yes.

Miguel A. Santillan
Compass Components, Inc.

From: mailto:vantage%40yahoogroups.com
[mailto:mailto:vantage%40yahoogroups.com ] On
Behalf Of Chang, Chia
Sent: Friday, January 04, 2013 7:21 AM
To: mailto:vantage%40yahoogroups.com
Subject: [Vantage] Multi-plant user security

Does anyone know if it is possible to allow a user access to view
multi-plant part on hand qty in a dashboard but not allow them access to
multi-plant menu items? If we allow the user access to multi-plant in
their user security settings, it also allows them to possibly make
transactions in another plant which we do not want. Is there a way to
allow a user multi-plant access in a dashboard but not multi-plant main
menu or is this a limitation with multi-plant user security access?

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
14
Don't link the Warehse table. Once you link any table which has Plant field in it then it will go through standard Epicor security for plant access.Â
Â
Regards,
ArulÂ
________________________________
From: "Chang, Chia" <cchang@...>
To: vantage@yahoogroups.com
Sent: Saturday, 5 January 2013 8:21 AM
Subject: RE: [Vantage] Multi-plant user security


Â

The BAQ has the Warehouse table linked to the PartBin table which is
then linked to the Part table. We want to be able to pull in data from
the Warehse.WarehouseCode and Warehse.Plant field.

________________________________

From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf
Of Arul Shankar
Sent: Friday, January 04, 2013 2:54 PM
To: mailto:vantage%40yahoogroups.com
Subject: Re: [Vantage] Multi-plant user security

PartBin table which stores Qty on Hand bypasses plant security since it
doesn't store plant value. By using PartBin table, write a BAQ and
display the QOH from multi-plant. If you can identify the plant id from
warehouse code, then add that as a formula in the BAQ so that plant id
can be displayed.

Regards,
Arul

________________________________
From: "Chang, Chia" mailto:cchang%40apog.com >
To: mailto:vantage%40yahoogroups.com
Sent: Saturday, 5 January 2013 5:42 AM
Subject: RE: [Vantage] Multi-plant user security

The query is pulling in multiple warehouses that are in multiple plants.
There is not a current plant criteria that I can see that could be
affecting this. Are warehouses in different plants affected by user
security access too?

________________________________

From: mailto:vantage%40yahoogroups.com
[mailto:mailto:vantage%40yahoogroups.com] On Behalf
Of Miguel Santillan
Sent: Friday, January 04, 2013 10:28 AM
To: mailto:vantage%40yahoogroups.com
Subject: RE: [Vantage] Multi-plant user security

You can create the query so that it is not based on Cur-Plant.
Essentially don't make Cur-Plant a criteria.

The out of the box trackers for inventory are plant restricted.

So Yes.

Miguel A. Santillan
Compass Components, Inc.

From: mailto:vantage%40yahoogroups.com
[mailto:mailto:vantage%40yahoogroups.com ] On
Behalf Of Chang, Chia
Sent: Friday, January 04, 2013 7:21 AM
To: mailto:vantage%40yahoogroups.com
Subject: [Vantage] Multi-plant user security

Does anyone know if it is possible to allow a user access to view
multi-plant part on hand qty in a dashboard but not allow them access to
multi-plant menu items? If we allow the user access to multi-plant in
their user security settings, it also allows them to possibly make
transactions in another plant which we do not want. Is there a way to
allow a user multi-plant access in a dashboard but not multi-plant main
menu or is this a limitation with multi-plant user security access?

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]
15
Without making any changes to the current BAQ and the Warehse table
link, is there any other way to allow standard Epicor security for plant
access to allow viewing multi-plant data in a dashboard but not give the
user access to other plant's menu items?



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Arul Shankar
Sent: Friday, January 04, 2013 3:33 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Multi-plant user security





Don't link the Warehse table. Once you link any table which has Plant
field in it then it will go through standard Epicor security for plant
access.

Regards,
Arul
________________________________
From: "Chang, Chia" cchang@... <mailto:cchang%40apog.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Saturday, 5 January 2013 8:21 AM
Subject: RE: [Vantage] Multi-plant user security



The BAQ has the Warehouse table linked to the PartBin table which is
then linked to the Part table. We want to be able to pull in data from
the Warehse.WarehouseCode and Warehse.Plant field.

________________________________

From: mailto:vantage%40yahoogroups.com
[mailto:mailto:vantage%40yahoogroups.com] On Behalf
Of Arul Shankar
Sent: Friday, January 04, 2013 2:54 PM
To: mailto:vantage%40yahoogroups.com
Subject: Re: [Vantage] Multi-plant user security

PartBin table which stores Qty on Hand bypasses plant security since it
doesn't store plant value. By using PartBin table, write a BAQ and
display the QOH from multi-plant. If you can identify the plant id from
warehouse code, then add that as a formula in the BAQ so that plant id
can be displayed.

Regards,
Arul

________________________________
From: "Chang, Chia" mailto:cchang%40apog.com >
To: mailto:vantage%40yahoogroups.com
Sent: Saturday, 5 January 2013 5:42 AM
Subject: RE: [Vantage] Multi-plant user security

The query is pulling in multiple warehouses that are in multiple plants.
There is not a current plant criteria that I can see that could be
affecting this. Are warehouses in different plants affected by user
security access too?

________________________________

From: mailto:vantage%40yahoogroups.com
[mailto:mailto:vantage%40yahoogroups.com] On Behalf
Of Miguel Santillan
Sent: Friday, January 04, 2013 10:28 AM
To: mailto:vantage%40yahoogroups.com
Subject: RE: [Vantage] Multi-plant user security

You can create the query so that it is not based on Cur-Plant.
Essentially don't make Cur-Plant a criteria.

The out of the box trackers for inventory are plant restricted.

So Yes.

Miguel A. Santillan
Compass Components, Inc.

From: mailto:vantage%40yahoogroups.com
[mailto:mailto:vantage%40yahoogroups.com ] On
Behalf Of Chang, Chia
Sent: Friday, January 04, 2013 7:21 AM
To: mailto:vantage%40yahoogroups.com
Subject: [Vantage] Multi-plant user security

Does anyone know if it is possible to allow a user access to view
multi-plant part on hand qty in a dashboard but not allow them access to
multi-plant menu items? If we allow the user access to multi-plant in
their user security settings, it also allows them to possibly make
transactions in another plant which we do not want. Is there a way to
allow a user multi-plant access in a dashboard but not multi-plant main
menu or is this a limitation with multi-plant user security access?

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
16
Perhaps,

for each PartBin no-lock , each Part no-lock where (PartBin.Company = Part.Company and PartBin.PartNum = Part.PartNum ) , each Warehse no-lock where (PartBin.Company = Warehse.Company and PartBin.WarehouseCode = Warehse.WarehouseCode ).

PartBin
Whse (Plant)
Part


Part Bin still gives you your Onhand...but I am not sure what fields you are using in the PartWhse to display.

This is still a different BAQ though.


Miguel A. Santillan
Compass Components, Inc.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chang, Chia
Sent: Friday, January 04, 2013 1:44 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Multi-plant user security



Without making any changes to the current BAQ and the Warehse table
link, is there any other way to allow standard Epicor security for plant
access to allow viewing multi-plant data in a dashboard but not give the
user access to other plant's menu items?

________________________________

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Arul Shankar
Sent: Friday, January 04, 2013 3:33 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Multi-plant user security

Don't link the Warehse table. Once you link any table which has Plant
field in it then it will go through standard Epicor security for plant
access.

Regards,
Arul
________________________________
From: "Chang, Chia" cchang@...<mailto:cchang%40apog.com> >
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Sent: Saturday, 5 January 2013 8:21 AM
Subject: RE: [Vantage] Multi-plant user security

The BAQ has the Warehouse table linked to the PartBin table which is
then linked to the Part table. We want to be able to pull in data from
the Warehse.WarehouseCode and Warehse.Plant field.

________________________________

From: mailto:vantage%40yahoogroups.com
[mailto:mailto:vantage%40yahoogroups.com] On Behalf
Of Arul Shankar
Sent: Friday, January 04, 2013 2:54 PM
To: mailto:vantage%40yahoogroups.com
Subject: Re: [Vantage] Multi-plant user security

PartBin table which stores Qty on Hand bypasses plant security since it
doesn't store plant value. By using PartBin table, write a BAQ and
display the QOH from multi-plant. If you can identify the plant id from
warehouse code, then add that as a formula in the BAQ so that plant id
can be displayed.

Regards,
Arul

________________________________
From: "Chang, Chia" mailto:cchang%40apog.com >
To: mailto:vantage%40yahoogroups.com
Sent: Saturday, 5 January 2013 5:42 AM
Subject: RE: [Vantage] Multi-plant user security

The query is pulling in multiple warehouses that are in multiple plants.
There is not a current plant criteria that I can see that could be
affecting this. Are warehouses in different plants affected by user
security access too?

________________________________

From: mailto:vantage%40yahoogroups.com
[mailto:mailto:vantage%40yahoogroups.com] On Behalf
Of Miguel Santillan
Sent: Friday, January 04, 2013 10:28 AM
To: mailto:vantage%40yahoogroups.com
Subject: RE: [Vantage] Multi-plant user security

You can create the query so that it is not based on Cur-Plant.
Essentially don't make Cur-Plant a criteria.

The out of the box trackers for inventory are plant restricted.

So Yes.

Miguel A. Santillan
Compass Components, Inc.

From: mailto:vantage%40yahoogroups.com
[mailto:mailto:vantage%40yahoogroups.com ] On
Behalf Of Chang, Chia
Sent: Friday, January 04, 2013 7:21 AM
To: mailto:vantage%40yahoogroups.com
Subject: [Vantage] Multi-plant user security

Does anyone know if it is possible to allow a user access to view
multi-plant part on hand qty in a dashboard but not allow them access to
multi-plant menu items? If we allow the user access to multi-plant in
their user security settings, it also allows them to possibly make
transactions in another plant which we do not want. Is there a way to
allow a user multi-plant access in a dashboard but not multi-plant main
menu or is this a limitation with multi-plant user security access?

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]