How to Hide Empty Rows and Columns in the Add Matrix Items Grid (SO301000)?

Hi ​@SaiKrishnaV ,

Try to extend `MatrixEntryExt` and override `GetMatrixAttributeValues()`. That method supplies the attribute values the panel turns into rows and columns — prune what it returns and the empty rows/columns are never built.

- The extension class must live in the `PX.Objects.IN.GraphExtensions.SOOrderEntryExt` namespace. The base type resolves relative to it and won't compile anywhere else.
- Extend `MatrixEntryExt`, not `SmartPanelExt`.
 

​@jinin Thanks for the input! I will give it a try.

​@jinin ​@RohitRattan88 ​@arpine08 

I tried the code below to hide empty rows and columns. However, the Total Qty values in the button row are not refreshing/updating correctly, while the Total Qty in the last column is updating as expected.   

public class MatrixEntryExtSOExt : PX.Objects.IN.GraphExtensions.SOOrderEntryExt.MatrixEntryExt
{
    protected override MatrixAttributeValues GetMatrixAttributeValues()
    {
        // Get all row/column values
        MatrixAttributeValues matrixValues = base.GetMatrixAttributeValues();

        // Existing inventory combinations
        var inventoryMap = GetInventoryMap();

        // Remove rows that have no inventory variants
        matrixValues.RowValues = matrixValues.RowValues
            .Where(row => inventoryMap.Keys.Any(k => k.RowAttributeValue == row.ValueID)).ToArray();

        // Remove columns that have no inventory variants
        matrixValues.ColumnValues = matrixValues.ColumnValues
            .Where(col => inventoryMap.Keys.Any(k => k.ColumnAttributeValue == col.ValueID)).ToArray();

        return matrixValues;
    }       
}

I tried using view.requestRefresh() in the RowSelected event, and it refreshes the Total Qty correctly. However, it affects the grid behavior. For example, after entering a value and pressing Tab, the next 0.00 cell gets focus, but the value is not selected the cursor is placed at the end of the value instead.

Could you please help me identify what might be causing this issue and how I can fix it?

Hi ​@SaiKrishnaV,

Thanks for tagging me.

I reviewed the issue. The filtering logic itself works as expected. The issue appears to be caused by deriving the customization class directly from MatrixEntryExt. Even with only the derived class declaration and no overrides, the Total Qty. calculations and the removal of empty rows/columns did not work as expected.

Instead, I extended MatrixEntryExt using PXGraphExtension and used PXOverride for GetMatrixAttributeValues(). Since GetInventoryMap() is protected, I exposed it through PXProtectedAccess.

With this approach, the standard Total Qty. calculations continue to work correctly, and the empty rows/columns are removed. I tested this with the Sales Demo data in my local environment.

Please try the code below in your environment and see if it resolves the issue.

Here is the full code:

using PX.Data;
using PX.Objects.IN.Matrix.GraphExtensions;
using PX.Objects.SO;
using System.Collections.Generic;
using System.Linq;

namespace Graph_Ext.SO
{
    [PXProtectedAccess(typeof(PX.Objects.IN.GraphExtensions.SOOrderEntryExt.MatrixEntryExt))]
    public abstract class MatrixEntryExtProtectedAccess :  PXGraphExtension<PX.Objects.IN.GraphExtensions.SOOrderEntryExt.MatrixEntryExt, SOOrderEntry>
    {
        [PXProtectedAccess]
        public abstract IDictionary<MatrixGridExt<SOOrderEntry, SOOrder>.InventoryMapKey, MatrixGridExt<SOOrderEntry, SOOrder>.InventoryMapValue>  GetInventoryMap();
    }


    public class MatrixEntryExtSOExt : PXGraphExtension<PX.Objects.IN.GraphExtensions.SOOrderEntryExt.MatrixEntryExt,  SOOrderEntry>
    {

        public delegate MatrixGridExt<SOOrderEntry, SOOrder>.MatrixAttributeValues GetMatrixAttributeValuesDelegate();
        [PXOverride]
        public MatrixGridExt<SOOrderEntry, SOOrder>.MatrixAttributeValues GetMatrixAttributeValues(GetMatrixAttributeValuesDelegate baseMethod)
        {
            // Get all row/column values
            MatrixGridExt<SOOrderEntry, SOOrder>.MatrixAttributeValues matrixValues = baseMethod();

            MatrixEntryExtProtectedAccess baseExt = Base.GetExtension<MatrixEntryExtProtectedAccess>();

            // Existing inventory combinations
            var inventoryMap = baseExt.GetInventoryMap();
            // Remove rows that have no inventory variants
            matrixValues.RowValues = matrixValues.RowValues
                .Where(row => inventoryMap.Keys.Any(k => k.RowAttributeValue == row.ValueID)).ToArray();
            // Remove columns that have no inventory variants
            matrixValues.ColumnValues = matrixValues.ColumnValues
                .Where(col => inventoryMap.Keys.Any(k => k.ColumnAttributeValue == col.ValueID)).ToArray();
            return matrixValues;
        }

    }
}

​@arpine08  thanks for looking into this. I tried the suggested approach, but I am still seeing an issue with the grid behavior. When I enter a value and press Tab, the next 0.00 cell gets focus, but the value is not selected; the cursor is placed at the end instead. please refer below screenshot.

​@SaiKrishnaV,

I tested the scenario you described in a clean system (Sales Demo data) with no customization packages published.

In the Modern UI, after entering a value and pressing Tab, the value in the next cell is briefly selected, but then the cursor moves to the end of the value, as you described.

For the same scenario in the Classic UI, the behavior is different. After entering a value and pressing Tab, the value in the next cell remains selected, and the cursor does not move to the end of the value.

Therefore, this behavior appears to be related to the Modern UI and is not caused by the customization.

Could you please check it in your environment as well?

​@arpine08 Thank you for looking into this and for sharing the details.

I tested the same scenario in 26R1 instance with customization code, and the issue occurs. After entering a value in a cell and pressing Tab, the next cell gets focus, but the cursor moves to the end of the existing value instead of selecting the value.

I also tested the same scenario without our customization, and the behavior works as expected. After pressing Tab, the next cell gets focus and the value is selected correctly.

Based on this testing, it appears that our customization code is causing the issue.

Hi ​@RohitRattan88 , could you please suggest how I can fix this issue?

Any guidance would be greatly appreciated. Thank you!