Trying to update in a custom action a custom field I added to Customer Location

Hi @edwardmcgovern97,

You have to assign value to the extended DAC field like below.

Location.Current.GetExtension<LocationExtn(extensionDACName)>(). UsrSettlementAmt  = <Your Value>;

I am trying to use the refrerence 

LocationMaint.Location.Current.GetExtension<UsrSettlementAmt>  = val;

And its not erroring.  It has the Current reference, resolves to a view and is the definition of the view from the form I am modifing (checked the code in app_data). 

Also not updating the field lol

Not sure what the update command is for the view

Hey Moulali, thanks for the response. 

I am not updating the grid, so there is no row to reference

This is a custom Action that loops the grid contents and updates a custom field, not on the grid in the header of the form.  

I have been kind of down your path (using PXCache - been looking at other screens and examples online) 

And the way I got at the Veiw for the existing form I’m modifying is like this: 

 Location loc = (Location)Base.Location.Current;

So with that I think I am clear to update the Data brought in from the Location view on the screen using PXCache like so: 

PXCache<Location>.GetExtension<LocationExt>(loc).UsrSettlementAmt = (decimal?)25.00;

The thing I am having an issue with 

is that after I run the Action The Control on the screen that holds the UsrSettlementAmt amount does not change values and the form doesn’t make the save button active, meaning it has no idea I updated the Cache…

So my code now looks like this for the custom action: 

 public PXAction<Location> CalculateSettlement;
        [PXButton(DisplayOnMainToolbar = true)]
        [PXUIField(DisplayName = "Settlement Total", Enabled = true)]
        protected virtual void calculatesettlement()
        {            

            decimal? d = 0;
            foreach (SettlementDetail sd in InvoiceSettlement.Select())
            {
                d = d + sd.DetailAmt;
            }

            //(Location)Base.
            Location loc = (Location)Base.Location.Current;

            PXCache<Location>.GetExtension<LocationExt>(loc).UsrSettlementAmt = (decimal?)25.00;
            

        }

Once again my problem is how do get the Cache to display on the screen with the new updated values AND recognize that the values updated and make the save active (or save my cache to the database and refresh back to sceen if I must) 

Hi @edwardmcgovern97

Please try the below way to update the custom field value inside an action method.

Ex:

#region Actions
public PXAction<YourDac> SomeValue;
[PXButton(CommitChanges = true)]
[PXUIField(DisplayName = "some name")]
protected virtual void someValue()
{
 // Get the current record from the cache.
 var row = YourDataView.Current;

// Get the DacExt 
var rowExt = row.GetExtension<YourDacExt>();

OR

var rowExt = cache.GetExtension<YourDacExt>(row);

 
 // Change the custom field value
 rowExt.usrField = someValue
 
 
 // Update the data record in the cache.
 DataView.Update(rowExt);
 
 // Trigger the Save action to save changes in the database.
 Actions.PressSave();
}
#endregion

Hope this may help you.

Thanks,

Moulali Shaik.