Record Access Exclude problem


Use case :
1) created VIP pricelist for GardenWorld Admin role
2) set a personal lock exclude for GardenWorld User ( so only admin can use VIP pricelist )
3) created an Customer Invoice with VIP pricelist

4) log in as GardenWorld user
5) opened customer invoice

problems :
pricelist is empty and mandatory to change/select value so the user cant move to next record and gets stucked.

patch :
I just keep value in field (no trigger change) and set field readonly , user cant see what value is selected and cant zoom in locked record at the other hand can move to next record or continue to work with document.
( this was required behaviour from a client )




Carlos Ruiz
June 4, 2019, 8:34 AM

It looks like duplicate of

Michal Zilincar
June 4, 2019, 1:21 PM

yes you are right , result for the user is the same. There is a field with a value without value of that field in the lookup.
I see there are probably several ways how to achieve it. In my patch I am checking if the reason is caused by record access limitation. But maybe I can take it out and whatever is the reason for missing value, just disable field and do not allow to trigger change on that field.

Not sure If it is correct way, I will play with scenarios mentioned in other tasks

Hiep Lq
August 13, 2019, 2:22 AM

go to "Physical Inventory" click "create inventory counter list" the dialog display with only head
because NPE when load "produc category" by logic change from this ticket

other things:
code on WTableDirEditor.setValue

if (col.get_ID() > 0) {
String refTable = col.getReferenceTableName();
MTable table = MTable.get(Env.getCtx(), refTable);
refTableID = table.getAD_Table_ID();

should use MQuery.getZoomColumnName, MQuery.getZoomTableName


Michal Zilincar


Michal Zilincar



Tested By



Fix versions

Affects versions