Last Ordered Date For Stock Items

Hi @sandy95,

I’m assuming that below is your requirement.

In the Stock Item screen, you have added a new customization field and you want to show the Last Ordered Date of that SKU in that field.  

If this is your requirement, then yes, it more of customization, and below are the steps.

You need to extend the SOOrderEntry graph and add a logic to update the “LastOrderedDate” in the Stock Item screen of the 1st Save of the Sales Order (Persist Delegate).

Hope this helps!!

Hi @sandy95 ,

I wrote a sample example code just now, where I’m updating LastOrderedDate in the Stock Items screen for the particular SKUs.

Please modify according to your DAC field names.

 public class SOOrderEntryExt : PXGraphExtension<SOOrderEntry>
        {

            public delegate void PersistDelegate();
            [PXOverride]
            public void Persist(PersistDelegate del)
            {

                #region Check Del
                try
                {
                    if (Base.Document.Current != null)
                    {
                        if (Base.Document.Cache != null && Base.Document.Cache.GetStatus((object)Base.Document.Current) == PXEntryStatus.Inserted)
                        {
                            InventoryItemMaint itemMaint = PXGraph.CreateInstance<InventoryItemMaint>();

                            foreach (SOLine objSOLine in Base.Transactions.Select())
                            {
                                InventoryItem objInventoryItem = PXSelect<InventoryItem, Where<InventoryItem.inventoryID, Equal<Required<InventoryItem.inventoryID>>>>.Select(Base, objSOLine.InventoryID);
                                if (objInventoryItem != null)
                                {
                                    InventoryItemExt itemExt = objInventoryItem.GetExtension<InventoryItemExt>();
                                    itemExt.LastOrderedDate = Base.Document.Current?.OrderDate;
                                    itemMaint.Item.Cache.Update(objInventoryItem);
                                }
                            }
                            itemMaint.Actions.PressSave();
                        }

                        del();
                    }
                }
                catch (Exception ex)
                {
                    throw new PXException(ex.Message);
                }
            }
        }

Hope this helps!!