I want to add info to the bottom of the Sales Order - Details grid based on the selected row’s inventory ID. Need to be able to display the last sale price and discount fields for the order’s customer and the line’s item. Is this possible? I drew in where I would like for the info to go.. Thanks in advance
Best answer by Naveen Boga
Hi
Please find the sample code below.
public virtual void SOLine_Availability_FieldSelecting(PXCache sender, PXFieldSelectingEventArgs e, PXFieldSelecting invokeBaseHandler)
{
invokeBaseHandler(sender, e);
// add logic to bring the Sales Price
//var lastSalesPriceValue = GetLastSalesPrice();
e.ReturnValue = "Last Sales Price" + lastSalesPriceValue;
}
+19Hi
Please find the sample code below.
public virtual void SOLine_Availability_FieldSelecting(PXCache sender, PXFieldSelectingEventArgs e, PXFieldSelecting invokeBaseHandler)
{
invokeBaseHandler(sender, e);
// add logic to bring the Sales Price
//var lastSalesPriceValue = GetLastSalesPrice();
e.ReturnValue = "Last Sales Price" + lastSalesPriceValue;
}
Yes this is exactly what I was looking for thank you very much
And inside of the GetLastSalesPrice method, is there a way to do a direct SQL call or am I forced to do a PXSelect type command?
Hi
Please find the sample code below.
public virtual void SOLine_Availability_FieldSelecting(PXCache sender, PXFieldSelectingEventArgs e, PXFieldSelecting invokeBaseHandler)
{
invokeBaseHandler(sender, e);
// add logic to bring the Sales Price
//var lastSalesPriceValue = GetLastSalesPrice();
e.ReturnValue = "Last Sales Price" + lastSalesPriceValue;
}
Thank you
+19If it is the same as above, you can extend the SOOrderEntry Graph, and add the above so that information will be displayed on the Grid Footer.
If it is the same as above, you can extend the SOOrderEntry Graph, and add the above so that information will be displayed on the Grid Footer.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
