Skip to main content
Answer

Custom field using [Inventory] attribute but not as a DB field

  • August 24, 2023
  • 2 replies
  • 87 views
Joe Schmucker
Captain II
Forum|alt.badge.img+3

I want to create a custom field using the [Inventory] attribute so that I get the selector and it is all sorted out for me.  I don’t want it to be PXDBInt.  I want it to be a virtual field of type PXInt.

        #region UsrModEquipTempID
        [Inventory]
        [PXUIField(DisplayName = "Model Equipment")]
        public int? UsrModEquipTempID { get; set; }
        public abstract class usrModEquipTempID : PX.Data.BQL.BqlInt.Field<usrModEquipTempID> { }
        #endregion

If I put [PXInt], it causes a compiler error.  

How can I do that?

 

 

Best answer by Naveen Boga

Hi @Joe Schmucker  Yes, [InventoryID] will not work with unbound field fields.

You can your DAC like below.

 

       #region FirstItem

        [PXInt()]
        [PXSelector(typeof(Search<InventoryItem.inventoryID, Where<InventoryItem.stkItem, Equal<True>,
            And<InventoryItem.itemStatus, Equal<AMIConstants.ActiveStatus>>>>), new Type[] { typeof(InventoryItem.inventoryCD), typeof(InventoryItem.descr) }, SubstituteKey = typeof(InventoryItem.inventoryCD))]
        [PXUIField(DisplayName = "Select Item", Required = true)]
        public virtual int? FirstItem { get; set; }
        public abstract class firstItem : IBqlField { }

        #endregion

 

Joe Schmucker, CPA | Software Engineer | Acumatica ERP Developer
    Leonardo Justiniano
    D

    2 replies

    Naveen Boga
    Captain II
    Forum|alt.badge.img+19
    • Naveen Boga
    • Captain II
    • Answer
    • August 24, 2023

    Hi @Joe Schmucker  Yes, [InventoryID] will not work with unbound field fields.

    You can your DAC like below.

     

           #region FirstItem

            [PXInt()]
            [PXSelector(typeof(Search<InventoryItem.inventoryID, Where<InventoryItem.stkItem, Equal<True>,
                And<InventoryItem.itemStatus, Equal<AMIConstants.ActiveStatus>>>>), new Type[] { typeof(InventoryItem.inventoryCD), typeof(InventoryItem.descr) }, SubstituteKey = typeof(InventoryItem.inventoryCD))]
            [PXUIField(DisplayName = "Select Item", Required = true)]
            public virtual int? FirstItem { get; set; }
            public abstract class firstItem : IBqlField { }

            #endregion

     

    Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
    Leonardo Justiniano
    D
    Joe Schmucker
    Joe Schmucker
    Captain II
    Forum|alt.badge.img+3
    • Joe Schmucker
    • Author
    • Captain II
    • August 24, 2023

    @Naveen Boga Thank you so much for giving me the code!  

    Joe Schmucker, CPA | Software Engineer | Acumatica ERP Developer
    Chris Hackett
    Terms & ConditionsCookie settingsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved