Need help with Creating Custom "Related" field

Thank you, Ray.

I am new to Acumatica, so here are the steps that I did:

1. Create the new field like this:

2. Added the Customer line (copied from Customer ID field) and published it once.

[PXDBInt]
[PXUIField(DisplayName="Test Customer")]
[CustomerActive(Visibility = PXUIVisibility.SelectorVisible, DescriptionField = typeof(Customer.acctName),Filterable=true, TabOrder=2)]

3. Added it to the UI screen:

4. Added the Field and published again:

5. After publishing, it doesn’t allow me to view the record, and says “Invalid Cast”.

6. And the UI label always defaults to “Customer” as well, in the form layout.

By DAC, do you mean the source code?

Thanks again for your help!

Hi @ray20, Your idea gave me some inspiration to try out the PXSelector, but when I use it, I always get this error: Specified cast is not valid:

I converted yours into a Customer reference, something like:

[PXDBInt]
[PXUIField(DisplayName="Test Customer")]
[PXSelector(typeof(Customer.bAccountID),SubstituteKey = typeof(Customer.acctCD),DescriptionField = typeof(Customer.acctName))]

Hello,

    I guess the problem happens at the add a control step.
Can you try the control type as “selector”?

  I did not use “segmentmask” type before, so I am not sure. I previously use “selector” type and it is OK.

       Note: when you select the “Selector” as the control step, it looks like it would change automatically to “textedit”.  please ignore it.

          Just make sure you have the right codes in DAC, and then publish.

@paramesh 

Below the DAC and .aspx page fields to add the Customer ID field.

DAC

#region USRKCustomerID
public abstract class uSRCustomerID : PX.Data.BQL.BqlInt.Field<uSRCustomerID> { }
[PXDefault]
[CustomerActive(DisplayName = "Customer ID", Visibility = PXUIVisibility.SelectorVisible, Required = false, DescriptionField = typeof(Customer.acctName), Filterable = true)]
public virtual Int32? USRCustomerID { get; set; }
#endregion

.aspx Page:

<px:PXSegmentMask CommitChanges="True" ID="USRCustomerID" runat="server" DataField="USRCustomerID" ></px:PXSegmentMask>

Hi @ray20 , @Naveen B ,

Thanks for your input. Both of your options worked for me.

The problem was with our existing field - maybe the DB column was incorrect when I created first time, and even when I deleted and recreated, it was still not working. 

I just created new fields and they're working fine now.

Thanks and have a nice day!
Paramesh