When doing stock take, I want to be able to see stock item’s Alternate ID, specifically for ‘OEM Part Numbers’ - I want the Alternate ID on Prepare Physical Count review, Physical Inventory Count and Physical Inventory Review screen. I note they are not a generic inquiry screens and thought this is possible via customizations?
Best answer by Naveen Boga
DAC Extension field:
#region UsrAlternateID
[PXString(50, IsUnicode = true)]
[PXUIField(DisplayName = "Alternate ID", Enabled = false)]
public virtual string UsrAlternateID { get; set; }
public abstract class usrAlternateID :
PX.Data.BQL.BqlString.Field<usrAlternateID> { }
#endregionGraph Logic add in the FieldSelecting event to populate the UsrAlternate ID. If required, please make the changes to the code.
public static string GetOEMAlternateID(PXGraph graph, int? inventoryID)
{
if (inventoryID == null) return null;
// First try — Global type with OEM Part Nbr description
INItemXRef xref = SelectFrom<INItemXRef>
.Where<INItemXRef.inventoryID.IsEqual<@P.AsInt>
.And<INItemXRef.alternateType.IsEqual<INAlternateType.global>>
.And<INItemXRef.descr.IsEqual<@P.AsString>>>
.View.Select(graph, inventoryID, "OEM Part Nbr");
if (xref != null)
return xref.AlternateID;
// Second try — Global type, any description (fallback)
INItemXRef xrefGlobal = SelectFrom<INItemXRef>
.Where<INItemXRef.inventoryID.IsEqual<@P.AsInt>
.And<INItemXRef.alternateType.IsEqual<INAlternateType.global>>>
.View.Select(graph, inventoryID);
return xrefGlobal?.AlternateID;
}
+20Yes
Thanks
+20
DAC Extension field:
#region UsrAlternateID
[PXString(50, IsUnicode = true)]
[PXUIField(DisplayName = "Alternate ID", Enabled = false)]
public virtual string UsrAlternateID { get; set; }
public abstract class usrAlternateID :
PX.Data.BQL.BqlString.Field<usrAlternateID> { }
#endregionGraph Logic add in the FieldSelecting event to populate the UsrAlternate ID. If required, please make the changes to the code.
public static string GetOEMAlternateID(PXGraph graph, int? inventoryID)
{
if (inventoryID == null) return null;
// First try — Global type with OEM Part Nbr description
INItemXRef xref = SelectFrom<INItemXRef>
.Where<INItemXRef.inventoryID.IsEqual<@P.AsInt>
.And<INItemXRef.alternateType.IsEqual<INAlternateType.global>>
.And<INItemXRef.descr.IsEqual<@P.AsString>>>
.View.Select(graph, inventoryID, "OEM Part Nbr");
if (xref != null)
return xref.AlternateID;
// Second try — Global type, any description (fallback)
INItemXRef xrefGlobal = SelectFrom<INItemXRef>
.Where<INItemXRef.inventoryID.IsEqual<@P.AsInt>
.And<INItemXRef.alternateType.IsEqual<INAlternateType.global>>>
.View.Select(graph, inventoryID);
return xrefGlobal?.AlternateID;
}
Champion!
Below is my code:
using PX.Data;
using PX.Objects.IN;
#region UsrAlternateID
public class PIGeneratorExt : PXGraphExtension<PIGenerator>
{
public static string GetOEMAlternateID(PXGraph graph, int? inventoryID)
{
if (inventoryID == null) return null;
// Only look for Global type with OEM Part Nbr description
PXResult<INItemXRef> xref = PXSelect<INItemXRef,
Where<INItemXRef.inventoryID, Equal<Required<INItemXRef.inventoryID>>,
And<INItemXRef.alternateType, Equal<INAlternateType.global>,
And<INItemXRef.descr, Equal<Required<INItemXRef.descr>>>>>>.Select(graph, inventoryID, "OEM Part Nbr");
if (xref != null)
return ((INItemXRef)xref).AlternateID;
// If not found, return null (no fallback)
return null;
}
protected virtual void PIPreliminaryResult_UsrAlternateID_FieldSelecting(PXCache sender, PXFieldSelectingEventArgs e)
{
if (e.Row is PIPreliminaryResult row)
{
e.ReturnValue = GetOEMAlternateID(this.Base, row.InventoryID);
}
}
}
#endregion
+20
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.