adding custom field to selector column in SO

@dgross54 Could you share the definition of the custom field in InventoryItem DAC? 

Your approach should work.

Hi @dgross54  It seems you have not given the right extended DAC name, hence it is not populating.

As above requested, please share the code of the Inventory Extended DAC.

Here is the links for reference.

https://www.info-sourcing.com/how-to-add-fields-to-acumatica-selector-lookup-no-coding/

I am not sure where I would go to get the definitions you are referring to.  I wonder if my issue isn’t related to the fact that I had to borrow another customization project so I could add these fields to a group that already existed, and by doing so I added the fields in another data source?  

Hi, @dgross54  You might need to add these fields to your customization as part of the DAC Extension fields and then provide these fields in the CustomizeSelectorColumns instead of access from the different customization packages.

CustomizeSelectorColumns will not recognize the fields if they are part of another customization package.

@dgross54 @Naveen Boga Another approach is to set an appropiate Level to the customization to access the fields from other projects and set the corresponding namespace name when calling the custom fields in the PXCustomizeSelectorColumns attribute. It’s probably the custom fields are not defined under PX.Objects.IN and that might explain why they are not found.

Hi @dgross54 - I'm glad you found the issue! We don't delete user content unless it goes against Terms and Conditions. It's OK to leave this post as you gave the explanation. Thank you!

​@Naveen Boga Hi Naveen,

we are working in Sales Quotes (CR304500), we need to add Warehouse and available qty to Inventory selector pop up. is there any guide that we can refer to?

thank you in advance!

Hi ​@Isharam,
It depends on your requirement.
If you need to display the default warehouse, you can add it directly from the Customization Editor by using the Edit Selector Columns option.

For the Available Quantity, you will need to fetch it into a custom field within the same DAC Extension. Once added, this custom field will appear under the Custom section in the selector configuration popup (as shown in the image). You can then select this custom field and display it in the Inventory Lookup.

Hope, it helps!

Thank you ​@Nilkanth Dipak!

yes we are trying to add Warehouse and Available qty. also we understand that would duplicate inventory ID’s by each warehouse and we are fine with it. if you can share any guide that we can refer onto that would be great! 

​@Isharam  Instead of customizing the Inventory field selector, I recommend same as default Acumatica Sales Orders screen, where you can display the Qty Available, Qty OnHand, Qty Available for Shipping using the FieldSelecting event like below at footer level in the Sales Quotes screen.  Hope this helps!

​@Naveen Boga This is great. if you have any guide on this that would be great!

​@Isharam  Please follow below links

https://stackoverflow.com/questions/45025533/how-to-display-product-availability-in-opportunity-products-grid-footer

https://stackoverflow.com/questions/55249309/how-do-i-add-the-inventory-availability-status-to-custom-grid-like-so301000

Thank you Naveen! i tried following the process but I am getting errors on both DAC and graph extension. 

using PX.Data;
using PX.Objects.CR;
using System;

namespace PX.Objects.CR
{
    [Serializable]
    public class CROpportunityProductsExt : PXCacheExtension<CROpportunityProducts>
    {
        #region MyAvailability
        [PXString(IsUnicode = true)]
        [PXUIField(DisplayName = "Product Availability", Enabled = false)]
        public virtual string MyAvailability { get; set; }
        public abstract class myAvailability : PX.Data.BQL.BqlString.Field<myAvailability> { }
        #endregion
    }
}

and 

using PX.Data;
using PX.Objects.CR;
using PX.Objects.IN;
using PX.Objects.CS;
using System;

namespace PX.Objects.CR
{
    public class OpportunityMaint_Ext : PXGraphExtension<OpportunityMaint>
    {
        protected void _(Events.FieldSelecting<CROpportunityProducts, CROpportunityProductsExt.myAvailability> e)
        {
            var row = (CROpportunityProducts)e.Row;
            if (row == null || row.InventoryID == null)
            {
                e.ReturnValue = string.Empty;
                return;
            }

            var status = PXSelectGroupBy<
                INLocationStatus,
                Where<
                    INLocationStatus.inventoryID, Equal<Required<INLocationStatus.inventoryID>>,
                    And2<
                        Where<INLocationStatus.subItemID, Equal<Required<INLocationStatus.subItemID>>,
                            Or<Not<FeatureInstalled<FeaturesSet.subItem>>>>,
                        And<
                            Where<INLocationStatus.siteID, Equal<Required<INLocationStatus.siteID>>,
                            Or<Required<INLocationStatus.siteID>, IsNull>>>>>,
                Aggregate<
                    Sum<INLocationStatus.qtyOnHand>,
                    Sum<INLocationStatus.qtyAvail>>>
                .Select(Base, row.InventoryID, row.SubItemID, row.SiteID, row.SiteID);

            var location = (INLocationStatus)status;

            decimal? qtyOnHand = location?.QtyOnHand ?? 0;
            decimal? qtyAvail = location?.QtyAvail ?? 0;

            e.ReturnValue = $"On Hand: {qtyOnHand}, Available: {qtyAvail}";
        }
    }
}