Hi Every one ,
In Item Master ( ECO RES PRODUCT PER COMPANY LIST PAGE ) form i added 2 fields ( using drag nd drop from inventable . display methods ADGQTY / ADGPRICE ) . in Item master new added field is visible but values not showing for the fields for non admin user login and open the item master . if same administator login and open the form means he can see the fields with values ,
here for all users commonly created one role ( GLOBAL LIST ) security Role is assigned , in that roles i added my table (AAA_ITEMDETAILS) with property of table mention delete permission ,
how to add display method from inventtable to give permission in privilege … or any other ways having to give permission to user for accessing the ethods and new table for see the values
this image is for admin user screechot , see ADGPRICE / ADGQTY
second image is for user login here adgprice is / adg qty values is empty …
I don’t see the values for ADGPRICE / ADGQTY in both the screen shots (both screens seems to be the same). Does the Admin really see the values?
Hi Kranthi ,
Sorry image uploaded wrongly for admin user , yes for admin user seeing fields with values
check this image this one is admin user screenshot
What does the method contain? Please show us the code if possible.
[SysClientCacheDataMethodAttribute(true)]
display AGDInventQty AGDQty()
{
AAA_ItemDetails AAA_ItemDetails;
select AAA_ItemDetails
where AAA_ItemDetails.ItemId == this.ItemId
&& AAA_ItemDetails.InventTable == this.RecId;
return AAA_ItemDetails.AGDQty;
}
If you have access to that table, then you should see that data.
What is the NeededPermission property of that control in that form?
(Read) is i mention in form for this 2 fields …
1.) Path: \Security\Roles\GLOBALLIST\Permissions\Tables\Inventtable(Read)access
Path: \Security\Roles\GLOBALLIST\Permissions\Tables\AAA_ITemdDetails\Field names with (READ) access
2.) Path: \Security\Roles\GLOBALLIST\Permissions\Forms\ECO RES PRODUCT PER COMPANY LIST PAGE\ADGQTY , ADGPrice
issues is i have 6 companies , i imported excel to A company … B,C,D,E,F Compnaies not shwoing the field values . if user have A compnay rights he can se records in A company for that item …
What data you have imported? If you imported the data in A, do you expect them see on other companies?
yes i m displaying sistem compnay price nd qty against item id in itemmaster … . for ex item id 1000 is common in all company AB,C,D,E,F Means i want to show for all company itemmaster aginst this item id …
Product is global. Item (InventTable) is a company specific
Is your table company specific or global? Check savedataPerCompany property.
If your table doesn’t saves the data per company (means global). You need to related it with EcoResProduct (not the inventTable)
my table is company specifi … savedata per company is no
If the property value is NO, then it is not company specific table. But inventTable is company specific table.
Add product RecId to your table instead of InventTable RecId and change your code as per that.
Then I can use it in ECORESPRODUCTPERCOMPANYLISTPAGE form for diaply it in item master
if i use yes in my table for savedataper company means … which table can i use . inventtable or ecoresproduct table …?
If you set it to Yes then the data will be specific to a company and you need to have the data for every company and you need to be using InventTable.
ok … thanks i will change it to Eco res product table … now i m using inventtable only …
