Custom field on CR Quote screen

Hi Everyone,

If you try to add a custom field on CR Quotes in Acumatica 2018 R2 you may face very weird behavior – field is added, can be saved to database but as soon as you refresh screen or record valued disappears.
The reason of this issues is PXProjection that is described in my separate article: PXProjection – SQL Views using BQL 
This image show you how projection is defined in Acumatica CRM

PXProjection uses 2 Data Access Classes for quotes:

• One class represents the table – PX.Objects.CR.Standalone.CRQuote
• Another represents view as combination of DACs in select – PX.Objects.CR.CRQuote

And to correctly work, custom field needs to be added in both of the places. And Projection field should be linked to table field using BqlField property of DBFieldAttributes.
Unfortunately customization by default adds new field only to projection dac and not tho the real one.

But no worries, if something cannot be done automatically we can always do it manually:
Here we just add custom field twice – one time for PX.Objects.CR.CRQuote and than second time for PX.Objects.CR.Standalone.CRQuote
Please note that in the first field you should specify: BqlField=typeof(CRQuoteExt.usrCustomField)

In the end (and after you publish) you will have 2 extension:

namespace PX.Objects.CR
{
    public class CRQuoteExt : PXCacheExtension<PX.Objects.CR.CRQuote>
    {
        #region UsrCustomField
        [PXDBString(100, BqlField=typeof(CRQuoteExt.usrCustomField))]
        [PXUIField(DisplayName="CustomField")]
        public virtual string UsrCustomField { get; set; }
        public abstract class usrCustomField : IBqlField { }
        #endregion
    }
}

namespace PX.Objects.CR.Standalone
{
    public class CRQuoteExt : PXCacheExtension<PX.Objects.CR.Standalone.CRQuote>
    {
        #region UsrCustomField
        [PXDBString(100)]
        [PXUIField(DisplayName="CustomField")]

        public virtual string UsrCustomField { get; set; }
        public abstract class usrCustomField : IBqlField { }
        #endregion
    }
}

Now your field will be automatically selected from the DB.

Have an easy customization!