We have a few warehouses and we named a certain less frequently used one with a prefix "_OLD_". We wish to not display them on the Sales Order window in the wareshouse dropdown list.
1. We login as System
2. go to Windows Tab and field, search for Sales Order and open the tab.
3. select Order Header in the tab window
4. click on TAB tab got the list and click on Warehouse
5. We are now in the Field window with Name = Warehouse
and now I am lost...
Do I edit the Display Logic? or Default Logic? I want to query anything that is not like '%_OLD_%' Is there a tutorial cover this somewhere online or in any Compiere Resources?
Later on is like also got another bunch of warehouse with prefix "_HIDDEN_" can I combine them together in the logic here to hide both?
Thx so much
You need edit the AD_Column Dynamic Validation...
You need add a New Validation: Name W/O old & hidden
Don't show Store and Distribution :
(INSTR(M_Warehouse.NAME,'Store') < 1 AND INSTR(M_Warehouse.NAME,'Distribution')< 1)
Don't show _OLD_ and _HIDEN_ :
(INSTR(M_Warehouse.NAME,'_OLD_') < 1 AND INSTR(M_Warehouse.NAME,'_HIDEN_')< 1)
From Compiere beyond Compiere
You need another way to take over Compiere
Skype : Adempiere/Compiere
MSN : email@example.com
Free customization Education worldwide service for Top 1000 and MIS over 10 people and Call me
You could try to create a Validation Rule for this column. These are referenced by the Dynamic Validation field on the Column definition window.
Log in to post a comment.