Add a calculated field to SO Lines?

With some help from ChatGPT, I managed to get the code below to validate and published. The problem now is that the calculation is not correct. For example on an order with a line with a quantity of 901pcs, and 902pcs are available, the Remaining Qty column is showing 901pcs.

 

   // Field-Selecting event handler for the OrderQty field on the SOLine DAC
protected virtual void SOLine_OrderQty_FieldSelecting(PXCache cache, PXFieldSelectingEventArgs e)
{
    if (e.Row == null)
        return;

    SOLine line = (SOLine)e.Row;

    if (line.InventoryID != null && line.SiteID != null)
    {
        // Retrieve the Inventory Site Status record
        INSiteStatus siteStatus = PXSelect<INSiteStatus,
            Where<INSiteStatus.inventoryID, Equal<Required<INSiteStatus.inventoryID>>,
                And<INSiteStatus.siteID, Equal<Required<INSiteStatus.siteID>>>>>
            .Select(Base, line.InventoryID, line.SiteID);

        if (siteStatus != null)
        {
            // Calculate the Quantity Available by subtracting the Ordered and Shipped quantities
            decimal qtyAvailable = (siteStatus.QtyAvail.GetValueOrDefault() - siteStatus.QtySOShipping.GetValueOrDefault());
            decimal orderQty = line.OrderQty.GetValueOrDefault();
            decimal qtyRemaining = qtyAvailable - orderQty;

            // Set the calculated remaining quantity to the UsrQtyRemaining field in the SOLineQtyRemaining DAC extension
            SOLineQtyRemaining lineExt = PXCache<SOLine>.GetExtension<SOLineQtyRemaining>(line);
            lineExt.UsrQtyRemaining = qtyRemaining;

            // Set the calculated remaining quantity as the return value for the field-selecting event
            e.ReturnValue = qtyRemaining;
        }
    }
}

#endregion
  }
}

Hi @Denham  Great! Thanks for sharing the update.

Let me know if you need any help.

Hi Kathlyn

In this case, we are using this field to tell us the remaining quantity of an inventory item after the sales order is fulfilled(Qty Available - Line Qty). We have some items which are extremely fast movers, that are also very difficult to acquire stock. So we are using this field to reduce quantity on orders as we see fit, depending on the amount of stock that will remain after the order is fulfilled.