Add Field Value From Customer Screen to Custom Form

Question

Hi, I need to add a field value in the customers form to my custom form. I tried using field selecting to achieve this but no value is populated to the custom form.

protected void NCPMCustomerMaster_Outstanding_FieldSelecting(PXCache cache, PXFieldSelectingEventArgs e)
        {
            NCPMCustomerMaster row = (NCPMCustomerMaster)e.Row;
            if (row != null)
            {

                Customer customerObj = PXSelect<Customer, Where<Customer.acctCD, Equal<Required<Customer.acctCD>>>>.Select(this, row.CustomerIntType);
                if (customerObj != null)
                {

                    row.Outstanding = customerObj.Balance;

                }
            }
        }

icon

Best answer by andriikravetskyi35 20 December 2022, 16:54

View original

andriikravetskyi35 · Accepted Answer

Hi everybody,Customer DAC doesn’t have Balance field, so the compiler senderror during build of project.You need to useARBalances table and select balance from it, like this:var arBalance = SelectFrom.Where>.View.Select(this, row.CustomerIntType)?.TopFirst;e.ReturnValue = arBalance?.CurrentBal;

Fernando Amadoz · Answer

@TharidhiPtry this alternative version to your logicprotected void NCPMCustomerMaster_Outstanding_FieldSelecting(PXCache cache, PXFieldSelectingEventArgs e) { NCPMCustomerMaster row = (NCPMCustomerMaster)e.Row; if (row != null) { Customer customerObj = PXSelect>>>.Select(this, row.CustomerIntType); if (customerObj != null) { e.ReturnValue = customerObj.Balance; } } }Also, make sure that the variablecustomerObj is not NULL. You appear to be comparing a string (Customer.acctCD) to an integer (row.CustomerIntType)

Add Field Value From Customer Screen to Custom Form

3 replies

Reply

Reply

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded