I am trying to add some more info to the Availability status at the bottom of Sales Order - Details grid.
Specifically, I am trying to pull the last sold cost for the sales order header’s customer and the sales order detail/line inventory ID field. Is there an imbedded way/function to load this price or will this require the PXSelect methodology? Thanks!
Best answer by Naveen Boga
Hi
public void _(Events.RowPersisting<SOLine> e)
{
var line = e.Row;
if (line == null) return;
var persistedLine = (SOLine)e.Cache.GetOriginal(line);
}
+19Hi
public void _(Events.RowPersisting<SOLine> e)
{
var line = e.Row;
if (line == null) return;
var persistedLine = (SOLine)e.Cache.GetOriginal(line);
}
If I am understanding correctly you are looking to basically surface the most recent sales price for a given customer/inventory item combination?
I don’t believe there is any sort of native functionality for this so you would have to use BQL or FBQL to retrieve the most recent SOLine and graph the price from that.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
