Advice on which event handler to use

Hi Joe,  Hope you are doing well!

You can bring the Last Vendor Price value from the Stock Item screen to the PO screen using the below event.

POLine_InventoryID_FieldUpdated event.

Hope this helps!

I think I know how to do that.  I’ll give it a try.

Would you create a dummy field for this and populate it with BQL?

Thanks Naveen.  No wonder you got an MVP award!

@joe21  Just create a BQL to the “POVendorInventory” table to fetch the Last Vendor Price for the Purchase Order Vendor and assign it to the newly created field at POLine.

I simply copy/pasted your code and voila.  You saved me so much trial and error.

The only think I had to do is change PXDBDecimal to PXDecimal because it is an unbound field

I added this section in order to populate that field when viewing an existing order.  It is also just a copy/paste from your script.

        protected void POLine_RowSelected(PXCache cache, PXRowSelectedEventArgs e)
        {
            var row = (POLine)e.Row;

            if (row != null)
            {
                POVendorInventory objPOVendorItem = PXSelect<POVendorInventory, Where<POVendorInventory.vendorID, Equal<Required<POVendorInventory.vendorID>>,
                    And<POVendorInventory.inventoryID, Equal<Required<POVendorInventory.inventoryID>>>>>.Select(Base, Base.Document.Current.VendorID, row?.InventoryID);
                if (objPOVendorItem != null)
                {
                    row.GetExtension<POLineExt>().UsrLastVendorPrice = objPOVendorItem.LastPrice ?? 0m;

                }
            }
        }
 

I’ve never used InvokeBaseHandler?.Invoke(cache, e);  Where would I ever learn about that?  That command was not part of the training series.  Is there another training series that would teach me about things like that?   

Also, in your PXSelect, you have this: row?.InventoryID   What is the reason for the “?” after row?  

Naveen, thank you so much.

Hi @joe21  Most Welcome :)

Here are my suggestions, please find the details below.

• Since you wanted to go with the unbound field, you have the logic in the “POLine_UsrLastVendorPrice_FieldSelecting” instead of RowSelected event (No BQL’s allowed to write in this event)
• When we are writing the event for default Acumatica fields, first we should invoke the Base logic, then our logic should be executed. → To invoke the Base logic code we should use this code → InvokeBaseHandler?.Invoke(cache, e);
• “?”, this is C# concept i.e. Nullalble type. I always use like this to avoid the Object/Null reference issues.

 protected virtual void POLine_UsrLastVendorPrice_FieldSelecting(PXCache cache, PXFieldSelectingEventArgs e)
        {
            POLine row = e.Row as POLine;
            if (row != null)
            {
                POVendorInventory objPOVendorItem = PXSelect<POVendorInventory, Where<POVendorInventory.vendorID, Equal<Required<POVendorInventory.vendorID>>,
                       And<POVendorInventory.inventoryID, Equal<Required<POVendorInventory.inventoryID>>>>>.Select(Base, Base.Document.Current.VendorID, row?.InventoryID);
                if (objPOVendorItem != null)
                {
                    e.ReturnValue = objPOVendorItem.LastPrice ?? 0m;
                }
            }
        }

In the above field selecting code, “InvokeBaseHandler” this code is not required, since it is our custom field, hence I have not added this code.