Override field value and use it as condition of Automation Schedule

@mrthanhkhoi - Were you able to make any progress?

Hello @darylbowman, 

Unfortunately it still doesn't work. I implemented 2 event FieldDefaulting for field AssetClass and Department, also 1 event FieldUpdated for InventoryID but the value of AssetClass and Department wasn’t taken from InventoryID

Here is my code:

using PX.Data;
using PX.Objects.IN;

namespace PX.Objects.FA
{
    // Acuminator disable once PX1016 ExtensionDoesNotDeclareIsActiveMethod extension should be constantly active
    public class AssetGLTransactions_Extension : PXGraphExtension<AssetGLTransactions>
    {
        #region Event Handlers        
        protected void FAAccrualTran_GLTranInventoryID_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e, PXFieldUpdated InvokeBaseHandler)
        {
            if (InvokeBaseHandler != null)
                InvokeBaseHandler(cache, e);
            var row = (FAAccrualTran)e.Row;
            if (row != null && row.GLTranInventoryID != null)
            {
                InventoryItem inventory = PXSelect<InventoryItem, Where<InventoryItem.inventoryID, Equal<Required<InventoryItem.inventoryID>>>>.Select(Base, row.GLTranInventoryID);
                if (inventory != null)
                {
                    var inventoryItemExt = PXCache<InventoryItem>.GetExtension<InventoryItemExt>(inventory);
                    if (inventoryItemExt != null && inventoryItemExt.UsrDepartment != null)
                    {
                        cache.SetDefaultExt<FAAccrualTran.department>(inventoryItemExt.UsrDepartment);
                    }
                    if (inventoryItemExt != null && inventoryItemExt.UsrAssetClass != null)
                    {
                        cache.SetDefaultExt<FAAccrualTran.classID>(inventoryItemExt.UsrAssetClass);
                    }
                }
            }
        }

        protected void FAAccrualTran_Department_FieldDefaulting(PXCache cache, PXFieldDefaultingEventArgs e, PXFieldDefaulting InvokeBaseHandler)
        {
            if (InvokeBaseHandler != null)
                InvokeBaseHandler(cache, e);
            var row = (FAAccrualTran)e.Row;
            if (row != null && row.GLTranInventoryID != null)
            {
                InventoryItem inventory = PXSelect<InventoryItem, Where<InventoryItem.inventoryID, Equal<Required<InventoryItem.inventoryID>>>>.Select(Base, row.GLTranInventoryID);
                if (inventory != null)
                {
                    var inventoryItemExt = PXCache<InventoryItem>.GetExtension<InventoryItemExt>(inventory);
                    if (inventoryItemExt != null && inventoryItemExt.UsrDepartment != null)
                    {
                        e.NewValue = inventoryItemExt.UsrDepartment;
                        e.Cancel = true;
                    }
                }
            }
        }

        protected void FAAccrualTran_ClassID_FieldDefaulting(PXCache cache, PXFieldDefaultingEventArgs e, PXFieldDefaulting InvokeBaseHandler)
        {
            if (InvokeBaseHandler != null)
                InvokeBaseHandler(cache, e);
            var row = (FAAccrualTran)e.Row;
            if (row != null && row.GLTranInventoryID != null)
            {
                InventoryItem inventory = PXSelect<InventoryItem, Where<InventoryItem.inventoryID, Equal<Required<InventoryItem.inventoryID>>>>.Select(Base, row.GLTranInventoryID);
                if (inventory != null)
                {
                    var inventoryItemExt = PXCache<InventoryItem>.GetExtension<InventoryItemExt>(inventory);
                    if (inventoryItemExt != null && inventoryItemExt.UsrAssetClass != null)
                    {
                        e.NewValue = inventoryItemExt.UsrAssetClass;
                        e.Cancel = true;
                    }
                }
            }
        }
        #endregion
    }
}

Do you have further idea?

You’re close, but SetDefaultExt does not get a value passed into it. The default value is handled by the event. Here’s how I would write one of the defaulting events and the field updated:

protected virtual void _(Events.FieldDefaulting<FAAccrualTran, FAAccrualTran.department> e, PXFieldDefaulting b)
{
    FAAccrualTran row = e.Row;
    if (row is null) return;

    b?.Invoke(e.Cache, e.Args);

    InventoryItem inventory = InventoryItem.PK.Find(e.Cache.Graph, row?.GLTranInventoryID);
    var inventoryItemExt = inventory?.GetExtension<InventoryItemExt>();
    if (inventoryItemExt?.UsrDepartment is object)
    {
        e.NewValue = inventoryItemExt.UsrDepartment;
        e.Cancel = true;
    }
}

protected virtual void _(Events.FieldUpdated<FAAccrualTran, FAAccrualTran.gLTranInventoryID> e, PXFieldUpdated b)
{
    FAAccrualTran row = e.Row;
    if (row is null) return;

    b?.Invoke(e.Cache, e.Args);

    // Calls the defaulting event
    e.Cache.SetDefaultExt<FAAccrualTran.department>(row);
}

Notice I’ve passed SetDefaultExt the row from the event instead of a value. The value will be set by the logic in the field defaulting event handler.

Also note that this uses ? frequently to check for null instead of many if statements.

@darylbowman, thank you for your suggestion.

I have tried with your propose but it still doesn’t work. I can’t find value of Department column of FAAccuralTran even newly row is added

I’m not familiar with this screen, and my original suggestions were based on the assumption that rows were being inserted on this screen like your code suggested. However, (still not really understanding much about this screen), I don’t think FAAccrualTran is being inserted on this screen, therefore, FieldDefaulting isn’t going to fire. From the graph code, it looks like this list is simply selected from the database. The inserting seems to have happened previously from a different graph. In order to use the above model, it would have to be on a screen where the rows are being inserted.

The interesting thing is, when the Department field at the top is changed, the Department field of FAAccrualTran is being changed in the cache:

It stands to reason that perhaps you could do something similar at an appropriate time.