Customize Matrix Item grid

using PX.Data;
using PX.Objects.IN.Matrix.DAC.Unbound;

// Namespace is important to be this
namespace PX.Objects.IN.GraphExtensions.SOOrderEntryExt
{
    public class SOMatrixEntryExt : MatrixEntryExt
    {
	    protected void _(Events.RowUpdated<MatrixInventoryItem> e)
	    {
		    // Maybe you can do something here?
	    }

	    protected override MatrixAttributeValues GetMatrixAttributeValues()
	    {
		    // Maybe you can do something here?
		    return null;
	    }         
    }
}

Thanks!  Funny I already had a sub-class for MatrixEntryExt but just wasn’t sure where to go next. This gives me hope.

Extend MatrixEntryExt instead of SmartPanelExt. Remember, you still need to use the correct namesapce.

using System;
using PX.Data;
using PX.Objects.IN.Matrix.DAC.Unbound;
using PX.Objects.SO;

namespace PX.Objects.IN.GraphExtensions.SOOrderEntryExt
{
    public class MyMatrixEntryExtExtension : PXGraphExtension<MatrixEntryExt, SOOrderEntry>
    {
	    [PXOverride]
	    protected virtual void AddItemsToOrder(int? siteID, Action<int?> baseMethod)
	    {
		    baseMethod?.Invoke(siteID); // if you need
		    // your code
	    }
    }
}

I don’t get that error, anyway, you can overwrite it in the first class I gave you as well.

I tried it on 22R2, I can confirm the debugger stopped on base.AddItemsToOrder

using PX.Data;
using PX.Objects.IN.Matrix.DAC.Unbound;

namespace PX.Objects.IN.GraphExtensions.SOOrderEntryExt
{
    // Acuminator disable once PX1016 ExtensionDoesNotDeclareIsActiveMethod extension should be constantly active
    public class SOMatrixEntryExt : MatrixEntryExt
    {
	    protected void _(Events.RowUpdated<MatrixInventoryItem> e)
	    {
		    // Maybe you can do something here?
	    }

	    protected override MatrixAttributeValues GetMatrixAttributeValues()
	    {
		    // Maybe you can do something here?
		    return null;
	    }

	    protected override void AddItemsToOrder(int? siteID)
	    {
		    base.AddItemsToOrder(siteID);
	    }
    }
}

The issue I am having now is that AddItemsToOrder has a PXLongOperation in it and I need to somehow wait for that to finish before I run my code after the invoke of the base method as I need the inventory items to exist so I can add to ARSalesPrice.

What would be ideal is if I could add code right after CreateMatrixItemsHelper.CreateUpdateMatrixItems is run from inside AddItemsToorder.

Thanks again Zoltan. You have helped me get very close.  The GetCreateMatrixItemsHelper method was exactly what I needed.

So I now have my sales prices creating for each price class after the base.CreateUpateMatrixItems method is called.  That is working fantastic.

However, now the client wants me to update the LastCost on the new SKU at the same time.  I have added this code:

INItemCost itemCost = new INItemCost()
{
	InventoryID = item.InventoryID,
	LastCostDate = DateTime.Now,
	LastCost = cost,
	CuryID = "USD",
	QtyOnHand = 0M,
	TotalCost = 0M,
	MinCost = 0M,
	MaxCost = 0M
};

itemGraph.ItemCosts.Insert(itemCost);
itemGraph.Persist();

But it gives me this error:

The item has a warehouse and all UOM is set to EA.  Valuation is set to FIFO.  I can enter Last Cost on the same Inventory Item Price/Cost tab on the screen and it saves fine.  Any ideas?

Hi @rjean09,

It looks like you modify LastCost after inserting the record, but it never arrives the cache.
Please see my comments, you need to implement only one of them.

INItemCost itemCost = new INItemCost()
{
	InventoryID = item.InventoryID,
	CuryID = "USD",
	QtyOnHand = 0M,
	TotalCost = 0M,
	MinCost = 0M,
	MaxCost = 0M
    // LastCost and LastCostDate are not here.
};

itemGraph.ItemCosts.Insert(itemCost);
itemCost.LastCost = cost;
itemCost.LastCostDate = DateTime.Now;
// itemGraph.ItemCosts.Update(itemCost); is missing.

// itemGraph.Persist();
itemGraph.Save.Press();

This error message comes from this file: App_Data/CodeRepository/PX.Objects/IN/GraphExtensions/InventoryItemMaintBaseExt/UnitsOfMeasure.cs, from ValidateUnitConversions function:

if (baseConversions.Count() != 1)
	throw new PXException(Messages.BaseConversionNotFound,...

Maybe you already have an ItemCost record, and you need to update it, instead of inserting a new one?

Update: INUnit IS populated before it gets to my code.  So not sure why ValidateUnitConversions would not find it.

Not trying to add to INUnit, just INItemCost.  I set a breakpoint and verified only 1 INUnit exists in cache and in database before my code runs (After CreateUpdateMatrixItems)

Ignore my earlier comment where I was thinking this was not the case.  Once I realized it was there I never actually tried adding to INUnit.

Problem solved.  Bonehead mistake. 

I had:

graph.Item.Current = item

instead of

itemGraph.Item.Current = item

So I was setting Item.Current on the wrong instance of the InventoryItemMaint graph.  

Thanks again for all your help.  Really appreciate it. 

I am going to mark your earlier reply (before all this LastCost fiasco) as the best answer.  If we ever meet at an Acumatica conference I will buy you a beer (or two or three) 😄

@rjean09 You are very welcome, it was a nice two weeks of effort :)
Welcome to the club, now you can use the “I Customized the Matrix” badge :)