How can I change the below so it displays
"107 - Bushes" instead of just "Bushes" since
the M_Product_Category database table has a
"M_Product_Category_ID" column which
is where I get the "107" from
1. login as GardenAdmin
2. Material Management
3. Material Management Rules
4. Product
5. Product Category = Bushes
Test #1
1. login as SuperUser
2. Window, Tab, & Field
** Window ICON = Product
** Tab ICON = Product
** Field ICON = Product Category
** "Column" = "M_Product_Category_ID_Product Category"
** tried to change to
"ID - M_Product_Category_ID_Product Category"
** failed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
*_ID columns are mostly INTERNAL ID's - supposedly they don't need to be known by final users - just IT people need the ID from time to time.
For IT people you can know the specific ID double-clicking on the lower/right box of the window (m/n record indicator)
This is different from most of the software out there - but it's a GREAT feature.
In software that uses the ID's as the user code - changing a code is a costly operation.
In software like Adempiere with internal ID's - and external codes (this is the intention of "Value" column, aka "Search Key") changing the code known by user is immediate.
Now, to display the "Value + Name" in product category references, you need to go to "Table and Column" and mark the columns:
Name -> Identifier -> Seqno=2
Value -> Identifier -> Seqno=1
How can I change the below so it displays
"107 - Bushes" instead of just "Bushes" since
the M_Product_Category database table has a
"M_Product_Category_ID" column which
is where I get the "107" from
1. login as GardenAdmin
2. Material Management
3. Material Management Rules
4. Product
5. Product Category = Bushes
Test #1
1. login as SuperUser
2. Window, Tab, & Field
** Window ICON = Product
** Tab ICON = Product
** Field ICON = Product Category
** "Column" = "M_Product_Category_ID_Product Category"
** tried to change to
"ID - M_Product_Category_ID_Product Category"
** failed
Hi S L,
*_ID columns are mostly INTERNAL ID's - supposedly they don't need to be known by final users - just IT people need the ID from time to time.
For IT people you can know the specific ID double-clicking on the lower/right box of the window (m/n record indicator)
This is different from most of the software out there - but it's a GREAT feature.
In software that uses the ID's as the user code - changing a code is a costly operation.
In software like Adempiere with internal ID's - and external codes (this is the intention of "Value" column, aka "Search Key") changing the code known by user is immediate.
Now, to display the "Value + Name" in product category references, you need to go to "Table and Column" and mark the columns:
Name -> Identifier -> Seqno=2
Value -> Identifier -> Seqno=1
Regards,
Carlos Ruiz - globalqss
http://globalqss.com