Dear Support,
I have created custom field usrLookup on Inventoryitem and I want this field to add on column Purchase Order Line.
Please advise.
Thanks,
Idrus
Answer
Add field of InventoryItem to Purchase Order Line
Best answer by idrusm52
Thank you
After check with GPT, I got the update code as below that working well.
using PX.Data;
using PX.Data.BQL;
using PX.Objects.IN;
using PX.Objects.PO;
namespace PX.Objects.PO
{
public class InventoryItemExt : PXCacheExtension<InventoryItem>
{
[PXDBString(50, IsUnicode = true)]
[PXUIField(DisplayName = "Lookup Code")]
public string UsrLookup { get; set; }
public abstract class usrLookup : PX.Data.BQL.BqlString.Field<usrLookup> { }
}
public class POLineExtCustom : PXCacheExtension<POLine>
{
[PXString(50, IsUnicode = true)]
[PXUIField(DisplayName = "Part No.", Enabled = false)]
[PXUnboundDefault(typeof(
Search<InventoryItemExt.usrLookup,
Where<InventoryItem.inventoryID, Equal<Current<POLine.inventoryID>>>>))]
[PXFormula(typeof(Default<POLine.inventoryID>))]
public string UsrInventoryLookup { get; set; }
public abstract class usrInventoryLookup : BqlString.Field<usrInventoryLookup> { }
}
}
+13Hi
- Add Custom field in POLine.
- You can use
PXFormulain your DAC extension ofPOLinefor same custom field as shown below:
[PXFormula(typeof(Selector<POLine.inventoryID, TSInventoryItemExtensions.usrLookup>))]
Note : Please set Commit Changes to true for the custom field
Hope, it helps!
Dipak Nilkanth || MVP @2025 || https://www.linkedin.com/in/dipak-nilkanth-293591102 || Acumatica Developer
You can add a custom field in POLineExtension using the sample code below:
public class POLineExt : PXCacheExtension<POLine>
{
[PXDBString(50)]
[PXUIField(DisplayName = "Item Lookup")]
[PXFormula(typeof(
Search<InventoryItemExt.usrLookup,
Where<InventoryItem.inventoryID, Equal<Current<POLine.inventoryID>>>>))]
public string UsrInventoryLookup { get; set; }
public abstract class usrInventoryLookup : PX.Data.BQL.BqlString.Field<usrInventoryLookup> { }
}
Hope this work’s
Thank you
After check with GPT, I got the update code as below that working well.
using PX.Data;
using PX.Data.BQL;
using PX.Objects.IN;
using PX.Objects.PO;
namespace PX.Objects.PO
{
public class InventoryItemExt : PXCacheExtension<InventoryItem>
{
[PXDBString(50, IsUnicode = true)]
[PXUIField(DisplayName = "Lookup Code")]
public string UsrLookup { get; set; }
public abstract class usrLookup : PX.Data.BQL.BqlString.Field<usrLookup> { }
}
public class POLineExtCustom : PXCacheExtension<POLine>
{
[PXString(50, IsUnicode = true)]
[PXUIField(DisplayName = "Part No.", Enabled = false)]
[PXUnboundDefault(typeof(
Search<InventoryItemExt.usrLookup,
Where<InventoryItem.inventoryID, Equal<Current<POLine.inventoryID>>>>))]
[PXFormula(typeof(Default<POLine.inventoryID>))]
public string UsrInventoryLookup { get; set; }
public abstract class usrInventoryLookup : BqlString.Field<usrInventoryLookup> { }
}
}
+13
Dipak Nilkanth || MVP @2025 || https://www.linkedin.com/in/dipak-nilkanth-293591102 || Acumatica Developer
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.