Options

Subscribing to changes in sales order total changes

markclemarkcle Member Posts: 65
Hi All

Fairly new to Nav Extension Development (using AL)

I need to figure out when the total before tax changes for a sales order (seems to be a flow field).

When the total (or any line total would work) changes, I need to get the current total of all lines that are not freight (a specific set of item nos) and update the price for the freight item. I know I could use a trigger on the SalesLine.LineAmount, but I understand Event Subscriptions are a better approach.

I ran event recorder to see what events there are



I tried this, but it triggers my subscription for every single field that the user modifies when entering a line and also when the order opens:
codeunit 50002 SubSalesLines
{
    EventSubscriberInstance = StaticAutomatic
 
    [EventSubscriber(ObjectType::Table, Database::"Sales Line", 'OnAfterModifyEvent', '', true, true)]
}


Another thing I thought of was this, but there's no OnAftervalidate event on Line Amount
codeunit 50002 SubSalesLines
{
    EventSubscriberInstance = StaticAutomatic
 
    [EventSubscriber(ObjectType::Page, Page::"Sales Order Subform", 'OnAfterValidateEvent', 'Line Amount', true, true)]
}


Only other option I see is subscribing to all the fields that could change the price (would have to be at least customer, unit price, discount, tax code, tax area, qty, item, order date, price group, discount group, and I'm sure a bunch more

e.g.
codeunit 50002 SubSalesLines
{
    EventSubscriberInstance = StaticAutomatic
 
    [EventSubscriber(ObjectType::Page, Page::"Sales Order Subform", 'OnAfterValidateEvent', 'Quantity', true, true)]
}


Anyone got a suggestion on how to do it?

Thanks

Mark

Answers

  • Options
    TallyHoTallyHo Member Posts: 383
    OnAfterValidateEvent in T37 has a parameter for the field too. You'll probably want to look into this.
  • Options
    markclemarkcle Member Posts: 65
    TallyHo wrote: »
    OnAfterValidateEvent in T37 has a parameter for the field too. You'll probably want to look into this.

    Thanks for reply. I tried this, but my code never got called

    [EventSubscriber(ObjectType::Table, Database::"Sales Line", 'OnAfterValidateEvent', 'Line Amount', true, true)]
  • Options
    TallyHoTallyHo Member Posts: 383
    Strange. If you run page 9510 Event Subscriptions, is it visible? If it is, is it in error?
  • Options
    krikikriki Member, Moderator Posts: 9,096
    [Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


Sign In or Register to comment.