Hi, Can anyone help me, I have created custom field in Stock Item - IN202500 and retrieve data from from Attribute - CS205000. but, not showing data. bellow screen capture in stock item screen and my DAC
Answer
Create Custom field PXSelector retrieve data from Attribute - CS205000
Best answer by DipakNilkanth
Hi
Please use the code snippet below.
Make sure to replace your attribute name with colorAttribute and Color with DIVISI.(Confirm Attribute name from attributes screen)
#region UsrColor
[PXDBString(50)]
[PXUIField(DisplayName = "Color")]
[PXSelector(
typeof(Search<CSAttributeDetail.valueID,
Where<CSAttributeDetail.attributeID, Equal<colorAttribute>>>),
typeof(CSAttributeDetail.valueID),
typeof(CSAttributeDetail.description),
DescriptionField = typeof(CSAttributeDetail.description)
)]
public virtual string UsrColor { get; set; }
public abstract class usrColor : PX.Data.BQL.BqlString.Field<usrColor> { }
#endregion
}
public class colorAttribute : PX.Data.BQL.BqlString.Constant<colorAttribute>
{
public colorAttribute() : base("COLOR") { }
}Hope, it helps!
+13Hi
Please use the code snippet below.
Make sure to replace your attribute name with colorAttribute and Color with DIVISI.(Confirm Attribute name from attributes screen)
#region UsrColor
[PXDBString(50)]
[PXUIField(DisplayName = "Color")]
[PXSelector(
typeof(Search<CSAttributeDetail.valueID,
Where<CSAttributeDetail.attributeID, Equal<colorAttribute>>>),
typeof(CSAttributeDetail.valueID),
typeof(CSAttributeDetail.description),
DescriptionField = typeof(CSAttributeDetail.description)
)]
public virtual string UsrColor { get; set; }
public abstract class usrColor : PX.Data.BQL.BqlString.Field<usrColor> { }
#endregion
}
public class colorAttribute : PX.Data.BQL.BqlString.Constant<colorAttribute>
{
public colorAttribute() : base("COLOR") { }
}Hope, it helps!
Dipak Nilkanth || MVP @2025 || https://www.linkedin.com/in/dipak-nilkanth-293591102 || Acumatica Developer
Hi
public class InventoryItemExt : PXCacheExtension<PX.Objects.IN.InventoryItem>
{
#region UsrDivisi
[PXDBString(10)]
[PXUIField(DisplayName = "Divisi")]
[PXSelector(typeof(Search<CSAttributeDetail.valueID,
Where<CSAttributeDetail.attributeID, Equal<divisiAttribute>>>),
typeof(CSAttributeDetail.valueID),
typeof(CSAttributeDetail.description),
DescriptionField = typeof(CSAttributeDetail.description)
)]
public virtual string UsrDivisi { get; set; }
public abstract class usrDivisi : PX.Data.BQL.BqlString.Field<usrDivisi> { }
#endregion
}
public class divisiAttribute : PX.Data.BQL.BqlString.Constant<divisiAttribute> {
public divisiAttribute() : base("DIVISI") { }
}
It seems like your code should work. I’ve tried using the same selector on my instance, and it works fine.
To identify the issue in your system, I’d recommend testing each small part of the code step by step to locate the problematic one. I’d start with the Where clause in the selector. Could you try commenting out that line and see if the selector returns any values?
It's also worth checking the using directives — a wrong could be the reason. You can also share the code snippet with usings.
+15Try restarting the application from the Apply Updates screen.
Daryl ⚡Freelance Acumatica Developer (MVP🏆) for hire ⏩ linkedin.com/in/darylbowman
+15Please mark
Daryl ⚡Freelance Acumatica Developer (MVP🏆) for hire ⏩ linkedin.com/in/darylbowman
Hi
Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.