Auto update of Sales Order line discount through business event when order total hits the specified amount.

Hi ​@vishalsharma49 

This could be done with an import scenario and business event, however, I think a code customisation would perform better.

A FieldUpdated handler could be used similar to this:

protected virtual void _(Events.FieldUpdated<SOOrder, SOOrder.orderTotal> e, PXFieldUpdated b)
{
    b?.Invoke(e.Cache, e.Args);

    SOOrder row = e.Row;
    if (row == null) return;

    SOLine line = SelectFrom<SOLine>.
        Where<SOLine.orderType.IsEqual<P.AsString>.
        And<SOLine.orderNbr.IsEqual<P.AsString>>>.View.Select(Base, row.OrderType, row.OrderNbr);
    if(line == null) return;

    if (row.OrderTotal > someNumber)
    {
        line.CuryDiscAmt = someDiscountNumber;
        line.DiscPct = someDiscountPercentage;

    }
}

Fill in the someNumber, someDiscountNumber/Percentage with actual figures rather than the phrases.

Hope this helps,

Aleks

protected virtual void _(Events.FieldUpdated<SOOrder, SOOrder.orderTotal> e, PXFieldUpdated b)
{
    b?.Invoke(e.Cache, e.Args);

    SOOrder row = e.Row;
    if (row == null) return;

    SOLine line = SelectFrom<SOLine>.
        Where<SOLine.orderType.IsEqual<P.AsString>.
        And<SOLine.orderNbr.IsEqual<P.AsString>>>.View.Select(Base, row.OrderType, row.OrderNbr);
    if(line == null) return;

    if (row.OrderTotal > someNumber)
    {
        line.CuryDiscAmt = someDiscountNumber;
        line.DiscPct = someDiscountPercentage;

    }
}

Thanks Aleks i appreciate your reply but i was looking through business event to trigger this condition.

​@vishalsharma49 

Personally, I haven’t been able to configure an import scenario to run from a business event, they can be quite finnicky, hence the code version.

You would want to configure the business event to run similar to this:

Are you familiar with import scenarios, if not, it would look something like this:

But unfortunately, the business event fires but the import scenario does not:

Thanks for that ​@DrewNisley!

Thanks ​@DrewNisley and ​@aiwan for your solutions.