Subscribing to changes in sales order total changes

markcle
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:
Another thing I thought of was this, but there's no OnAftervalidate event on Line Amount
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.
Anyone got a suggestion on how to do it?
Thanks
Mark
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
0
Answers
-
OnAfterValidateEvent in T37 has a parameter for the field too. You'll probably want to look into this.0
-
-
Strange. If you run page 9510 Event Subscriptions, is it visible? If it is, is it in error?0
-
[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!0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions